Complicated Find - Replace

[abertrand]

I've attached the file (i think) to make thing easier.

I am trying to get look at the first row of numbers for a part and then place in a corresponding number below. There are some examples already there such as 10 has 910 under it, and 5 has 400 under it.

I was currently playing around with this code:

Please Login or Register  to view this content.

But i don't know that this is the right direction to take with it and it doesn't seem to want to cooperate with me. Any suggestions?

[royUK]

Attach an example workbook

[abertrand]

I keep getting a database error when attaching the zip file. It's a pretty big file 2.3MB zipped, but that is still under the size limit. I've tried 5 times.

I uploaded a smaller sample version of the file.

[StephenR]

I don't know about anyone else, but I'm struggling to understand what you want to do and how it is determined. Can you expand on what you're doing?

[abertrand]

No Problem.

I currently have a list of parts with numbers that correspond to work centers stretched out horizontally after the part number. I would like a macro that will search these work center numbers and add a new number below the old.

An example is how I have 10 with 910 below or 5 with 400 below. I did that by hand, but I have thousands of parts to work through and would like for it to be accomplished automatically.

[StephenR]

So do you have a list of part numbers and numbers that go below them? If so, could you not use a LOOKUP formula?

[abertrand]

I do have a list of work centers and the new work centers I would like below. However the list is horizontal and not vertical, so a LOOKUP doesn't work, that's why I was trying to use FIND REPLACE.

[StephenR]

There is an HLOOKUP formula...