And populate that new sheet with the associated data????

Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box.

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

And Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

David wrote:

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

--

Dave Peterson