I have been doing some reading up & watching YouTube tutorials regarding Macro's that will copy data from one sheet to another if certain criteria are met.
I must admit I haven't had much luck achieving what I am after & thought I would to turn to the experts for some assistance.
Sheet 1 = A Inventory list that represents all the items I shop for in a month.
This sheet contains item description, quantity, unit price & cost.
Sheet 2 = Shopping list. Only items that either have a quantity or cost greater than 0 should be copied to this sheet.
Functionality: Sheet 1 is the sheet I would use to see run numbers, assesses affordability & see what I buy & what I leave for the next month based on the budget / total cost of selection.
Ideally after this exercise I want to click a control button which will generate a the shopping list (sheet 2) based on the above mentioned criteria. It should copy the entire row's data or at the very least the item name & quantity.
I don't know if what I am after is feasible or where to to start. Some advice please?
This way you can filter out the zero quantities, which will hide those rows:
At the same time you can filter on category as well. So you can see the shopping list (with quatities bigger then zero) for only category 1 for example:
This does create a long list, but 3 categories times 25 items won't fit on your screen anyway and now you will be able to filter your data. You can copy the filtered data to a new sheet each month to create monthly shopping lists.