Thread: How do I drag a formula keeping cells the same but changing sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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.




Reply With QuoteReply With Quote