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