Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet 1 exact copy of worksheet 2, but in different order
Worksheet1 - data listed by account number.
Worksheet 2- same data, listed by surname. Whenver I add a new row to worsheet 1, I have to add the same data to worksheet 2, manually. Is there a was to make worksheet 2 a dynamic copy of worksheet 1? That is, whenever I update worksheet 1, worksheet 2 is automatically updated, and the order of the rows is kept? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet 1 exact copy of worksheet 2, but in different order
Why have two sheets.........just keep one database and sort it whichever way
you want to view at that time......you could even record macros to do the sorting for you...... Vaya con Dios, Chuck, CABGx3 "Lou@CRA" wrote: Worksheet1 - data listed by account number. Worksheet 2- same data, listed by surname. Whenver I add a new row to worsheet 1, I have to add the same data to worksheet 2, manually. Is there a was to make worksheet 2 a dynamic copy of worksheet 1? That is, whenever I update worksheet 1, worksheet 2 is automatically updated, and the order of the rows is kept? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from worksheet to worksheet help | Excel Worksheet Functions | |||
How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
Simple Copy from Worksheet to Worksheet | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) |