Thread
:
Populate Data from Summary Sheet
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett