Find exact match then copy table

[tomiss]

Hello,

I would need a help with (i guess) simple macro. I have 2 sheets in a workbook - Source data and Weekly data.

On the sheet "source data" I have simple function to determine number of week when is report created. Then there is a table (which is result of advanced filter - each week it has different amount of records (rows), but still the same format (columns F-I).

On the "weekly data" sheet I have created the heading including the number of week and the same data as the table from the sheet "Source data" (columns F-I) but for whole year (52 weeks for 2016).

What I need is probably obvious now. I need to run a macro that based on the number of week (changing automatically each week) from "Source data" is looking for the number of week in "Weekly data" and when it finds it, copy the data from "Source data" below the heading with found number in "Weekly data".

File attached for reference.

Thank you guys for any tips, help.

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[tomiss]

Thank you very much Leo, it works.