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!
Bookmarks