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? |
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? |
All times are GMT +1. The time now is 10:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com