Gregg Wolin
Member
I'd like to automate the transfer of data from one workbook (from a third-party) into a separate file I will use for analytics and report generation.
The file we receive each month is attached (note the name of the file - each month the last part of the name is adjusted with the new date) along with my destination file. I envision a macro that would ask the user to (i) browse for the source file then, (ii) find whatever data has been updated then, (iii) copy and paste the data to the proper in the destination file.
Thanks in advance!
The file we receive each month is attached (note the name of the file - each month the last part of the name is adjusted with the new date) along with my destination file. I envision a macro that would ask the user to (i) browse for the source file then, (ii) find whatever data has been updated then, (iii) copy and paste the data to the proper in the destination file.
Thanks in advance!