Forum Discussion
Is there a function in Excel that works like a Mail Merge in Word?
I am trying to merge data from one excel sheet into specified cells of another sheet, sort of like a Mail Merge in Word. Ideally, I would like to get rows of data from "sheet1" to merge onto the "EM...
If you have both workbooks open you can simply start typing "=" in a cell in one workbook and then go to the other workbook and select the cell you want to link to end press Enter. You will then have established a link between the two workbooks.
If you are working within one workbook but with multiple sheets (=tabs), it works the same. Just start with "=" in one cell and select the cell in the other sheet you want to link.
Not quite the same as MailMerge, though. If this is not what you want, you may need to clarify you question.