Hi,
I've two sets of data I need to compare - which I could work out how to do if they weren't formatted so strangely!
The data concerns product specifications and is copied from another program so is pasted into Excel and appears all in one column, eg:
FORD
Fiesta
Blue
Red
Yellow
FIAT
Uno
Green
Orange
Blue
Punto
Red
Yellow
Green
So, the Manufacturer is in Bold, the Model is a Hyperlink and the Values are in standard Ariel 10pt. Both lists arrive like this, all info in column A, on different sheets. But one list might have more Models on than the other (Hyperlinks) and values listed under that model.
It's the additional models I want to identify, and preferably what values are listed under them. (if the model is missing, the values are too).
I've tried various methods to reformat the data via macro so I can run a simple comparison but its proving really tricky. I think the best way would be to compare the hyperlinks, but I can't find a good way to a) extract and compare them on their own and b) then retrieve the values that go with them.
I can usually work out VBA problems with a few hints or suggestions so any help would be much appreciated.
Many thanks,
I've two sets of data I need to compare - which I could work out how to do if they weren't formatted so strangely!
The data concerns product specifications and is copied from another program so is pasted into Excel and appears all in one column, eg:
FORD
Fiesta
Blue
Red
Yellow
FIAT
Uno
Green
Orange
Blue
Punto
Red
Yellow
Green
So, the Manufacturer is in Bold, the Model is a Hyperlink and the Values are in standard Ariel 10pt. Both lists arrive like this, all info in column A, on different sheets. But one list might have more Models on than the other (Hyperlinks) and values listed under that model.
It's the additional models I want to identify, and preferably what values are listed under them. (if the model is missing, the values are too).
I've tried various methods to reformat the data via macro so I can run a simple comparison but its proving really tricky. I think the best way would be to compare the hyperlinks, but I can't find a good way to a) extract and compare them on their own and b) then retrieve the values that go with them.
I can usually work out VBA problems with a few hints or suggestions so any help would be much appreciated.
Many thanks,