| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Worksheet Cells Getting 0's | Excel Discussion (Misc queries) | |||
| copying cells to another worksheet | Excel Worksheet Functions | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Copying cells from 1 worksheet to another | New Users to Excel | |||
| copying cells to another worksheet | Excel Worksheet Functions | |||
Threaded Mode
