Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying worksheet, path/file access error: '\vbxxx.tmp' | Excel Discussion (Misc queries) | |||
copy specified cells from different worksheets to one worksheet | Excel Discussion (Misc queries) | |||
Copying data from multiple worksheets | Excel Discussion (Misc queries) | |||
Master worksheet linking to multiple worksheets and using filter | Excel Discussion (Misc queries) | |||
zero value when copying cells between worksheets | Excel Discussion (Misc queries) |