Looking for some help as I know this is way over my head.
I've created a master list of items I buy and added other basic info about them like price, aisle, etc (a sample is attached). I want to add a button (macro) that will allow me to create a list (in a new sheet created by the macro) of those items where the quantity > 0. The new list would include all cells associated with that item (the row) such as name, quantity, price, extended price. Then at the bottom of the new list the "total w/tax" (a cut and past of the value or whatever way is easiest). I put it off to the side of the master list so it's location would be fixed.
I'm also wondering if the sheet that's created can be named based on the current date. And any other suggestions would be welcome; I'm guessing there's probably a better approach to this or something I'm leaving out.
Bookmarks