Copy paste loop?

Hi all,

A whole ago I created an excel file that summarizes data (from 2 worksheet) with some cool formulas.

I would like to automate this and make it more dynamic by working with VBA.

Step 1 -> create a macro to load the raw data and paste it in specific worksheets
-> DONE (thanks to an old collegue)

Step 2 -> Loop through a worksheet to find dates and copy paste them to the summary sheet

Thus, all of the dates (till last row) from column G in worksheet 'Planification report' should be copy pasted to column A in worksheet 'Summary'.
Could anyone help me with writing a loop for this?

PS: here below you can find a picture of how it should look like.
All of the formulas in worksheet 'Summary' from column B till AD are working properly!

Try:

Please Login or Register  to view this content.