| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace Old Part Numbers with New Part Numbers in a Macro.
How can it be done? I have a list of old, busted numbers, I want to replace
them with new, shiny numbers. Not all lists that will be subject to the macro will have all part numbers. Sometimes, I'm saying, the macro will be searching for numbers that aren't there. They are gennerally of a ABC12345 format, a 3 letter prefix and a 5 digit part number such as UNV51001. I'll be loading a customers pricing, running the macro, and uploading it to a new system. The new system doesn't like certain numbers, so we must convert them. -- Thanks, Jeffery Keown |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Text to Numbers in a Macro | Excel Worksheet Functions | |||
| Preserve negative numbers in following macro | Excel Worksheet Functions | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Convertin Text to numbers within a Macro?? | Excel Discussion (Misc queries) | |||
| Looping Macro That adds a blank row between different part #'s | Excel Discussion (Misc queries) | |||
Threaded Mode
