Merging 2 Worksheets or Workbooks into 1

[lk26]

Hi,

I have a problem i need help with asap. I have 2 excel worksheets that i need to combine into one. Both have about 2 common columns (sales order number and patient name). I need all of the different information all on one spreadsheet, including the 2 that are the same. I just need all the info from both spreadsheets combined to one. is there a VBA i can use out there to do this easily and on a weekly basis? Please understand I don't know a thing about macros or vba..

Thank you

[Pepe Le Mokko]

Hi and welcome

perhaps this add-in will help

[lk26]

This Helps a LOT. I was also wondering, could it match the sales order numbers from both spreadsheets and put them on the same row possibly?