Forum Discussion
Lynsey73
Oct 19, 2022Copper Contributor
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...
- Oct 19, 2022
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!A1
I hope this has helped you.
dscheikey
Oct 19, 2022Bronze Contributor
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!A1
I hope this has helped you.