Update workbook pages- how?
 

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
--
Martin
©¿©¬

Update workbook pages- how?
 

On Thursday, April 19, 2012 7:40:08 AM UTC-5, Martin ©¿©¬ wrote:
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
--
Martin
©¿©¬

Why not just use ONE sheet with a column for the district and the use datafilterautofilter

Update workbook pages- how?
 

On Thu, 19 Apr 2012 12:47:38 -0700 (PDT), Don Guillett
wrote:

On Thursday, April 19, 2012 7:40:08 AM UTC-5, Martin ©¿©¬ wrote:
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
--
Martin
©¿©¬

Why not just use ONE sheet with a column for the district and the use datafilterautofilter

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