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? |
All times are GMT +1. The time now is 05:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com