Excel merge files that work like Word merge files

[Rick]

I use Word to make several hundred different forms
(letters & documents)that contain data merged from an
Excel database file. I find that I need to use an Excel
file to make some forms and it will be a big help if I
can merge information from the Excel database file, but I
can't find any info on how to do that. Does anyone know
how to make an Excel file work like a Word merge fle
using an Exce database (separate) file?

 

[Debra Dalgleish]

Excel doesn't have an equivalent to Word's Mail Merge Wizard. You could
use code to loop through all the items in your list, and print a copy of
the sheet for each item.

 

[Rick]

Thank you Debra,
That sounds like it will take more time than I can allow
a learning curve to take, so I'll pass on trying that. I
thought it would be easy using vlookup across files, but
I couldn't make that work, even using multiple sheets in
the same workbook. Do you know how to make vlookup work
when trying to pull something from a separate file?
Rick