Update workbook pages- how?

M

Martin ©¿©¬

Hi
I have a workbook with 16 pages/sheets
Each sheet is a district & has name, addresses, numbers etc on it.
I have occassion to update these sheets, or create labels or envelopes
from them.
What I would like to do is create a master district sheet which would
mirror changes on the 16 sheets automatically.
How would I accomplish this?
Thank you
 
D

Don Guillett

Hi
I have a workbook with 16 pages/sheets
Each sheet is a district & has name, addresses, numbers etc on it.
I have occassion to update these sheets, or create labels or envelopes
from them.
What I would like to do is create a master district sheet which would
mirror changes on the 16 sheets automatically.
How would I accomplish this?
Thank you
Click to expand...

Why not just use ONE sheet with a column for the district and the use data>filter>autofilter>>>>>
 
M

Martin ©¿©¬

Why not just use ONE sheet with a column for the district and the use data>filter>autofilter>>>>>
Click to expand...

I might Don, but I don't know how to do that.
Can u tell me how please?
 

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

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Excel shortcut options 0
In Excel how do I update cells in multiple sheets simultaneously? 1
Update links 1
how do i print two workbook sheets onto one page side by side? 1
COPY AND PASTE CUMULATIVE VALUES TO 17 SHEETS 3
Link one worksheet in a workbook to another worksheet in same work 1
Need to merge worksheets - Excel 2003 0

Top