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

Hello, I am new to all VBA world and I donīt know how to start with 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.

In Sheet1 I have pre-added the content I would like to be copied and pasted in Sheet2 if Criteria is met. Additionally, where criteria are met more than once, it will need to copy and paste alternative values that also met the same criteria. 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.

I have attached a Workbook that including the Sheets mentioned above.
Thanks a lot in advance.

Hope you are on Windows version.

Please Login or Register  to view this content.

Thanks jindon for the quick reply. It worked perfectly well with the example provided. I also tried to loop the process and replicate it for 2 teams during 2 days (I attached the example), but it seems Loop option does not match with the code and it crashes.
I would appreciate if you could help me with this one.

What's your expected result?

Originally Posted by jindon

What's your expected result?

The idea was to update all the breaks for the teams simultaneously for 2 days regardless of the starting and ending time

So all the table should be the same?

Is so, copy the 1st table to the other ones.

Is that correct?

The variables of the other tables may differ from one to others.