Auto populate Spreadsheet

Hi,

A few days ago I got some help auto populating a template and creating/saving new excel files based off of data from a separate tab. Thank you very much for that help. I've ran into a snag...

Please look at the attached template (Coumns N and Coumns O). Notice there are several unnecessary rows "Yes/No" check boxes. When the template creates the separate Excel files...it always keeps the same amount of rows....so if there are 100 rows on the template, and it creates an Excel file with only 5 people...there are 95 rows of blanks/check boxes.

I want to set up the template so that when I import information from the "Data" tab...it only puts the corrent amount of rows necessary....and doesn't keep a sheet with too many rows.

Make sense? I have a deadline of COB today to figure this out...so any help would be greatly appreciated!! Thanks so much!

So in other words...I would like there to be only the amount of rows as there are people in the Performance