Copy/Paste Dynamic Range

By some stroke of luck, I actually just made it work myself. See that - even being in the presence of you experts begins to help.

Here's the code I went with:

Please Login or Register  to view this content.

Hi RS,

If i understood you query correctly then at first run your code will copy data only from C36:K63 range and will paste at C65:K92 however when will run this code again then code will copy data from C36:K92 and will always paste at starting from C65 and will overwrite the previous data.

The solution is, either you fix your copy range and create dynamic paste range or do not copy the previous day data just below the copy and paste on a different column.

In case your data input range will remain fix then you can use below code.

Please Login or Register  to view this content.

Regards,
BS