Update workbook pages- how?

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
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
 
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>>>>>
 
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?
 
Back
Top