I have a worksheet looking at various customers on various routes.

The routes are listed in column C, and other customer information is in columns A, B, and D to I.

I have several workbooks, and in each workbook I need to have a different sheet for each Route.

Right now, all the information is on one sheet. Is there a Macro or some VBA I can use that will make one sheet for each route? And move all the information with it?

Also, how do I insert the VBA coding and then make it run?

- Tnesper