Populate Data from Summary Sheet


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?
 
Ad

Advertisements

Y

Youngergirl44

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.
 
D

Don Guillett

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.
 
Y

Youngergirl44

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.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top