noting the Value of a cell beside a command button

[Rodger]

Hi, I hope this one is easy.
I have a column about 300 rows deep, and need a form button at the end of each row that will note the contents of cell in the same row in another location.

I now I need
ActiveSheet.Buttons(Application.Caller).TopLeftCell line, but am having trouble working it in.
In my case, the button will be Row 14, Col K - I would need the contents of Col E from that row (text) to go into cell D475.

I hope that makes sense, the sheet is too large to upload.

Rodger

 

[Eloise T]

Upload it after you have trimmed off all but 10 rows so we can see it.

Also, you need to post this in the VBA forum.

 

[Rodger]

The attached is the idea, if someone knows of a code?

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Rodger]

Well !! Thank you ...
I was reallllllly overthinking that one.

Much appreciated, thx for the time

Rodger