I am currently stumped on how to do this and I am not even sure it is doable.
We have two files that come in that are then pasted onto a spreadsheet on two separate tabs. For the purpose of my question I have called them Data1 and Data2.
I need to VLookUp cell[s] 'C' in Data1 and check if they appear in Data2 in 'J' If they do the entire row plus header from Data1 needs to be copied to the Tab 'Result'
Beneath that I need the header from Data2 and the corresponding item[s] in Data2 that are in Data1.
I have included an example spreadsheet which shows how the 'result' tab should look. I have highlighted in Red the Ref that identifies the items. Although I do not need the Macro to highlight these.
Is there anyone out there up for this challenge?