I have the attached workbook I need to find out how to merge the data together. There are 2 different reports Sheet1 and Sheet2 both correspond to each other with a case number, but I need to add the information from sheet2 to sheet1. These are just samples, the headers and columns will remain the same but I had to scrub data on these. I have about 2300 cases and trying to manually merge these is going to take way longer then I have to get it done. Is there a macro or formula I can use to move the data from sheet2 to the corresponding cases on sheet1?
Bookmarks