There is a sample Excel file on the Contextures website that has a list of orders, and sales rep names. You can click a button, and a sheet is created for each sales rep, with that person's orders.

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.

How It Works

When you click the worksheet button, a macro runs. It sets up a list of sales rep names, then loops through that list, creating a worksheet for each name.

To get the orders onto each sheet, the macro uses an Advanced Filter, setting up a criteria range in cells L1:L2 on the worksheet.

In the screen shot below, the first name from the list, Gill, has been entered into the criteria range.

Advanced Filter Criteria Problems

The filter works

Continue reading Filter Excel Data Onto Multiple Sheets