If I have a list in Sheet1 A1 of lets say 100 items. I often remove and add to this list.
I want to have Sheet2 A1 show me the exact list as it updates, how do I do that?
In Sheet2 A1 through A100 i just put =Sheet1!A1 and it works but the issue is, when I delete rows from the original Sheet1, Sheet2 says REF.
I need Sheet2 to automatically update properly thus if I delete 10 rows of the 100 and now have 90 entries, sheet2 will show the 90 entries with no spaces.
Any ideas?
Try this..
or
Please Login or Register to view this content.
The 2nd one will make blank cells from sheet1 stay blank on sheet2.Please Login or Register to view this content.
Last edited by gmr4evr1; 02-03-2016 at 03:52 PM.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Unfortunately my actual sheet doesn't use the entire column, it goes B8 through B200, so this wouldn't work
Unfortunately my actual sheet1 doesn't use the entire column, it starts at B8 through B200, so this wouldn't work.
If I delete lets say 5 different rows from sheet1, where those rows where in sheet2 just say REF!. I need those rows in sheet2 to auto remove/update.
Try this formulaPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
I know this has been marked as solved, but I thought I'd post a sample of what I did because there is a good chance I misunderstood what you are trying to do.
I used this formula in B8 and dragged down to B200
Here is the filePlease Login or Register to view this content.
AceForSale Delete Rows.xlsx
Delete any row in the range on sheet1 to see the results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks