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,

Why not just filter the list (Tools Auto Filter) This will allow you view
different cities independantly but also make the changes for you and keep
everything in one sheet (much easier when data needs to be extrapolated).


--
JNW


"A" wrote:

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,

YOU COULD ALSO USE THE VLOOKUP function...

If VANCOUVER is found to be the city, then place it in the VANCOUVER sheet,
and so on, and so on..

THE VLOOKUP routine may be your RSVP.

FLKULCHAR

"JNW" wrote:

Why not just filter the list (Tools Auto Filter) This will allow you view
different cities independantly but also make the changes for you and keep
everything in one sheet (much easier when data needs to be extrapolated).


--
JNW


"A" wrote:

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,

You could do this if you really want the information on multiple sheets.
I've redone complete workbooks that were originally done like this because
they became too cumbersome to function. Here are my reasons:

1-It's not an automatic thing. You have to pysically add all of the
formulas to the "Vancouver" sheet in order to get everything to show up.
2-Unless the city in in the very first column you'll have a hard time
setting it up
3-What if a column is added? All the VLookup formulas will need to be
changed.
4-If you add a new city you must then add a new sheet along with all of the
formulas
5-VLookup will only return the first match in a column. If you have
multiple entries for a given city you would need to use an IF function. If
you use the IF function you will have to reference row by row and then hide
the rows that don't have anything. You would likely use autofilter to hide
these rows which defeats the purpose of having multiple sheets if you can
just autofilter the entry sheet to begin with.

You may also look into putting the database in Access since that is what
Access was built for. But I understand that there are reasons against this.


--
JNW


"F. Lawrence Kulchar" wrote:

YOU COULD ALSO USE THE VLOOKUP function...

If VANCOUVER is found to be the city, then place it in the VANCOUVER sheet,
and so on, and so on..

THE VLOOKUP routine may be your RSVP.

FLKULCHAR

"JNW" wrote:

Why not just filter the list (Tools Auto Filter) This will allow you view
different cities independantly but also make the changes for you and keep
everything in one sheet (much easier when data needs to be extrapolated).


--
JNW


"A" wrote:

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,