ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copying changes from one worksheet to other worksheets (https://www.excelbanter.com/excel-worksheet-functions/126537-copying-changes-one-worksheet-other-worksheets.html)

Steve

Copying changes from one worksheet to other worksheets
 
I manage a data base consisting of names, addresses including unit and phase
numbers. On worksheet one, I have the data sorted by last name, on worksheet
two I have the same data sorted by unit number and on the third worksheet I
have the data sorted by phase number. How can I make a change to worksheet
one and those changes be made on worksheets two and three?

Martin Fishlock

Copying changes from one worksheet to other worksheets
 
Hi Steve:

Why don't you make three macros that will sort the data based on one of the
three sort keys. Then you just click the sort key and it will sort it.

Much easier than keeping two duplicates of the original data.

BTW you need to write an on change macro to pick up changes and replicate
them through the other two sheets.

It is not as easy as they are in different orders. So you need to use the
unique key to find them.

If you post a sample of your DB maybe somebody coluld help with a sort
routine.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Steve" wrote:

I manage a data base consisting of names, addresses including unit and phase
numbers. On worksheet one, I have the data sorted by last name, on worksheet
two I have the same data sorted by unit number and on the third worksheet I
have the data sorted by phase number. How can I make a change to worksheet
one and those changes be made on worksheets two and three?


DonCam65

Copying changes from one worksheet to other worksheets
 
Steve
I do not know how you use that data but faced with a similar situation I
suspect I would look at 1 sheet only (multiple sheets with identical data is
a recipe for chaos) and make use of the auto filter function.
Apply it to the Columns of interest and when a change is needed select using
the appropriate column and you will see only the record(s) that meet the
criteria. Make the changes then use the autofilter to select all so that you
have all the records again. Has the advantage that you can use an additional
column to enter a change indicator such as a number or date and later on
select against that column for a summary of the records changed.
This avoids the need for macros, sorting or any manipulation of the record
sequence.
--
Don C


"Steve" wrote:

I manage a data base consisting of names, addresses including unit and phase
numbers. On worksheet one, I have the data sorted by last name, on worksheet
two I have the same data sorted by unit number and on the third worksheet I
have the data sorted by phase number. How can I make a change to worksheet
one and those changes be made on worksheets two and three?



All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com