Hi All,
I have been reading through this forum for a while and struggling to come up with a solution.
In my job we have a spreadsheet that has to have two spreadsheets (downloaded from SAP) daily, these need coping and pasting into a tab on our spreadsheet and completing a SUMIF, now the Macro for the SUMIF part is easy.
However is there any way I can get a macro to take these two files updated daily and copy them into my spreadsheet and complete the update process automatically.
Notes
As there is also other files in the same ones in there i cant use the latest one for example.
Another way I thought would be to have a prompt for the user to select the file they wish to use and then process will automatically do the copy and paste and relevant updates (SUMIF).
Hope you help.
Thank you.
I have been reading through this forum for a while and struggling to come up with a solution.
In my job we have a spreadsheet that has to have two spreadsheets (downloaded from SAP) daily, these need coping and pasting into a tab on our spreadsheet and completing a SUMIF, now the Macro for the SUMIF part is easy.
However is there any way I can get a macro to take these two files updated daily and copy them into my spreadsheet and complete the update process automatically.
Notes
- The Two downloads are always saved in two separate folders assigned by SAP auto download.
- There is two Separate tabs on Excel were these need copying and pasting (Which currently we do manually).
As there is also other files in the same ones in there i cant use the latest one for example.
Another way I thought would be to have a prompt for the user to select the file they wish to use and then process will automatically do the copy and paste and relevant updates (SUMIF).
Hope you help.
Thank you.
