I'm using the macro from the following site, which works great but will not go beyond row 43. It will create all the sheets necessary but it will not populate those sheets with the corresponding data beyond row 43.

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Sorry if this has been answered before, I didn't see anything close to this in searching.