CHALLENGE

​

Client needed a benefit statement PDF file created for 1600 employees that showed their contributions in table form and chart form.

​

SOLUTION

​

Built a layout sheet in Excel that contained variable cells to receive data for each employee. With complex VBA scripts, we were able to loop through all the employee data and automatically insert the correct info into the layout sheet and have the pie chart adjust accordingly.

​

BENEFIT

​

With a click of a button, this client was able to export 1600 PDF files with the name of the employee and ID# to a new folder without having to worry about any data errors and saving tons of time.

​

"Skylar was knowledgeable and communicative and accomplished exactly what I needed and a very efficient manner. Will absolutely hire him again if I need more work. Highly recommend." - Susan