Automatically duplicating text

Copper Contributor

Hi I am using Excel.  It has two parts to the data.  I want people to be able to enter their name against the first part of Data they provide and then their name to automatically complete in the name box in the second part of the data.  How can I do this please?


2 Replies
best response confirmed by Hans Vogelaar (MVP)


Hello Lynsey, this seems to me to be a very simple reference to a cell.
Suppose someone enters their name in cell A1 of a worksheet called Sheet1, then you can display it again in another cell using the following function.


If you want to do this across worksheets, then you have to use the following syntax.



I hope this has helped you.

@dscheikey Thank you so much, I was looking too hard going through all the formulas etc.  I didn't realise it would be so easy and that is exactly what I was looking for.