Hello everyone,
I am trying to create a report that I can run at a set frequency to do some data validation. I am trying to get the correct VBA language to check the format of the string within that cell and if wrong, to then copy that row and paste to a different sheet named...errors.
So...for example...I have data in a column....lets say Column E and the String formatting should be 5 Specific Upper case letters and then 5 numbers. So in E2 the string is DDBCA12345...and this is correct, the 5 upper case letters should all be "DDBCA". So then lets say E56 has the following string in the cell..."EXCEL12345"...this is the wrong format and I want to copy row 56 and then paste to the next empty row.
What is the best way to accomplish this?
Thanks!!!!!!
Bookmarks