Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference worksheets in ascending order
Hi
I'm trying to build a summary worksheet that draws various data from other worksheets with names like "sell 01", "sell 02", and so on. I want to make a vertical list referencing cell A2 in each worksheet, increasing by one number for each additional row. This is easy in the same sheet, i.e., =A1+1 copy-paste. How can I add to a sheet reference? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference worksheets in ascending order
On your summary work sheet, assuming your data starts on row 2, you could use
the following formula: =INDIRECT("'Sell "&TEXT(ROW()-1,"00")&"'!A2") the -1 after the row is because you need some method to count which sheet you are trying to show the value of, if your data on your summary sheet started on row 7, for example, it would be a -6 instead. Hope this helps! -- John C "mattjdohm" wrote: Hi I'm trying to build a summary worksheet that draws various data from other worksheets with names like "sell 01", "sell 02", and so on. I want to make a vertical list referencing cell A2 in each worksheet, increasing by one number for each additional row. This is easy in the same sheet, i.e., =A1+1 copy-paste. How can I add to a sheet reference? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I short worksheets ascending or descending order ? | Excel Worksheet Functions | |||
How to sort worksheets in alphabetical order (descending or ascending)? | Excel Discussion (Misc queries) | |||
How do I arrange/sort worksheets in ascending order? | Excel Discussion (Misc queries) | |||
Excel worksheets needs to sort ascending or descending order. | Excel Worksheet Functions | |||
Digits in ascending order ? | Excel Worksheet Functions |