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
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