Filter Bad data in Excel 1

[Queryman]

I have a excel worksheet that I receive frequently, it has the following columns of data
CLIENT_NAME $10,
SEGMENT $54,
ANALYSIS_YEAR $4,
STRUCTURE_CODE $8,
INCLUDE $7,
OPERATIONAL_ID $15,
ANALYST $25
The data is all characters noted by the "$" and the number following is the number of maximum characters in each column.
I need to create a macro that I can activate to search through the data in this worksheet and create a new tab in the same worksheet. This tab contains every row in the worksheet that has bad data defined by any character that does not match the following:
The letters A-Z
The numbers 0-9
Underscore characater
Period character

The 1st row which contains headings needs to be carried over to the second tab with the bad data.

I was thinking of a macro that I could place in personal.xls to do this, although if anyone has another suggestion, I would be interested.

Any takers?

Thanks a lot.




Michael

 

[DaleWatson123321]

Hi Michael,

If you're still in need of help, I believe I've been able to develop a solution.

Email me and I'll send what I have.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Update...

I received a reply from Queryman (Michael) who confirmed the file "works great".

If anyone else has a similar task, or if you feel this example file of Excel's filter/database functions can be useful in helping to learn this very powerful component of Excel, please feel free to ask for the file.

In your email, please refer to "Filter Bad data in Excel".

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Queryman]

The file that Dale emailed me provided a useful solution for the "not so simple" task. I would encourage anyone interested in obtaining a copy of the file from Dale. Dale does some outstanding work.




Michael