Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I drag a formula keeping cells the same but changing sheets
I would like to drag a formula across a spreadsheet but would like the cell
numbers to stay the same but the worksheet to change. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I drag a formula keeping cells the same but changing sheets
Do you mean something like =Sheet1!A1 becoming =Sheet2!A1, =Sheet3!A1, etc
Try =INDIRECT("Sheet"&COLUMN(A1)&"!$A$1") The Column(A1) when dragged to the right will give the required 1,2,3.... best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Claire" wrote in message ... I would like to drag a formula across a spreadsheet but would like the cell numbers to stay the same but the worksheet to change. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I drag a formula keeping cells the same but changing sheets
Now I have seen your first post! You have sheets named Nov 07, Dec 07
Enter these names in A1:J1 but you must precede each with a single quote to stop Excel treating them as dates In A2 enter =INDIRECT("'"&A1&"'!$AX$4") Drag this across the row best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Claire" wrote in message ... I would like to drag a formula across a spreadsheet but would like the cell numbers to stay the same but the worksheet to change. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I drag formulas so cells stay the same but sheets change? | Excel Worksheet Functions | |||
Keeping the correct cells when making a formula? | Excel Worksheet Functions | |||
Copy drag formula down cells | Excel Worksheet Functions | |||
How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Cannot drag content or formula to another cells | Excel Discussion (Misc queries) |