[RESOLVED] Useful two table line up excel

[gphillips]

Hi experts - just want to match two tables side by side lined up by certain fields.

Sheet names list

Start with - contains the start with data (note could be any length - not lined up but some could be line up already or may not be lined up at all)

Two table line up - contains a sample example of what the startwith data should look like after the code is
run in the output two table line up sheet.

Supporting info - if not clear is explained under the supporting info explanataion.

Any ideas of how this could be done as I'm struggling. All info should be in the spreadsheet attached by the viusal pattern between start with amd two table line up. Also supporting info gives a more descriptive explanation.

Much appreciated.