Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Massive Find and Replace | Excel Discussion (Misc queries) | |||
find a specific or several values in a massive datasheet | Excel Worksheet Functions | |||
create a form and find a value in one cell and replace a value in | Excel Worksheet Functions | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
A Macro to Do Find and Replace | Excel Programming |