+ Reply to Thread
Results 1 to 4 of 4

Display cell text in another cell automatically

  1. #1
    Registered User
    Join Date
    09-20-2010
    Location
    chapel hill, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Display cell text in another cell automatically

    I was wondering if anyone could help me out please?!?!

    I need to have a cell on Sheet2 display the TEXT from a cell on Sheet1, is his possible??

    Example:

    Sheet1, Cell A1 contains a clients name and I would like to have Sheet2, Sheet3, Sheet4 etc... Display that clients name in a cell of my choosing (could be a different cell on each Sheet) automatically after entering it once on Sheet1, cell A1.

    I thought this was possible but I can't seem to figure it out. I haven't done any real Excel work in quite a long time but I thought I had done this before a long time ago!! Any help would be GREATLY appreciated!! Thanks in advance...

    P.S. If I use autosum to do this it just displays the number 0, obviously, since it is trying to add numbers...

    I uploaded a copy of the spreadsheet, What I would like to happen is have the text from Sheet1,D4 automatically be placed in Sheet2,A1 and Sheet3, B2. Hope this helps

    -Aric
    Attached Files Attached Files
    Last edited by aricthegreat; 09-20-2010 at 06:18 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Display cell text in another cell automatically

    What I would like to happen is have the text from Sheet1,D4 automatically be placed in Sheet2,A1 and Sheet3, B2
    In turn, select sheet2!A1 then Sheet3!B3 and enter this formula; =Sheet1!$D$4
    Each on the separate sheets will display whatever is entered in cell D4 on sheet1.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Display cell text in another cell automatically

    I am not sure what you are after, you have a TextBox Covering A1 to I3
    But to reference Sheet1D4 anywhere else in the workbook, you can use
    =Sheet1!D4

  4. #4
    Registered User
    Join Date
    09-20-2010
    Location
    chapel hill, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Talking Re: Display cell text in another cell automatically

    Thank you to both of you.

    =Sheet1!D4 is exactly what I needed!!!


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1