How do I drag a formula keeping cells the same but changing sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I drag formulas so cells stay the same but sheets change? 1
drag formula down from columns that go acros 3
drag a formula downa column keeping one value the same? 2
Dragging a formula in a column 1
keeping same-row(or column) cell constant in a formula while drag- 1
Excel Drag autofill only part of formula 3
using row number or column letters in formula 5
when I drag a formula to other cells the reference is the same 1

Back
Top