Results 1 to 6 of 6

Displaying text from another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    3

    Displaying text from another worksheet

    Hi all,

    My first post here.

    I'm doctoring an existing spread sheet (downloaded from the internet) for booking IT equipment at work. There are two tabs, booking and availability. In the bookings tab the user will enter the dates and equipment they wish to use. Does anyone know how to pull the text from the E column of the bookings sheet so that it is displayed in white text on the corresponding booking in the availability sheet?

    There is already a formula in the cells of the availability sheet that blocks out the booking in red. I can't work out what or where to add in order to display the text.

    Thanks in advance.

    Ashley
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-26-2013, 05:42 PM
  2. [SOLVED] Nested IF with the output displaying text along with text from another cell
    By madhatr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2013, 09:30 AM
  3. Macro for displaying data in a row of worksheet in another worksheet
    By NRMDU in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2013, 01:28 AM
  4. Replies: 0
    Last Post: 12-26-2012, 11:42 AM
  5. Displaying images from worksheet A to worksheet B with a click of a button
    By emilyph in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 07:49 AM
  6. [SOLVED] Displaying Specific Text in Cell Based on Text in Another
    By wowcrofty in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2012, 12:11 PM
  7. Displaying worksheet tab name on an Excel worksheet?
    By SRL55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2011, 04:57 PM
  8. Replies: 3
    Last Post: 01-30-2009, 07:44 AM

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