Hi everyone, need help to create a code that will copy from one range to another, only if header matches.
Ive attached a sample as well here:sampleA.xlsx
In the sample I have, 2 sets of data in a sheet, the top one is incomplete, the bottom one is.
What I want the macro to do is to copy all data under the header from the bottom set when the header matches the header in the top set, and loop end of top data header. Copied data is pasted under the matching header of the top data set.
Thanks in advance.
Bookmarks