Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically increment worksheet number when pasting a .
I'm using Excel 2003. I have multiple similar worksheets in a workbook. I
want to summarize data from the similar worksheets to "master" worksheet also in the same workbook. For example I want to extract the data from cell D2 from all the similar worksheets to a column on the master worksheet. This formula (='Sheet1 (2)'!D2) will reference the data in Cell D2 from Sheet1 (2). If I copy and paste it in into multiple column cells Excel will automatically increment the cell identifier D3, D4, D5 etc. Is it possible to have Excel increment the Sheet identifier Sheet1 (3), Sheet1 (4), Sheet1 (5)..etc when doing a copy/paste. Or does anyone have a better idea to automate this task? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Automatically number multiple sheets | Excel Discussion (Misc queries) | |||
How to print a worksheet but number the pages by workbook | Excel Discussion (Misc queries) | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions |