Loop through column, match date, copy & paste row data to another sheet

[benlw1984]

Greetings everyone,

I have a little macro coding problem that I don't really even know where to begin with.

The attached workbook has two sheets - Data & Summary.

The Data sheet has a list of dates in column A (always 28 days and so the range will always be A2:A29) and a list of names in B2:K29. The Data sheet also has a command button to activate a macro.

The Summary sheet contains a list of key dates in column A and space for names in columns B through K. Column A is currently populated from A2:A9 with key dates in 2020 and 2021, but this will increase further down column A as key dates in subsequent years become known.

What I need the user to do is populate the Data sheet with names for the month and then click the command button. The command button macro needs to search through Data!A2:A29 for any of the dates listed in Summary!A:A, and if a match is found, copy the corresponding row data from the Data sheet and paste it in the corresponding row of the Summary sheet against the matched date. Essentially, it's a summary of any names listed against the key dates.

Any help, even a start, would be greatly appreciated.

Thanks in advance!

Cheers

Ben

[WideBoyDixon]

Try this macro attached to the button:

Please Login or Register  to view this content.

WBD

[benlw1984]

Mate that's perfect - thanks very much for your help.

Have a good day.

Cheers

Ben