Forum Discussion

Lynsey73's avatar
Lynsey73
Copper Contributor
Oct 19, 2022

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...
  • dscheikey's avatar
    Oct 19, 2022

    Lynsey73 

    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.

Resources