Continuing from part 1 (http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27867545.html
After importing each csv file, macro will need to enter the data into a correct spreadsheet after comparing the "store number" value. (sample excel file included) Book1.xlsx
So for example, if a csv file contains store number 0524, it will match with spreadsheet called "Store 1" based on the G1 value in that spreadsheet.
The macro will then continue entering the weight of each product into a specific product after comparing the GTIN value.