The file shows 3 levels of product information product type, company and product. Also imagine 100's of product types and 100's of months of data. It all follows the same basic layout throughout.
Beside the product's are monthly sales dollars and units sold. I'd like to put together a 2d array (is that possible with vba?) that would contain this information in a usable way.