I have imported txt files into 18 workshets in an Excel file that need
to have the value in column E changed from text data to a number.
They're actually accout names that I want to have replaced with an
account number. The Macro should go through all of the sheets in the
Excel file (right now that's 18) and replace all occurences of
"PURCHASES" in column E with "51000", replace all occurences of
"ADVERTISING" in column E with "63100" and replace all occurences of
"ALBERT" in column D with "65010". This would get me started enough
that I think I could code the rest of the macro, I just need to know
how to get started. I would like this macro to be saved in my
Personl.xls file so I can use it on multiple worksheets, but at this
time I have all of these worksheets combiled as one in order to test
it on all of them to make sure it will work before I use it on my
"live" data that I will import into a client's accounting software.

If there's some help out there, it would be great.

Thanks. You're in my prayers.

Josh