Hi guys,
There is a workbook with 2 worksheets.
The first one it's called "Monthly Data" has monthly duration and it's going to be auto-filled with everyday data.
Dates in first worksheet changes automatically every month. Which means, when a month comes to its end,
the worksheet will start the next day the new month.
The second one it's called "Annual Data" has annual duration and the plan is to be auto-filled as well, from the worksheet "Monthly Data".
Dates here don't change every month.
What I need is a formula which : when dates match transfers the entire row data from "Monthly Data" to "Annual Data".
In the attached file you can find the workbook with the 2 worksheets and 3 named ranges ready.
What's missing is the Excel mastermind to put the appropriate link (formula)
Thanks in advance
Spiros
Bookmarks