I'm not even sure how to search this, but our HR department has an Excel spreadsheet with a top section comparing last year's to this year's salary and benefits. The bottom section is two charts comparing those numbers. This spreadsheet pulls data from a "data" spreadsheet. Right now it's one row of data showing one page of data. I need to have say 100 rows of data and print a .pdf for each row of data.

I've done this before with Excel and Word in a Mail Merge, but I don't want to re-create the spreadsheet and charts in Word. I tried and they seem to be a mess with formatting, etc. If that's my only or far best option I'll do it, but wanted to check here for suggestions. I've always received great help here.

Thanks,

Mike