| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link data from multiple workheets
I have data stored in multiple worksheets with identical layout (eg reference
no is always in cell B2 for every sheet). I would like to summarise selected data onto a single sheet with the data presented in rows. I would like to insert data from sheet 2!B2 into sheet 1!B2 and then from sheet 3!B2 to sheet 1!B3 etc. I can create link from sheet 2 to sheet 1 but if I try to copy the link formua down, it links sheet 1!B3 to sheet 2!B3 and not sheet 3. Can I make the link reference jump to the next sheet each time? is this possible? Martin McLaughlin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link multiple worksheets while extracting data | Excel Worksheet Functions | |||
| How do I link data between multiple excel spreadsheets | Excel Discussion (Misc queries) | |||
| How do I link lots of data in multiple worksheets | Excel Worksheet Functions | |||
| What formula can i use to populate info from 2 other workheets ? | New Users to Excel | |||
| Link Data from Multiple Worksheets | Excel Worksheet Functions | |||
Threaded Mode
