A macro wich will delete (or hide) rows in one tab under conditions from other tab

Hi guys, as I'm not really familiar with VBA, this is really hard for me to figure out how to write macro.

I already have a macro, which I need to change (or to just have new one), because need to change the process. What I have Is a button, which delete rows with name "invoice" in specific column.

What I need right now (as I needed to make some changes in the tab 1) is a macro which automatically will remove/hide rows from tab 1. The difference now is that I need to follow what is in Column A, Sheet1 - not all invoices must be deleted. Sometimes I would need to delete Black, sometimes Red, and sometimes both. So I was thinking of having combo box instead of a button, but have no clue how to do this. I already made a new list (old was just "invoice" or "non-invoice") and put a combo box. But tried to change macro I already have and did not work.

Yes, as this file is just an example. I need this for a different file which looks not as simple as this, but contains confidential info, so just could not send it.

It would be good too, but just thought the "new" approach would work better. "OLD" is what I already have and "NEW" is what I wanted to work. So is it possible to leave a standard dropdown list to work as I have mentioned?

It's not working. There is a pop-up as is the attachment. Attachment 659660

Still not working for me. The pop-up says: Run-time error '1004': Method 'Autofilter' of object 'Range' failed. And if I click "End" and want to see what happens in tab1, everything is hidden each time.

I was trying on the files you have attached.

Hmm.. I just download the file open it and try to perform the action. that's it.

Ok, thanks anyways!