I like the way how you "macronize" it. It is fun when you get things done in a more efficient way, thank you ... View more

your code works so great! Thank you for your suggestion and surely I'll learn by playing with Macro! :smileycool: ... View more

that's a good suggestion. But there are duplicated ID in data1-data60 with different values of other variables, so I guess combining data1-data60 and then merging with dataB might be problematic.  This reminds me that my dataB actually have duplicated IDs but my data1-data60 only have unique ID in each one of them. What I want is do a one-to-many match for each datai (i=1 to 60) and dataB merge. ... View more

Sure，going trough the documentation with samples is something I want to try first. Do you have any suggestions about books or other learning materials? ... View more

Hi John, The codes look so good. I will try to see how it works. Thank you so much! Copy&paste always works for me when I only have less than 10 data sets... when it comes to 60... Oh, my gosh, I need macros!!!! I will try my best to learn it. Thank you! ... View more

Hi Astounding, Sorry about not providing enough info. The original data sets are not sorted yet. And for final results, they can be any name. Let's say merged1-merged60...Thank you! ... View more