Functions

AutoFill Changing Wrong Value
I'm trying to create an analysis sheet that gathers data from 100 worksheets within the same workbook. I want the same cell reference in each sheet, but to change the sheet number in each cell. The worksheets are named 1 - 100 Here is the formula: ='1'!B3:E3 It changes the cell references only, not th... 9 Mar 2010 10:04

Drag Down Formula Incorrect
I've got a long list of text data in column A, and am using the MID command to extract one bit of data from each which is then inserted into four columns (B-E) e.g. B9 =MID(A27,23,2) C9 =MID(A28,23,1) D9 =MID(A29,23,5) E9 =MID(A31,23,5) When I drag down B9, I want the formula to change by 20 (from A27 to A... 9 Mar 2010 05:39

Import multiple photos into excel
I am trying to create a photo sheet that will allow me to import all photos in a directory into an excel spreadsheet. I want it to: Import all images in a directory. (even if I have to choose to open the folder and then select all) Place each photo into a separate box Auto-format all the photos to the same size... 10 Mar 2010 15:21

Import multiple photos into excel
I am trying to create a photo sheet that will allow me to import all photos in a directory into an excel spreadsheet. I want it to: Import all images in a directory. (even if I have to choose to open the folder and then select all) Place each photo into a separate box Auto-format all the photos to the same size... 8 Mar 2010 23:09

Import multiple photos into excel
I am trying to create a photo sheet that will allow me to import all photos in a directory into an excel spreadsheet. I want it to: Import all images in a directory. (even if I have to choose to open the folder and then select all) Place each photo into a separate box Auto-format all the photos to the same siz... 8 Mar 2010 23:09

Summary
i have a transaction of a few people with the figures. i can only get the total amount using the filter. so, i want to have a summary in another worksheet. IS there anyway to do the summary? cos..once i change the filter in the sheet 1, the total is different. Please help!. Thank you. ... 9 Mar 2010 22:39

Group information from several worksheets into one worksheet
I have 55 sheets, each sheet has 11 questions (one per column b5- k5 which are exactly the same. Each sheet is for 1 person to enter details, entering a number between 1 and 10 depending on the question. This is filled in weekly over a 52 week period. The rows are dated for each monday The 55 sheets are dated ... 9 Mar 2010 04:34

IF, AND for different Columns
I have a worksheet for a meeting that I am trying to get to where I can use the formula's and it will calculate as soon as the data is pasted from another report. I need the following: Column E will have the following options: BUY STK BUY/STK STK/BUY FRT Column F will have the following options: ... 8 Mar 2010 19:50

Macros running with Validation Rules
I have a worksheet with Validation rules set. But what I need to set is a Macro that runs when the Validation Item List is changed to “Contracted” I would like it to Copy the item that was changed to a Sheet set as Contracted Projects. How can this be obtained? ... 8 Mar 2010 19:50

Can a cell be turned on or off?
A1=B1*C1+D1 A2=B2*C2+D2 A3=B3*C3+D3 A4=B4*B4+B4 I would like to be able the have the total in any one of the A cells to add up only if the cell is click on. In other words, can a cell be turned off or on as needed? -- Joe ... 8 Mar 2010 19:50