There is a sample Excel file on the Contextures website that has a list of orders, and sales rep names. It has a macro to filter Excel data onto multiple sheets. You can click a button, and a sheet is created for each sales rep, with that person's orders.
Contextures网站上有一个示例Excel文件,其中包含订单和销售代表名称的列表。 它具有一个宏,可将Excel数据过滤到多张纸上。 您可以单击一个按钮,然后为每个销售代表创建一张带有该人订单的工作表。
There is another version of the file, and it creates a sheet for each sales rep name that is visible, after an AutoFilter has been applied.
该文件还有另一个版本,在应用了