I have attached two files to help explain what I am after as I don't even seem smart enough to just describe what I am needing done, LOL. Excel Sheet2 is the data from a query and I want to sort it and combine it in sheet 1 based on "CARD". But the info I need from that card # is on the line above. Is this even possible???? Any help would be greatly appreciated.
Bookmarks