Hi all, I have searched other threads with similar questions but can't find one close enough to my specific application.

I am using excel 2007.

I have one sheet with many different columns, and hundreds of rows. My first column is titled "module". What I need to do is for every row that has say "AAA" in the module column, I need it to be copied to another sheet labelled "AAA" and then only copy a few corresponding data points from specific columns of that specific row.

I am up for using either VBA or IF,THEN statements but I need this to continually update itself every time a data point is added. So when a new row is created, whichever value is entered for the "moldule" column, it gets dumped into the AAA sheet.

Any help would be appreciated, thanks!

-TW