I have a worksheet where I am following the status of my products (pending, finalized, in process, etc.) I want to have a separate worksheet just for the finalized products but I want it to "autoupdate" from the main worksheet where I have all products so I dont have to add it manually to both worksheet. For knowwhat I've been doing is duplicating the worksheet from time to time and filtering the Finalized products in the second sheet, but that's not a very efficient idea. Any suggestions?
(I dont want to use a pivot)
Bookmarks