|Perhaps if I give you snapshot of what I want to do; below we have A-G (C,E &F are empty, we can ignore them) I need to find the brand names (Aspall, Barleycup & Belvoir in the example) using the <D> tag then copy the brand names over to column G to be sub-heads in the final spreadsheet (columns A-F will then be deleted, so as to present the data in a more easily-used fashion)|
A B C D E F G
<E> BRANDED GOODS ALPHABETICALLY BY SUPPLIER
T BALSAMIC VINEGAR Aspall Org. Balsamic Vinegar
<A> T CYDER VINEGAR Aspall Org. Cyder Vinegar
<A> T Aspall Org. Cyder Vinegar
<B> T Aspall Org. Cyder Vinegar
<B> T RED WINE VINEGAR Aspall Org. Red Wine Vinegar
<B> T WHITE WINE VINEGAR Aspall Org. White Wine Vinegar
T BARLEYCUP NATURAL Organic Barleycup
<F> T CORDIALS
<B> T BLACKCURRANT Belvoir Org. Blackcurrant Cordial
<B> T ELDERFLOWER Belvoir Org. Elderflower Cordial
Before I run the macro, the spread is a copy of a 'live' spreadsheet containing all our product details and pricing formulae, constantly being updated as there are frequent fluctations in market prices. I'm aiming for a simple "take the copy of the spread that we use for import into the database (4 times a year), Run the macro that turns it into a simpler, less data-dense spread that our customers can trim down to a stock and order sheet or import the EAN13 codes into their EPOS system or whatever they want.
Hope this is clearer, if not, just holler.
Thanks again for your help.