ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I do a "mail merge" from excel to excel? (https://www.excelbanter.com/excel-discussion-misc-queries/235986-how-do-i-do-mail-merge-excel-excel.html)

Jeanne

How do I do a "mail merge" from excel to excel?
 
I want to create a merge whereby the data from one spreadsheet is distributed
to multiple sheets. The same thing as a mail merge from excel to Word, only
Excel to Excel.

Bob I

How do I do a "mail merge" from excel to excel?
 
Excel doesn't do "Mail Merge", it's Word doing all the data pulling. You
will need to replicate that functionality yourself with Macro/VBA or
formulas.

jeanne wrote:

I want to create a merge whereby the data from one spreadsheet is distributed
to multiple sheets. The same thing as a mail merge from excel to Word, only
Excel to Excel.




All times are GMT +1. The time now is 09:54 AM.

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