Ok, this is kindof a long explanation:

I have two worksheets with data that kind of looks like this:


Sheet 1
A/B/C/D/E

Sheet 2
A/F/G/H/I

Now what I want to do is combine this sheet into A/B/C/D/E/F/G/H/I

Complicating matters is the fact that I have had to go and custom sort Sheet 1 so now the order of the data in Sheet 1 and 2's 'A' does not line up

What I need is to find a way to go through each cell in Sheet 1, column A and then match it against Sheet 2, column A and then populate the data from F-I into Sheet 1

I'm not sure if a macro or a formula will do it... Help!

-K