code to copy paste the rows to a new sheet if matches 2 categories

[Elainefish]

To start, I am absolutely beginner in programming. I just google codes to help me with what I want to do with my excel.

I have Master Sheet where all infos will be generated

The idea is that:
When "Update Tab" button is clicked, then the infos will copied in a new sheet if it matches the category.

There are 2 categories to be matched: Document type (I:I) and platform (M:M)
I created a new list to match these 2 categories (D:D, E:E, F:F)

I tried to create the code but obviously I do not know hat I am doing Please see my code in excel

___________________________________

Please Login or Register  to view this content.

______________________________________

Here are the category list and Sheet name
CATEGORY LIST = SHEET NAME
PM Documentation G2 = Aux_PM_G2
PM Documentation D3 MKI = Aux_PM_D3 MKI
PM Documentation D3 MKII = Aux_PM_D3 MKII
QM&HSE Documentation G2 = Aux_QM_G2
QM&HSE Documentation D3 MKI = Aux_QM_D3 MKI
QM&HSE Documentation D3 MKII = Aux_QM_D3 MKII
QA Documentation Standard G2 = Aux_QA StandardG2
QA Documentation Standard D3 MKI = Aux_QA StandardD3 MKI
QA Documentation Standard D3 MKII = Aux_QA StandardD3 MKII
QA Documentation Advance G2 = Aux_QA AdvanceG2
QA Documentation Advance D3 MKI = Aux_QA AdvanceD3 MKI
QA Documentation Advance D3 MKII = Aux_QA AdvanceD3 MKII
Technical Documentation G2 = Aux_TechG2
Technical Documentation D3 MKI = Aux_TechD3 MKI
Technical Documentation D3 MKII = Aux_TechD3 MKII
Manuals G2 = Aux_ManualG2
Manuals D3 MKI = Aux_ManualD3 MKI
Manuals D3 MKII = Aux_ManualD3 MKII

[AliGW]

We'd love to help you, but before we do, please read forum rule #2, which requests that you encolse any code in code tags and tells you how to do this:

2. Programming code must be enclosed in code tags to improve readability. (A, Z)
[code ]Please Login or Register to view this content.[/code] (or use the # button)

Once this is done, we shall be happy to help. Thanks!

[Elainefish]

Hi,

Sorry about that... i tried to edit it but I just cant figure out how to do it in code tags

[AliGW]

I have done it for you this time, but as the rule says, you just need to edit the post, select the text and click # on the edit toolbar. Next time you will need to do it yourself, please.