Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question about deleting rows from sorted linked worksheets
I have a file with three worksheets it it. worksheet #1 is a phonebook listing with the lastname in the first column and first name in secon. worksheet #2 is linked from the first worksheet, but with first name in first column and last name in second. worksheet #3 is linked from the first and is set up to output as a csv for use on intranet site. #2 and #3 work, but what I want to do is to have the second sheet sorted by first name, not last. When I do that with the data sort my cells in #2 go blank. I need to be able to add/delete/edit rows and have the data replicate from #1 to #2 and #3. So far the best I have been able to come up with is to get rid of sheet #2 and make macros to sort #1 by whatever column I want. This could be challenging for some of my users and I would rather have iut as described above. Hopefully I am describing what I am trying to do. Is this possible and if so what do I have to do to make it work. Thanks very much. -- DewChugr ------------------------------------------------------------------------ DewChugr's Profile: http://www.excelforum.com/member.php...o&userid=27405 View this thread: http://www.excelforum.com/showthread...hreadid=469324 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto deleting defined rows | Excel Discussion (Misc queries) | |||
Deleting and only viewing selected rows | Excel Discussion (Misc queries) | |||
Deleting a rows from multiple worksheets | Excel Worksheet Functions | |||
Inserting Rows w/formulas question | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions |