Forum Discussion
Using mail merge in excel without word
Hi Mimi:
Your question is too broad in its current form. What I suggest you do is to record a Macro to print just one tax receipt. Post the code that gets recorded here, and we can show you how to modify it to enable you to select a record to print.
We will need details such as "how do you decide which record to print?", "which version of Excel are you using?" and "Which licence type do you have?".
Excel is a very large product, and not all licences have access to all of the features: we need to know what will work in your setting and what won't.
You will find a "Record a Macro" topic in the Excel Help that will get you started.
Hope this helps
Is there are step by step way to merge two excel worksheets into one, WITHOUT using WORD?
Any hints or suggestions would be appreciated.
Hi Shiloh:
There are several diffeent ways: but your question is far too broad to give a useful answer.
We need to know the data structure of the sheets, and what you mean by "Merge" :-)
Cheers
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
