Forum Discussion
Solved
Advice for a Dynamic Worksheet Selector
Hello, I am trying to make my code automatically paste data on all relevant dates. My issue is that it does no do this due to how my code currently works. When the dates in C33:C59 cross over fro...
I think the logic of the code is reversed. You first look as the DataDestination sheet and then loop through the dates in DataSource range C33:C59.
You should start by looping through C33:C59, and for each cell set DataDestination to the sheet corresponding to the year in that cell.
I think the logic of the code is reversed. You first look as the DataDestination sheet and then loop through the dates in DataSource range C33:C59.
You should start by looping through C33:C59, and for each cell set DataDestination to the sheet corresponding to the year in that cell.