Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q: Automated coping of data to other worksheets
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. Some people on this board were kind enough to answer some questions for me in the past, so I thought this might be a good place to start. 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 name 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated coping of data to other worksheets
Why can't you just have your master list and use the autofilter to look at a
specific city. That is essentially what you would do in Access if you chose to go that direction. -- Regards, Tom Ogilvy "A" wrote in message ... 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. Some people on this board were kind enough to answer some questions for me in the past, so I thought this might be a good place to start. 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 name 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coping page set up to other worksheets within the same workbook | Excel Discussion (Misc queries) | |||
coping worksheets with hyperlinks | New Users to Excel | |||
Automated copy between worksheets | Setting up and Configuration of Excel | |||
Automated formula coping | Excel Programming | |||
Coping numbers only in cells to other worksheets. | Excel Programming |