ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I do an excel merge like a word mailmerge with another exc. (https://www.excelbanter.com/excel-discussion-misc-queries/15325-how-do-i-do-excel-merge-like-word-mailmerge-another-exc.html)

jaewon223

How do I do an excel merge like a word mailmerge with another exc.
 
I have two excel files, one is a data excel file and the other is what i want
to merge the data file into. I want to be able to merge like I do for word
document where there is a mail merge and it creates a separate page for each
merge that it completes. Is this possible?

e.g.

<<First Name <<Last Name
<<Address1
<<Address2
<<City, <<State <<Zip


If I want to be able to merge an excel sheet that contains this data into a
different excel sheet that looks for each value AND continues to merge the
rest of the document how would I go about doing that?


All times are GMT +1. The time now is 07:30 AM.

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