I have the following VBA code that I use and tried to modify it to accomplish a new task. My goal is to copy the Data from workbook A(range A2:r2) to Workbook B. to a sheet name "Original" and paste the data beginning at( A7:R7). however I'm getting a subscript error 9 and can't seem to find the error. maybe my logic is missing something. I would appreciate your expertise on this issue. See below:
to add more details: I go to a cloud location to export the data into an excel file on a daily basis, once I get the data on an excel file, then I'm trying to use a vba code to copy and paste to an existing template, into a Sheet called "Original" and copy the data starting at A7:R7.
please let me know if you have any questions.Please Login or Register to view this content.
Thanks in advance for your assistance.
Bookmarks