Hi Experts:

This is a long one and I hope someone will help...I don't think it's too
difficult, but I can't make it work.

I have a report that I'm building that has 15 .csv files that I consolidate
by copy/pasting each .csv file to another single worksheet to save as an .xls
file.

I am doing simple Macro Recording for most of the report formatting, etc.,
however, there is one point in the process that I need to delete all records
in Column A for about 5 or 6 Codes (i.e., Leadership, Training, etc. and
retain the rest.

I then want it to go to Column H and convert any number 3 or greater to 2,
EXCEPT, if Column G is "Doe". If it is "Doe", I want it to let the number
exist as it is logged.

Can anyone help me with this one?
--
jeannie v