I have been asked to add another feature to the sheet you helped me with previously, and i was wondering if you are able to assist me again. The code is below:
I would like to adjust the code you produced for me to copy a range of cells from the last worksheet in a source workbook, and paste then into a specific range on a target workbook. I have tried to have a play about myself however i can't wrap my head around it.
To help clarify, the source workbook will have worksheets named after dates of the month (ie; 1, 2, 3). I want to extract data from the last worksheet (range G16:G35) and past them into a target worksheet in cell range D16:D35.
Furthermore, when i run the original code you produced for me, i receive the following message concerning the source sheet:
Is there a way to stop this from happening using VBA?
Thank you in advance for you assistance.