Hi Kimberley,

Just a suggestion: - You could create a defined name for the range of
source data. If users add or delete rows between the first and last row, it
adjusts itself. To handle users adding rows after the last row, make the
definition dynamic.

You'll find more info he

http://www.contextures.com/xlNames01.html#Dynamic

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

HTH
Regards,
GS