Help creating new sheets

[gfrantsen1961]

OK, this is more of a non-code specific question.

I have a single sheet with multiple rows. The first column of each row is a job number. These job numbers are sorted. There can be many rows with the same job number.

For each unique job number I need to:
1 - create a new sheet in the same workbook with the tab named the same as that job number
2 - take all rows with that number and put them in the newly created sheet

There is no unique information on the first sheet that I need to keep so I can delete it when all the moving/copying is done.

What would be the best way to approach this?

Thanks.
Greg.

Sapientius, non contentius labora

[VBA Noob]

Hi,

This link might help

http://www.rondebruin.nl/copy5.htm#all

VBA Noob

[gfrantsen1961]

Thanks!
That was perfect. It's like they read my mind!
Later.
Greg.

Scientia potestas est

[VBA Noob]

Indeed. Ron's site rocks

Glad it helped

VBA Noob