![]() |
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