Populate Data from Summary Sheet

  • Thread starter Thread starter Youngergirl44
  • Start date Start date
Y

Youngergirl44

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?
 
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.
 
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.
 
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.
 
Back
Top