I may be in the wrong newsgroup and if so, please direct me to the right one.
Our main database program (non-Excel) creates a file that can be opened in
Excel. The file I'm working with has code numbers in it, similar to account
numbers. I want to "convert" the account numbers to their actual name. So
far, I've accomplished that by doing a manual "find & replace" for each
account number (e.g., "find all the occurrances of '12345' and replace it
with "General Income"")
How could I write a macro to accomplish this for me? I'd like one where I
could easily add a new number and description.
Any ideas?
Thanks in advance.
Jerry
Bookmarks