Forum Discussion
donnabrownmilvetsnc
Nov 26, 2019Copper Contributor
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...
Abiola1
Nov 26, 2019MVP
Hello,
To pull data from one sheet to another, simply goto the specific cell of the sheet you want to pull data to and use = to reference the value
To pull data from one sheet to another, simply goto the specific cell of the sheet you want to pull data to and use = to reference the value