| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update linked pages | Excel Worksheet Functions | |||
| Add formatting to all pages in workbook | Excel Worksheet Functions | |||
| How do I set my workbook up to print only first 2 pages? | Excel Discussion (Misc queries) | |||
| insert text to different pages and update | New Users to Excel | |||
| how to set up master page that will auto update smaller pages | Excel Programming | |||
![Martin ©¿©¬[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
