Thread: Copying worksheet cells into another worksheet using autofill
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SunnySD SunnySD is offline
external usenet poster
  
Posts: 1
Default Copying worksheet cells into another worksheet using autofill
I have 31 worksheets to copy into another worksheet and the cell # is the
same. What's the best formula to use to autofill?

Currently, I am getting this:
='1st'!$F$21
='1st'!$F$21
='1st'!$F$21

I need it to show this:
='1st'!$F$21
='2nd'!$F$21
='3rd!$F$21
and so on...

Any help is appreciated!

Reply With QuoteReply With Quote