| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering a number on any sheet one time only | Excel Discussion (Misc queries) | |||
| point to one number on each sheet that will be in many formulas | New Users to Excel | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How to autofill data from one sheet into another | Excel Worksheet Functions | |||
| How do I change the number on copy sheet so I don't have to renam | Excel Worksheet Functions | |||
Hybrid Mode
