Master list reflections and changes

adweaver

New Member
Joined
Sep 18, 2006
Messages
23
Hi,

I have a somewhat complicated workbook that I would like to create, but
I'm not sure if it's even possible with excel.

Say I have a list of customers

Name Address City Postal Contact ETC.

I would like to (within the same workbook) create 10 pages, where each
one represents a city that I deal with.

Page 1 (my list of customers) would be a master list, where every
customer entry is represented.

Page 2 would be, say, Vancouver, and all the entries on the master list
that have Vancouver under the City heading, would be repesented on that
page.

Page 3 would be another city and so on.

Now, here's the functionality I'm looking for.

If I go to the list of Vancouver accounts (on the Vancouver page) and
change the city of an account to Surrey, I would like it to update that info on the master list, disappear from the Vancouver page, and show up on the Surrey page.

Is this possible with Excel? Is this something that would be better
suited for Access? I'm using these excel workbooks on a pda and then
updating them in my system daily, so I'm hoping to keep it in excel (I
don't think I can use Access on my pocket PC, but I may be mistaken).

Your thoughts and opinions are appreciated.

Regards,

A
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Excel can do what you are asking, but your "functionality" request seems backwards to me. You shouldn't make changes to a sub page of your Master data and then try to push that change back to the Master list. Any changes should be made directly to the master list and your "pages" can be re-created each time you access them.
I would suggest using Advanced Filter to rebuild your city sheets each time you open them. Then they will always have the latest data.
You could use a UserForm on your master list page to add/edit your data.
Take a look at this link that explains the features of UserForms. It includes detailed instructions on how to set up a userform to maintain a list of data.
http://www.contextures.com/xlUserForm01.html
Hope you find this helpful.
 

Forum statistics

Threads
1,137,204
Messages
5,680,166
Members
419,887
Latest member
Vasokir

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top