Linked Textbox not getting update dynamically

[syedabthahir]

Hi everyone,

I created a textbox and linked to the cell if i copy paste the whole row the textbox2 goes the previous linked cell



In Row 5

Textbox1 linked to E5

Textbox2 linked to F5

Textbox3 linked to G5
Textbox4 linked to H5​

<strike>
</strike>
​

Now I am selecting the Row5 and pasting it on Row6 textbox numbers has been changed but linked cells are not getting update its still linked to E5,F5,G5,H5


I need it should be update like E6.F6,G6,H6.

Thank you, help on the matter will be highly appreciated.​

 

[Kenneth Hobson]

Welcome to the forum!

I guess you copied and pasted? As such, how can one expect a linked cell to move as well? What if one copied 1 and pasted to many?

If you want to move the linked cell(s), then select and then drag and drop. Otherwise, a macro is needed...

 

[syedabthahir]

Welcome to the forum!

I guess you copied and pasted? As such, how can one expect a linked cell to move as well? What if one copied 1 and pasted to many?

If you want to move the linked cell(s), then select and then drag and drop. Otherwise, a macro is needed...

Thank you for your valuable reply can you help me with this matter because I don't have a knowledge about macros.

awaiting for you response