Using Dynamic Arrays

Hi All

I have a spreadsheet that has a list of data in columns A, B and C.
I'm trying to develop a macro that will create worksheets for each unique name in column B and will copy the corresponding rows into it's worksheet.

I know I can do this with dynamic arrays, but I would appreciate any guidance.

Many thanks in advance
Oz

Here's one method, which assumes your data starts in A1 in a continuous block with a header row:

Please Login or Register  to view this content.

Thank you very very much Stephen, this has worked perfectly. I can see a lot more use with this method too

Much appreciated.
Oz