| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Data from Summary Sheet
I want to use a sheet titled "Summary" to populate data in 100+ existing
worksheets within the same workbook. "Summary" contains a list of names and dates. I want the first sheet after "Summary" to pull the first name and date from the list, the second sheet to pull the second name and date, and so on - like this: Sheet titled "Person 1" cell A1 =Summary!$B3 cell E1 =Summary!$A3 Sheet titled "Person 2" cell A1 =Summary!$B4 cell E1 =Summary!$A4 Sheet titled "Person 3" cell A1 =Summary!$B5 cell E1 =Summary!$A5 Is there a way to copy the formula across all 100+ sheets, changing the row referenced on the "Summary" sheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need conditional data from 1 sheet to populate another sheet | Excel Worksheet Functions | |||
| Consolidate data to summary sheet | Excel Discussion (Misc queries) | |||
| Populate order sheet with data from work sheet | Excel Worksheet Functions | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| populate cells with data from another sheet | Excel Worksheet Functions | |||
Threaded Mode
