I need to either program a macro in excel 2003 or do an advanced filter. I
need to pull out all the unique 8 digit numbers which follow
"<val:StationID" in my spreadsheet. There are no spaces to contend with and
they will always be 8 digit numbers. I need to put them into a separate
spreadsheet in column A(each unique number to a row). Some of the numbers do
repeat and the character strings they are contained in are very long. This
is an rtf file I opened in Excel.

Any help would be appreciated.