Forum Discussion
Automatically duplicating text
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?
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.=A1
If you want to do this across worksheets, then you have to use the following syntax.=Sheet1!A1I hope this has helped you.
2 Replies
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.=A1
If you want to do this across worksheets, then you have to use the following syntax.=Sheet1!A1I hope this has helped you.
