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

Locking Pages and/or Workbook 1
how should I setup workbook to acheive my desired results? 0
selecting workbook/sheet 3
How to automate update on weekly reports spreadsheet 0
External cell reference between two excel worksheets both in One Drive 0
How can the font and size of (all) citation numbers be altered? 1
Like to start using Access 1
Wonky printout when I print entire workbook 0

Top