| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate Data from Summary Sheet
Sure, but WHY when you can just use datafilterautofilter
-- Don Guillett Microsoft MVP Excel SalesAid Software "Youngergirl44" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate Data from Summary Sheet
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Youngergirl44" wrote in message ... I'm not using the subsequent sheets to view just one person at a time - they're used for different calculations specific to each person. The only thing that's the same about each of the 100+ sheets is the name and date, which I would like to look up from the "Summary" sheet. "Don Guillett" wrote: Sure, but WHY when you can just use datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "Youngergirl44" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate Data from Summary Sheet
If it helps, the workbook is going to be used to calculate interest on
security deposit payments. The "Summary" sheet contains a list of the tenants in the building, their unit number, status, move-in date, and other general lease information - a snapshot of the building. The subsequent sheets are for keeping track of when a deposit was paid, the interest rate applicable, dates on which the interest is payable, interest accrued per period, when and how interest payments were made to the tenant, etc. "Don Guillett" wrote: Sure, but WHY when you can just use datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "Youngergirl44" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate Data from Summary Sheet
I just sent an email with before and after examples.
Thanks! "Don Guillett" wrote: If desired, send your file to my address below along with this msg and a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Youngergirl44" wrote in message ... I'm not using the subsequent sheets to view just one person at a time - they're used for different calculations specific to each person. The only thing that's the same about each of the 100+ sheets is the name and date, which I would like to look up from the "Summary" sheet. "Don Guillett" wrote: Sure, but WHY when you can just use datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software "Youngergirl44" wrote in message ... 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? |
| Reply |
| 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 | |||
Linear Mode
