I have a spreadsheet that coworkers will need to delete and add data daily
that I will need to audit to ensure specific columns such as zip codes,
account #'s have specific number of digits. Is there macro that I can use
that will loop through all the data and highlight each column that does not
have the specific count of digits that I specify ?

Hi,

yes you could do that but you would need to be more specific about what you
want. You could also consider data validation to ensure the correct text
length is entered.

Mike

"Jen_T" wrote:

I have a spreadsheet that coworkers will need to delete and add data daily
that I will need to audit to ensure specific columns such as zip codes,
account #'s have specific number of digits. Is there macro that I can use
that will loop through all the data and highlight each column that does not
have the specific count of digits that I specify ?

Hi Mike,
I am thinking a macro would be best since the majority could easily alter
data validation plus with each user going in and pasting in data I do not
think this would function well. I would prefer a macro at this time
I am looking to make sure that column H data, always has the correct lngth
enterd which is a 5 digit entry and column J data has a 9 digit entry. If not
highlight the cell yellow.
Or another idea would be to cut/copy that row of data onto a worksheet
titled" Research" so they could update and move back to the original
worksheet once information has been manually updated.

"Mike H" wrote:

Hi,

yes you could do that but you would need to be more specific about what you
want. You could also consider data validation to ensure the correct text
length is entered.

Mike

"Jen_T" wrote:

I have a spreadsheet that coworkers will need to delete and add data daily
that I will need to audit to ensure specific columns such as zip codes,
account #'s have specific number of digits. Is there macro that I can use
that will loop through all the data and highlight each column that does not
have the specific count of digits that I specify ?