![]() |
|
#2
|
||||
|
||||
|
I really don't see the point of having all these tabs.
Surely it would be simpler to use a single worksheet with containing two columns: one for each street and the other for the suburb, with autofilters on each, so the users can choose all streets for one or more suburbs, or all suburbs with the same street name? If someone needs to add a new street, that can be done anywhere, by inserting a new row with the suburb & name data, even when the filters are on. See attached demo using US States & Locales. Even a novice will soon learn to use the filters.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| linked data, pivot tables, two-way edit & updates |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Update Link very slow -PowerPoint Charts & object, cells etc Linked to Excel | johnseito | PowerPoint | 0 | 01-28-2014 06:24 PM |
Excel linked charts don't update
|
jrdnoland | PowerPoint | 4 | 02-25-2013 09:20 AM |
data linked from excel sheet
|
megatronixs | Word VBA | 1 | 08-19-2012 11:09 PM |
| Linked Image automatic update? | uzapuca | PowerPoint | 0 | 04-23-2011 02:03 AM |
| PowerPoint Master - 50 LINKED slides - SLOW Update | salfonsi | PowerPoint | 0 | 09-27-2008 02:55 PM |