Is there a way to paste values to a certain area of text and make it repetitive?

[sere]

Hello everyone!

I want to know if below requirement is possible? Is yes, can you help providing solution.

I have attached an excel sheet for example. There is a list of email address in sheet 1.

I want the email address to be pasted in the red highlighted area of the html code in sheet 2. The process will be repetitive as the html code(yellow highlighted) should be pasted repeatedly with the email address updated in the red highlighted area.

Let me know if it's not clear. Hoping for a solution.

Thanks in advance!

[Richard Buttrey]

Hi,

Is the email address in sheet 2 always the 3rd item in each block and does the block always comprise 10 values?

[samba_ravi]

B4

Please Login or Register  to view this content.

Try this and copy towards down

[Richard Buttrey]

..further to my last post and assuming the answer is Yes to both questions then either VBA

Please Login or Register  to view this content.

Or a formula in C2 on Sheet2 copied down

Please Login or Register  to view this content.

[codeslizer]

Hi Sere, see if this code works for you. I'm getting the desired result, but my code might not be optimized or best one.

Solutions offered by Richard and nflsales is really great. But I think they missed the email ID which is repeating at 7th item of the block.

[Richard Buttrey]

Hi

Does the B8 text include the characters "[email protected]" (or perhaps some other text), or does it simply end with the double quotes and that the address needs to be slotted between them?

e.g.

Please Login or Register  to view this content.

[sere]

Hi Everyone,

Thanks for your promt help! Sorry for delay in reply.

I have a change in requirement.

In sheet 2, basically just column C AND Column G should be updated with the email addresses in Sheet 1. Also the number against the email address should be updated.

I have highlighted in red and yellow.

@Richard, I am not sure of the question you asked lately.
@CodeSlizer, You have exactly done what I want, but I realized that I missed to update the numbers in the html code.
@nflsaless, thanks

Thanks in advance

[Richard Buttrey]

Hi Everyone,

Thanks for your promt help! Sorry for delay in reply.



@Richard, I am not sure of the question you asked lately.

I was asking whether the characters '[email protected]' actually exist or whether you are just telling is where the email address should be placed as an example. It's relevant since in one case we can simply look for those characters and replace them.

[Richard Buttrey]

Hi Everyone,

Thanks for your promt help! Sorry for delay in reply.

I have a change in requirement.

Also the number against the email address should be updated.

What does this mean in practice? I'm, presuming, but not certain that you are referring to the numbers in sheet1 column A, but what does 'updated' mean and where does any update take effect. And why is there no number in A2?