sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
When I first thought of this project, I thought it would be easy. And it is....except for the automatic part, unless I'm missing something (which I probably am, it's Monday and not all neurons are firing).
So I've got a list of children's names, along with their parents' names, phone, email, etc......the distinction between them is they're not all in the same program.
For simplification, say the programs are AM, PM, and All Day.
What I'd LIKE to do is have a master list where ALL are entered, regardless of program. Then I'd like separate tabs for each program where only those in that program display in the list.
Easy, you say- turn each sheet including the master into a matching table, use a formula to pull all the data in, then filter each sheet by the desired program.
Yes, that works...but when I add to the master, the other tabs won't automatically update. Pivot tables would be convoluted- there's 18 columns of info per child (plus they need refreshing).
My desired end result would mean I can update the master and the other sheets update with no further edit, because I'd like to protect these sheets so ONLY I can update/edit, others can only view...but all the info they need autoupdates as I add to the master.
So I've got a list of children's names, along with their parents' names, phone, email, etc......the distinction between them is they're not all in the same program.
For simplification, say the programs are AM, PM, and All Day.
What I'd LIKE to do is have a master list where ALL are entered, regardless of program. Then I'd like separate tabs for each program where only those in that program display in the list.
Easy, you say- turn each sheet including the master into a matching table, use a formula to pull all the data in, then filter each sheet by the desired program.
Yes, that works...but when I add to the master, the other tabs won't automatically update. Pivot tables would be convoluted- there's 18 columns of info per child (plus they need refreshing).
My desired end result would mean I can update the master and the other sheets update with no further edit, because I'd like to protect these sheets so ONLY I can update/edit, others can only view...but all the info they need autoupdates as I add to the master.