Hi,
First, I must say that I'm not a VBA programmer and never used excel
much till now. I always wrote R code for manipulating data, but I have
come to believe that excel could save me time when I learned about
things like pivot tables recently.
The one thing that I thought was out of reach for excel was the JOIN()
operation (also called merge() in R)... but then I found this:
http://www.digdb.com/excel_add_ins/j..._tables_lists/
Which works very well. However, the price for the package is a bit
steep for me (an occasional user), and that is the only function I can
see myself using... so that takes me here. Do you know of any freely
available code that implements the JOIN operation for excel (2007 in
my case)?
Thanks!