I have a summary sheet with range A2:D40 where data values are collected everyday. At the end of the day I'd like that entire block of datda to be pasted in a specific sheet ina specific range depending on a particular cell value.
For eg.
If A1 is 2-Feb, range A2:D40 needs to be pasted in sheet "Feb" in range A42:D80.
If A1 is 3-Feb, range A2:D40 needs to be pasted in sheet "Feb" in range A82:D120
I can setup an ontime macro to perform this task at say 23:30 at End of Business, however, it needs to select the target range depending on cell A1 in summary sheet.
Thanks in advance for your help.
For eg.
If A1 is 2-Feb, range A2:D40 needs to be pasted in sheet "Feb" in range A42:D80.
If A1 is 3-Feb, range A2:D40 needs to be pasted in sheet "Feb" in range A82:D120
I can setup an ontime macro to perform this task at say 23:30 at End of Business, however, it needs to select the target range depending on cell A1 in summary sheet.
Thanks in advance for your help.