I'm in the midst of playing with Macros for the first time and hav
finding myself getting hopelessly lost.

What I'm attempting to do is create a macro that will replace a valu
in a spreadsheet that I'm using to keep customer records. I'll give
brief example:

In Cell A1, I'll have the number 12345, and in cell B1 will be the nam
Mr Smith. The number 12345 correlates specifically to the name Mr Smith
I want to change that from Mr Smith, to Mr A. Smith, because there ar
too many double ups with the name Smith.

Now, what I want to be able to do is create a macro that will be abl
to look for every instance of the number 12345, and change the value i
the cell to it's immediate right to Mr A. Smith. The follow on fro
this is to be able to do the same to all my numbers and names that
have in my spread sheet, to permit me to update my records with ease.

I've been attempting to do this with the SUBSTITUTE command to n
avail, and am currently lost in the world of macro jargon.

I would appreciate any help at all in resolving this confusin
problem.

Rgds,

Darren

--
Yodama
-----------------------------------------------------------------------
Yodaman's Profile: http://www.excelforum.com/member.php...fo&userid=2898
View this thread: http://www.excelforum.com/showthread.php?threadid=48716