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?

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

--JP

On Oct 13, 6:09*pm, geerdad wrote:
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?

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/ex...CL100570551033

"geerdad" wrote:

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?