| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increasing Sheet Numbers by one on fill down command
Hi everyone - hope someone can help me
I created multiple sheets with the same formulas, now i need a report sheet to collect information from these sheets: Exp: Sheet1, Cell A1 = Sheet2, Cell $A$1 Sheet1, Cell A2 = Sheet3, Cell $A$1 Sheet1, Cell A3 = Sheet4, Cell $A$1 If I want the cell number to increase by 1 I remove the dollar sign, but I can not find a way to increase the sheet number by 1, and having 250 sheets it will take ages to adjust manually. Can anyone help me please? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increasing Sheet Numbers by one on fill down command
If you sheet names are sheet1,sheet2..... sheet30
Then copy this formula in A1 and copy down =INDIRECT("Sheet" & ROW()&"!A1") You can also do it with a macro http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "albertmb" wrote in message ... Hi everyone - hope someone can help me I created multiple sheets with the same formulas, now i need a report sheet to collect information from these sheets: Exp: Sheet1, Cell A1 = Sheet2, Cell $A$1 Sheet1, Cell A2 = Sheet3, Cell $A$1 Sheet1, Cell A3 = Sheet4, Cell $A$1 If I want the cell number to increase by 1 I remove the dollar sign, but I can not find a way to increase the sheet number by 1, and having 250 sheets it will take ages to adjust manually. Can anyone help me please? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MIcrosoft Excel: should allow sheet increase by 1 on fill down | Excel Discussion (Misc queries) | |||
| I cannot see my fill color on my spread sheet. I disappears | Excel Discussion (Misc queries) | |||
| Command Button Moves when sheet printed | Excel Discussion (Misc queries) | |||
| Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Hybrid Mode
