ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Mail Merge? (https://www.excelbanter.com/excel-discussion-misc-queries/245393-excel-mail-merge.html)

geerdad

Excel Mail Merge?
 
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[_4_]

Excel 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?


Mix.G

Excel 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?



All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com