I have to create a master workbook that will pull data from multiple workbooks that may have multiple sheets.
Workbook A has 6 worksheets. Each worksheet is set up differently. The basic information is the same though. It contains the product title, item code and price; however one of the sheets only contains the item code and price and another sheet contains UPC & ISBN numbers and prices for this year and previous years.
Workbook B has 1 sheet with Title, item code, ISBN, UPC, price and many additional columns of information for each product.
Workbook C has 1 sheet with Item code and price.
There maybe duplicate information in these workbook, but I am not sure. Each workbook is maintained (updated and edited) by the department in which the products are used.
I have to create a main workbook that our pricing person can access that will list all the products only once and only list the item code and price.
I have mulled over how I am going to do this and am just stumped. My thoughts are to pull data from each sheet seperate sheets in my master workbook, then have a sheet that will pull data from those sheets to the next empty row. Then have a final sheet that will only pull the item code and price.
I hope I am clear in what I need to accomplish. Any thoughts on how I can make this easier or what formulas/macros/VBA I need to use to accomplish this?
Bookmarks