| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Data across worksheets
an indirect function can do this with a little manipulation
if you start in row 3 for example =indirect("'Sheet"&row()-2&"'!A1") and copy this equation down it should do what you want. "nelsquid" wrote: Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then just click and drag and have the formula automatically go the the next sheet? i.e "='Sheet2'!A1" instead of "='Sheet1'!A2" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Consolidate' data from multiple worksheets | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
