+ Reply to Thread
Results 1 to 5 of 5

How do I make the text info on 1st sheet copy onto the other worksheets? in same cell?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-18-2014
    Location
    Hilo, Hawaii
    MS-Off Ver
    MS 10, MS 13
    Posts
    3

    How do I make the text info on 1st sheet copy onto the other worksheets? in same cell?

    I created a Log Book, for the trainees to use for tracking their hours. I was able to figure out the formulas I needed, and even the ones for the final page that accumulates info from all the other worksheets for their grand totals at the end of the year. But I can't figure out how to make it so that when they type their name on the 1st sheet, it populates that to all the other worksheets so they don't have to keep retyping it. Yes, I am still new to Excel, I have worked with it for a few years now, but I have never had to create anything. This is my first time start to finish. I am using MS 10 at work. I would greatly appreciate any assistance with this.

    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: How do I make the text info on 1st sheet copy onto the other worksheets? in same cell?

    If they type their name into Sheet1, cell A1 in each of the other sheets, in cell A1, have this formula:
    Formula: copy to clipboard
    =IF(Sheet1!A1="","",Sheet1!A1)
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  3. #3
    Registered User
    Join Date
    09-18-2014
    Location
    Hilo, Hawaii
    MS-Off Ver
    MS 10, MS 13
    Posts
    3

    Re: How do I make the text info on 1st sheet copy onto the other worksheets? in same cell?

    It's not working for me,maybe I'm typing it wrong but I only changed the sheet title and cell, so i typed in =IF(Week1!E2=" "," ",Week1!E2) but it's not working, I typed it in cell E2 on Week2 and Week3, before I tested and it does not hide it stays visable in the cell.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How do I make the text info on 1st sheet copy onto the other worksheets? in same cell?

    Quote Originally Posted by MsMary View Post
    It's not working for me,maybe I'm typing it wrong but I only changed the sheet title and cell, so i typed in =IF(Week1!E2=" "," ",Week1!E2) but it's not working, I typed it in cell E2 on Week2 and Week3, before I tested and it does not hide it stays visable in the cell.
    Your formula is saying:

    If cell Week1!E2 = a space character then return a space character, otherwise return whatever is in cell Week1!E2.

    Try it EXACTLY as shown:

    =IF(Week1!E2="","",Week1!E2)

    This formula is saying:

    If cell Week1!E2 is blank (or empty) then return a blank, otherwise return whatever is in cell Week1!E2.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Registered User
    Join Date
    09-18-2014
    Location
    Hilo, Hawaii
    MS-Off Ver
    MS 10, MS 13
    Posts
    3

    Re: How do I make the text info on 1st sheet copy onto the other worksheets? in same cell?

    Thank you Tony for trying to help also, i typed it exactly, then i copy and pasted what you typed, it isn't working, i'm feeling very inept right now, and it's time to go home so i'll pick it up again once i get home. and just keep trying.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-20-2014, 10:44 AM
  2. [SOLVED] Copy cell from 1 sheet to another sheet depending on what info is displayed in a cell
    By chilli76 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2013, 12:33 PM
  3. [SOLVED] marco to save all worksheets as PDFs, based on cell info in sheet.
    By abagnall in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2013, 09:31 AM
  4. [SOLVED] Need to Copy cell info from one sheet to rows on a new sheet.
    By gavdean17 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2012, 03:07 PM
  5. Make a sheet with selectable info, send email using info selected
    By DwayneHeight in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2007, 12:18 PM

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