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
Bookmarks