I am looking for a MS excel 2003 macro expert. I have approximately 6 excel files that contain various pieces of information that needs to be put into one very large spreadsheet. All files have a common “product id” that needs to be matched. All the information on each product from all excel files need to be matched and put in one line. Perhaps, this can be achieved by importing files into MS Access database and then export information into one spreadsheet... either way is good for me.
This is a critical project that requires someone that knows how to create an excel macro that will combine these spreadsheet and to insert the information correctly, no room for errors. Files and more information will be provided to the successful bidder. I am looking to pay between $30 and $250. I would like to get started on this ASAP.