Results 1 to 4 of 4

Thread: text from one sheet to another sheet

  1. #1
    Seeker GregT's Avatar
    Join Date
    Nov 2019
    Posts
    10
    Articles
    0
    Excel Version
    2016

    text from one sheet to another sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I dont know if this is even possible, '''i cant get it to work....eg

    Worksheet1, Cell A1 text with "Name"

    I want the text "Name" to automatically show up on worksheet2, cell A1

    Can this be done? TIA

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,372
    Articles
    0
    Excel Version
    Office 365 Subscription
    On worksheet 2, in cell A1, type this:

    =Sheet1!A1
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker GregT's Avatar
    Join Date
    Nov 2019
    Posts
    10
    Articles
    0
    Excel Version
    2016
    LOL OMG that was easy enough...........thanks

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,372
    Articles
    0
    Excel Version
    Office 365 Subscription
    Hehehe! You're welcome.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •