VBA to copy/paste from Sheet1 to Sheet2 if criteria is met

[casper_01]

Hello, I am doing a project where I want some values that are already set up in 1 sheet to be copied and pasted in another sheet provided the Criteria from Columns B & C from Sheet2 (both simultaneously) are met. Sheet2 looks already as attach image (Sheet2).

In Sheet1 I have pre-added the content I would like to be copied and pasted in Sheet2 if Criteria is met. See attachment (Sheet1). As you can see in in Sheet1 I already have the content that I need to copy on Sheet2. I would like to create an Excel Macro that would do this automatically.

The outcome should look like the attachment (Sheet2 – Outcome).

 

[Fluff]

Duplicate Copy/Paste Values from one Sheet to another one based on 2 criteria

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).