I have a workbook with 3 sheets. AP, Move, Match. AP & Move will be about 40,000 lines.
I need a macro that will take the data from those two sheets and match them up on the match sheet by column A Line by line with all data moving over. An example is attached.
I'm not sure if this is possible, but please let me know if you need more info because I really don't want to do this manually. Anything that doesn't match I just need a blank line. I can add the true-false formula, but if it would fit in the macro that would be cool to.
Thank you very much for your time and help.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Does anyone have suggestions as to how I could accomplish this matching? I'm not good enough with vba to do it on my own.
I'm open to ideas.
Thank you for your time and help.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]bump