Is there any way to a macro to see the first column and create a new sheet in
the worksheet everytime there a change in functional group, there are 20
functional group and 1000 rows to do this manually is very tedious.

Functional
BAAC 14001391 2006
CCS 14000042 1999
MAMA 14000043 1999

Thank you
David