Hi All, Last time everybody was real helpfull, so I thought maybe one of you guys ( or girls ) could help me with another question. I have a piece of text in excel in which I need to replace two words ( dates and a code ) from a list and then the next till the list ends. So to make it more clear, this is the text I have in row a1 ( sheet 1) Sess0.Screen.Sendkeys("cDDMMYY")(" XX0000000000 s0101 ") and in sheet 2 I have in a1:a5: 01-01-2014 02-01-2014 etc. and in sheet 2 b1:b5: xx0000000001 xx0000000002 I need to replace the DDMMYY with the a1.value from sheet 2 and the xx00 with b1, and then copy the line and paste it in a new sheet. And with a loop (?) the rest of the list. So in my new file I will have 5 lines with all new dates and xx.. codes. I hope it makes some sense. but thanks in advance..

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Help with find and replace with Items from list

Thread starter rickybid
Start date Sep 23, 2014

rickybid

New Member

Sep 23, 2014

Hi All,

Last time everybody was real helpfull, so I thought maybe one of you guys ( or girls ) could help me with another question.

I have a piece of text in excel in which I need to replace two words ( dates and a code ) from a list and then the next till the list ends.

So to make it more clear, this is the text I have in row a1 ( sheet 1)

Sess0.Screen.Sendkeys("cDDMMYY")("<tab<tab>XX0000000000<tab>s0101<enter>")</enter></tab></tab<tab>

and in sheet 2 I have in a1:a5:
01-01-2014
02-01-2014
etc.

and in sheet 2 b1:b5:
xx0000000001
xx0000000002

I need to replace the DDMMYY with the a1.value from sheet 2 and the xx00 with b1, and then copy the line and paste it in a new sheet. And with a loop (?) the rest of the list.

So in my new file I will have 5 lines with all new dates and xx.. codes.

I hope it makes some sense.
but thanks in advance..

Last edited: Sep 23, 2014