Thread: [Solved] Macro to open Multiple files and copy information to a master file
View Single Post
 
Old 04-05-2016, 12:07 PM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
  
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Macro to open Multiple files and copy information to a master file
Hi All,
Looking for some code that would allow me to open multiple excel sheets and copy the information to a Master File. I set up a macro in Outlook that whenever the files ar received it put them in a folder on y network.
Here is an example of the data in the files that I want to copy to the Master:
Job No PackageCode File Name Date Dropped Quantity Status
461332 E-XUL E-XUL_5014605A1-0001-.PS 4/4/2016 15:17 14 Confirmed
461333 E-XUL E-XUL_5014605A1-0002-.PS 4/4/2016 15:17 177 Confirmed
461334 AFA-XUL AFA-XUL_5014605A1-0003-.PS 4/4/2016 15:17 311 Confirmed
461335 ING-XUL ING-XUL_5014605A1-0004-.PS 4/4/2016 15:17 190 Confirmed
461336 FE-XUL FE-XUL_5014605A1-0005-.PS 4/4/2016 15:17 17 Confirmed
Reply With Quote