I have a "database" in Excel I created that organizes people by location.
Those locations could change at any time. I got the master location list
included for data validation on my data table (List drop-down) that updates
itself when a location changes. What I would like to happen is when a
location changes values, have the old value be replaced by the new one in the
data tab automatically. Can it be done and if so how? Ideally, I would like
this to be done behind the scenes as you type.
--
I am running on Excel 2003, unless otherwise stated.

Say we use TWO location tables, Current and New. The macro would run down
each person, and if the location has changed, update the record.

Once the people check is complete, the macro could copy the New table onto
the Current table. This insures that the validation pull-down is also
correct.
--
Gary''s Student - gsnu200813


"Orion Cochrane" wrote:

I have a "database" in Excel I created that organizes people by location.
Those locations could change at any time. I got the master location list
included for data validation on my data table (List drop-down) that updates
itself when a location changes. What I would like to happen is when a
location changes values, have the old value be replaced by the new one in the
data tab automatically. Can it be done and if so how? Ideally, I would like
this to be done behind the scenes as you type.
--
I am running on Excel 2003, unless otherwise stated.

I got around the issue with a userform, and it works great. Thanks, Gary's
Student.
--
I am running on Excel 2003, unless otherwise stated.


"Gary''s Student" wrote:

Say we use TWO location tables, Current and New. The macro would run down
each person, and if the location has changed, update the record.

Once the people check is complete, the macro could copy the New table onto
the Current table. This insures that the validation pull-down is also
correct.
--
Gary''s Student - gsnu200813


"Orion Cochrane" wrote:

I have a "database" in Excel I created that organizes people by location.
Those locations could change at any time. I got the master location list
included for data validation on my data table (List drop-down) that updates
itself when a location changes. What I would like to happen is when a
location changes values, have the old value be replaced by the new one in the
data tab automatically. Can it be done and if so how? Ideally, I would like
this to be done behind the scenes as you type.
--
I am running on Excel 2003, unless otherwise stated.

The data validation updates itself anyways (thank goodness), but it was with
the current values I needed to change. Thanks.
--
I am running on Excel 2003, unless otherwise stated.


"Gary''s Student" wrote:

Say we use TWO location tables, Current and New. The macro would run down
each person, and if the location has changed, update the record.

Once the people check is complete, the macro could copy the New table onto
the Current table. This insures that the validation pull-down is also
correct.
--
Gary''s Student - gsnu200813


"Orion Cochrane" wrote:

I have a "database" in Excel I created that organizes people by location.
Those locations could change at any time. I got the master location list
included for data validation on my data table (List drop-down) that updates
itself when a location changes. What I would like to happen is when a
location changes values, have the old value be replaced by the new one in the
data tab automatically. Can it be done and if so how? Ideally, I would like
this to be done behind the scenes as you type.
--
I am running on Excel 2003, unless otherwise stated.