Create new sheet at each change in value

**Tnesper** · 09-19-2008, 06:08 PM

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

**royUK** · 09-20-2008, 04:38 AM

Before using a macro have you checked whether your data is suitable for a PivotTable?

Try this code if not

Please Login or Register  to view this content.

**Tnesper** · 09-21-2008, 02:53 PM

Thank you so much, you save me hours and hours of work

**TheRetroChief** · 09-30-2008, 07:23 AM

Thanks for your reply,

With my (very) limited understanding of macros, vba etc, Doesn't that give a list of unique names? i.e. will give one entry for each quoter??
Following what's going on there tho, is a little beyond me. My limit so far has been getting the calendar plug-in to work and editing the ranges etc. Assume i know nothing of vba. I want to extract all the entries for each quoter and place them on their respective sheets without any breaks.

**royUK** · 09-30-2008, 07:26 AM

Originally Posted by TheRetroChief

Thanks for your reply,

With my (very) limited understanding of macros, vba etc, Doesn't that give a list of unique names? i.e. will give one entry for each quoter??
Following what's going on there tho, is a little beyond me. My limit so far has been getting the calendar plug-in to work and editing the ranges etc. Assume i know nothing of vba. I want to extract all the entries for each quoter and place them on their respective sheets without any breaks.

Please stick to your own thread. That's what this code will do after creating the unique list which is temporary

**TheRetroChief** · 09-30-2008, 07:27 AM

My bad. Wrong thread....how do i delete posted messages??? Can't see it under the edit post button!!

**benaford** · 06-09-2014, 04:34 PM

How can I change the column that is used to filter? In your example, you are using column C (or 3), but what if I want to use Column 17 (of 18). I changed the rows count from 9 to 18, but when I change this:

.Range(.Cells(2, 3), .Cells(.Rows.Count, 3).End

to

.Range(.Cells2, 17), .Cells(.Rows.Count, 17).End

The macro only copies the header row and not all the rows of data along with it. What am I missing there?

Thanks!