View Single Post
  #5   Report Post  
Old October 17th 06, 01:22 PM posted to microsoft.public.excel.misc
Jeffery Keown Jeffery Keown is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 3
Default Replace Old Part Numbers with New Part Numbers in a Macro.

Well... maybe I wasn't so clear. I'm bring old CSV files from a primitive
system to a newer one that really likes Excel Files. So I'll be running the
macro each time I load the CSV files. Excel will have to look at the CSV
file, replace the part numbers in one column (leaving prices unchanged in
another).

Now, if I can have a worksheet loaded that will perform that function on a
separate file each time I load a new one (I have over 2000 of these customer
part lists), I'd be thrilled! If you can point me to such information, that
would be great, as you've already answered me twice, and I don't want to be a
pest.
--
Thanks,
Jeffery Keown


"Gary L Brown" wrote:

You can craete a macro to do the same thing as one of Excel's worksheet
functions but ... WHY?
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Jeffery Keown" wrote:

Thanks for the speedy reply. My thoughts run thus: Will I have to add these
vlookup formulae each time? Or is there a way to simply replace the bad
numbers, keep the good ones and move on?

Maybe I'm thinking vlookup can only be used in a formula and not in a macro.
Perhaps I don't understand macros well enough.
--
Thanks,
Jeffery Keown


"Gary L Brown" wrote:

Create a Conversion worksheet.
Col A has the old #, Col B has the new #.
Now you can use the vLookup function to get the new # for all your lists.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Jeffery Keown" wrote:

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