Hi Rinko. In the spreadsheet you have Staff ID, Staff Name, Leave Type, Leave Taken, Department, and the dates From & To, so 7 fields in total. In the leave form you want filled in there are other fields not listed in the spreadsheet - Code No. Designation, Address During Leave, and so on.

So while we can populate the fields from the spreadsheet into a new leave form (and auto-print it for you as well) ... it will still not have all the fields populated so it probably won't save that much time. Do you want to provide the other fields or just go with it as it is?