Forum Discussion
Using mail merge in excel without word
I need help to set up macros in excel spreadsheet that can print tax receipt. I have one tab contains data and one tab is the tax receipt template. How can I set up macros to choose a range of reco...
We have one spreadsheet set up to print as a "worksheet" calculating wages, time off, etc...and we have another that includes personal contact information and new hire details.
How can we merge this information to populate on one "worksheet' per employee?
Excel 2016 within Office 365.
S
if there is a field in each sheet that has the exact same unique value like employee number or full name, you can use the Excel function VLOOKUP to add data into a cell in one sheet from another row in another sheet