I'm merging data from two separate and different workbooks. I know I can
make them look similar to start with by adding columns to each of them and
rearranging the columns. The problem I have is that I not only need to get
the information in one spreadsheet but I also need to get the information
merged in rows. For example, I have a column of policy numbers in both
spreadsheets but only one of the spreadsheets contain the address for the
policy number. I need to get the address in the same row as the policy
number. After I get this set up, I'll be using the information to do a
mailing by mail merging into Microsoft Word. I know how to do that part.

Any suggestions?
Thanks,
Valerie