Hello everyone
I have this sample file with two sheets(attached). The tables are really straightforward, no formula. As the actual database is pretty long, I want all rows in Sheet 1 with product status (Column F) as "Ended" to be automatically copied to sheet 2.
In other words,
If any row in "All purchases" sheet has "Ended", that row should be automatically copied/transferred to "Ended or Abandoned" sheet.
I was wondering whether there is any combination of IF function/Vlookup/VBA code to achieve that, or at least help me to some extent. Also pls let me know if this is straight out impossible.
Or maybe there is a way to update individual cells instead of roows instead ?
Thanks in advance for all your suggestions!
purchases.xls
Bookmarks