Hello,</SPAN>
I</SPAN> have a team (x10) that works with the same template on a weekly basis recoding sales. At the end of each week each team member will e-mail their file in the following shared folder, including the file name:</SPAN>
P:\SALES - Marketing Information Folder\RDEs\04. April\WC_22nd_April\Submitted Files\NAME_DDMMYY.xls</SPAN>
Each week the file will be sent into a different folder, depending on the week commencing date. From there files I need to go into the stock_summary tab and from here copy data from I5:I77 and input this into a master file that consolidates the weekly numbers. </SPAN>
This master file will always be at:</SPAN>
P:\SALES - Marketing Information Folder\RDEs\Consolidation.xls</SPAN>
I was hoping if there was a way this code be automated, I guess through some type of code that loops but my vba skills are somewhat limited. </SPAN>
Can anyone help??</SPAN>
I</SPAN> have a team (x10) that works with the same template on a weekly basis recoding sales. At the end of each week each team member will e-mail their file in the following shared folder, including the file name:</SPAN>
P:\SALES - Marketing Information Folder\RDEs\04. April\WC_22nd_April\Submitted Files\NAME_DDMMYY.xls</SPAN>
Each week the file will be sent into a different folder, depending on the week commencing date. From there files I need to go into the stock_summary tab and from here copy data from I5:I77 and input this into a master file that consolidates the weekly numbers. </SPAN>
This master file will always be at:</SPAN>
P:\SALES - Marketing Information Folder\RDEs\Consolidation.xls</SPAN>
I was hoping if there was a way this code be automated, I guess through some type of code that loops but my vba skills are somewhat limited. </SPAN>
Can anyone help??</SPAN>