Hello,
I am new to VBA and I am hoping someone can help me figure out this issue. I tried setting up a macro to copy data from one worksheet that I download daily in to a another workbook that we update the file by save as file with the same name but change the date.
This is an example of the worksheet.
As you can see the worksheet name changes each day it is downloaded. Where I need to copy in to is the workbook that we update the date daily on.
I have already set up a macro for sorting as needed before pasting in to the workbook. I just cant figure out how to get it to copy with VBA or Macro with the name changes. Any help is appreciated. Thank you.
I am new to VBA and I am hoping someone can help me figure out this issue. I tried setting up a macro to copy data from one worksheet that I download daily in to a another workbook that we update the file by save as file with the same name but change the date.
This is an example of the worksheet.
As you can see the worksheet name changes each day it is downloaded. Where I need to copy in to is the workbook that we update the date daily on.
I have already set up a macro for sorting as needed before pasting in to the workbook. I just cant figure out how to get it to copy with VBA or Macro with the name changes. Any help is appreciated. Thank you.