• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to make vouchers automatic from master sheet

udprocks

Member
Good evening Ninja's,

I have a trouble regarding my excel as per subjected, problem is,,

I have a excel sheet that have all employee name list with final salary which m using for every month, and as per it in same workbook on second sheet i have vouchers for every agent who is available in master sheet,

i m looking permanent solution for it i just want to auto create these vouchers as per master sheet for every agent currently for example i have copy pasted only two,

and also i want whenever i add new agents on master sheet that voucher also done automaticaly and main thing i need names in "A o Z" format in both sheets,

If Possible,

Thank you in advance for support, and yes plz dont be angry with my poor english.
 

Attachments

  • voucher.xlsx
    19.7 KB · Views: 2
Why not use Mail Merge in MS Word ?

That way you setup a form in Word
Add fields to the Form, that link to the existing Excel file
You can filter by any fields if you want during the process
You can save to a new Merged File or Print Directly etc

It is as up to date as the Excel file is
 
It is very simple
It will be much simpler than trying to do the same in Excel

Don't be afraid to try

Put the two files (Word and Excel in a common directory)

Open Word

Setup a Form to look like you want it

Goto Mail Merge

Link to your Excel File

Insert fields in the appropriate locations

Merge


You can Merge to Individual Records, All Records and save as a combined File or Individual Files


There are lots of How To's on the Web

Google "word mail merge from excel tutorial"
 
You can have a look at the attached files
Place them in a new directory

Then Rename the file Five Splash Vouchers.docx.xls to
Five Splash Vouchers.docx


(Chandoo doesn't allow the upload of Word Doc's ?)

Open the word file
It may ask you to find the Excel file if it doesn't see it automatically

Then goto MailMerge and use the wizard
 

Attachments

  • voucher.xlsx
    17.4 KB · Views: 5
  • Five Splash Vouchers.docx.xls
    17.2 KB · Views: 6
Thank you for ur precious time and support sir,

just one question in this like u have shown in word only one voucher (i.e. for diksha) so how i can found or create for rest guys.
 
You can have a look at the attached files
Place them in a new directory
Then Rename the file Five Splash Vouchers.docx.xls to
Five Splash Vouchers.docx


(Chandoo doesn't allow the upload of Word Doc's ?)

Open the word file
It may ask you to find the Excel file if it doesn't see it automatically

Then goto MailMerge and use the wizard
now got it, thanks a lot hui sir, for amazing solution for me.

tons of thanks.:)
 
Back
Top