| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling Sheet numbers in a column
There are several sheets in the workbook titled Sh00, Sh10,Sh20...... I am
compiling data form the sheets on to a sheet tilted Sh700. In one of the columns the formula in the first cell is: =Sh00!$L$10. The data in the subsequent cells will increment the previous sheet by 10, i.e. =Sh10!$L$10, =Sh20!$L$10... How can fill the remaining cells without having to manually chaning each Sheet numbers? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change column references, while filling down another column | Excel Discussion (Misc queries) | |||
| Auto Filling one sheet from another | Excel Worksheet Functions | |||
| filling cells acording to the first 3 numbers | Excel Discussion (Misc queries) | |||
| Pre-filling column | Excel Discussion (Misc queries) | |||
| Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
Threaded Mode
