Hi,
I'm looking for help with what seems to be a very popular topic around here. I've done extensive searching and still have questions about the best way to approach this.
I've got approx. 500 product data sheets, which are in .xls format. They have an image of the product at the top, and then on the bottom half of the 'page', they have anywhere from 15-20 rows of product specifications.
I'm looking to create a master data source which has each product, and its corresponding specifications. Ideally I'd like to create a grid of product information, with every field description that is used (some of the less popular ones will be mostly blank).
For most of the rows, column A is the field description (ie. Product, material, price), column B is blank (used as a spacer), and column C has the actual data.
The exception to this is any row with dimensions: each dimension has its own column.
I was successfully able to combine all of the data sheets into 1 master sheet using Damon Ostrander's excellent script from here:
http://en.allexperts.com/q/Excel-1059/2008/3/Excel-Consolidation.htm
Once run in a directory, it copies all the data from the individual sheets and combines it into one sheet. This is a step closer to what I want, however ideally I'm looking to:
- grab only the data (ignore the images)
- populate each line on the master sheet with the data pulled from each individual sheet (in some cases 2 products appear on 1 spec sheet, with each having its own 'table' of data
Thanks in advance for any assistance!
I'm looking for help with what seems to be a very popular topic around here. I've done extensive searching and still have questions about the best way to approach this.
I've got approx. 500 product data sheets, which are in .xls format. They have an image of the product at the top, and then on the bottom half of the 'page', they have anywhere from 15-20 rows of product specifications.
I'm looking to create a master data source which has each product, and its corresponding specifications. Ideally I'd like to create a grid of product information, with every field description that is used (some of the less popular ones will be mostly blank).
For most of the rows, column A is the field description (ie. Product, material, price), column B is blank (used as a spacer), and column C has the actual data.
The exception to this is any row with dimensions: each dimension has its own column.
I was successfully able to combine all of the data sheets into 1 master sheet using Damon Ostrander's excellent script from here:
http://en.allexperts.com/q/Excel-1059/2008/3/Excel-Consolidation.htm
Once run in a directory, it copies all the data from the individual sheets and combines it into one sheet. This is a step closer to what I want, however ideally I'm looking to:
- grab only the data (ignore the images)
- populate each line on the master sheet with the data pulled from each individual sheet (in some cases 2 products appear on 1 spec sheet, with each having its own 'table' of data
Thanks in advance for any assistance!
