autofilter problem
Hello, I have two worksheets, the first holds original data. On the second sheet I used copy (from page 1 data), paste special and paste link ...then I used autofilter to sort through the data for only select information. However I seem to have a problem now...when I update the original page 1, I can get the information to appear on page 2 if I refilter the data....however that will only work if I had added the information on page one to the last row or updated existing information....if I try to insert a row to add information, it will not appear on page 2. Not sure what I am doing wrong...any suggestions. -The end result I am striving for is to have the original data on page 1, then be able to have only specific information in precedding worksheets and the preceeding worksheets to update when I update page 1. Thanks! -- Karmen ------------------------------------------------------------------------ Karmen's Profile: http://www.excelforum.com/member.php...o&userid=30972 View this thread: http://www.excelforum.com/showthread...hreadid=512674 |
All times are GMT +1. The time now is 03:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com