ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofill with sheet number increasing (https://www.excelbanter.com/excel-discussion-misc-queries/88715-autofill-sheet-number-increasing.html)

Jamo

Autofill with sheet number increasing
 
I am building a workbook that has a summary sheet and several worksheets. Is
there a way to drag and autofill so that the fomula will change the sheet
number?
Example: Sheet1, Cell A1 is equal to Sheet2, Cell D1. I would like to drag
this formula down so it it will auto fill Sheet1, cell A2 as being equal to
Sheet3, cell D1 and then Sheet 1, cell A3 equal to Sheet4, cell D1 and so on.
Is this possible?


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com