Excel Mail Merge?

[geerdad]

Is there a way to create multiple worksheets (or workbooks) with certain
cells being auto-filled from a data source, similar to what MS Word calls a
Mail Merge?

 

[JP]

Yes, but you'd need to provide far more details if you want any
semblance of sample VBA code.

--JP

 

[Mix.G]

I'm not too sure if this helps, but if your data source is another excel
worksheet you can use a VLOOKUP formular. The link to the 'instructions' is
below:
http://office.microsoft.com/en-us/excel/HA010563201033.aspx?pid=CL100570551033