Hi,

I am trying to work on for few months but can make any positive results. I manually compile employees' leave records and added them on leave form one by one. After that, I print that sheets and employees sign on that. There are almost 300 employees working. So, this is a time killing tasks. To save my time and reduce my work pressure I need to fill those forms automatically.

First I this can be done by MS access and talked this an access specilist but he suggest that MS excel is best option for that. There are some excel templates or macro for that.

I have attached an exel file with 2 demo doc files (how I actulay need the file as an example)


I need to get report like "Demo filled up_Leave Application Form _New (2016)" that will be automatically generated from that exel "Leave details" file in excel or doc into those blank spaces and I will just print those pages at a time.
Leave details.xlsx
Leave Application Form _New (2016).doc
Leave Application Copy.jpg
Thanks in Advance,

Best,
Rinko.