MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET
 

Hi,

The scneario is this, the output from another program into excel would
be something like the below:

Column A
TYPE 1
TYPE 1
TYPE 1
TYPE 2
TYPE 2
TYPE 3
TYPE 3
TYPE 4

The values in Column A can have multiple types and variable duplicates
for each type.

The end results I need is to have multiple worksheets and each
worksheet will only contain one type. All rows with TYPE 1 will be
copied to sheet 2, TYPE 2 to sheet 3 and TYPE 3 to sheet 4 and so on.

How shall I approach this issue?

Nic

MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET
 

Ron de Bruin has precoded sample code for a variety of copy type scenarios
including this one. See the sample code at his site:

http://www.rondebruin.nl/tips.htm

--
Regards,
Tom Ogilvy

"Nic" wrote in message
om...
Hi,

The scneario is this, the output from another program into excel would
be something like the below:

Column A
TYPE 1
TYPE 1
TYPE 1
TYPE 2
TYPE 2
TYPE 3
TYPE 3
TYPE 4

The values in Column A can have multiple types and variable duplicates
for each type.

The end results I need is to have multiple worksheets and each
worksheet will only contain one type. All rows with TYPE 1 will be
copied to sheet 2, TYPE 2 to sheet 3 and TYPE 3 to sheet 4 and so on.

How shall I approach this issue?

Nic