Check cells are correct format and contain correct data

[rikosborne]

Hi

We receive about 20 sales files of several hundred lines of data each day from various agencies. I want to create a macro / VBA code which checks that the data submitted is correct so that we can upload it into our database without import errors and / or having to manually check each line of data.

I envisage something like an output report:

#####################

149 entries
Column A - Date - OK
Column B - Customer_Phone - Errors (Should be 11 digits)
Row 21 - Customer_Phone - Error (Not 11 digits)
Row 108 - Customer_Phone - Error (Contains letters)
Column C - Outcome - OK

Please correct and re-check.

#####################

Can someone point me in the right direction? I'm looking for pointers so that I can solve myself.

Thanks

rik

[alansidman]

Try this:

Please Login or Register  to view this content.

[alansidman]

Correction to first code. Missed the test for alpha

Please Login or Register  to view this content.

[rikosborne]

Thanks alansidman

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.