Results 1 to 20 of 20

Display information (Cell A through E) in its entirity From Sheet 3 on Sheet 1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Southern Cali
    MS-Off Ver
    2013
    Posts
    104

    Display information (Cell A through E) in its entirity From Sheet 3 on Sheet 1

    Hello,

    Here is what I am trying to accomplish.

    On Sheet 3 I have several entries on the page. In Column A I have a drop down list with several items in that drop down. Example "Internal Strategic Goals (ISG). When the user selects this option the column range from A to E changes color. In Coloum E I have the latests updates with a date in front of them example:
    Row 2
    2/1/16 - Information
    1/25/16 - Previous information
    1/22/16 - etc

    However, I have a summary page that I only want to show columns A through E only if the item is a Internal Strategic Goal (ISG) with the latest update.

    Keep in mind, I have additional columns that have the same Internal Strategic Goals (ISG), but they could have a date that is different for the latest entry.

    Row 10
    2/1/15 - Information
    1/25/15 - Previous information
    1/22/15 - etc

    So in this case I would only want to see the first update from above since it has the latest date. Now if the entry changes to a date that is newer, it would replace the one above.

    I only want to show the top two entries. If there are three entries in the sheet that all fall under on the same date. Maybe pick the top two entries only based on where they fall via the rows.

    Hopefully this makes sense.
    Last edited by rhett7660; 02-23-2016 at 04:36 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-10-2015, 02:50 PM
  2. [SOLVED] Display information by comparing a cell in Sheet 1 to a column of data in Sheet 4.
    By Zimmerray1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-06-2014, 04:59 PM
  3. Macro to Pull information from one Excel Sheet based on information in another sheet
    By IwannabanExcelGod in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 02:11 PM
  4. Replies: 1
    Last Post: 06-28-2012, 03:59 AM
  5. Replies: 8
    Last Post: 02-14-2012, 11:13 AM
  6. Display cell from sheet 1 on sheet 3, 657 times
    By Harrisonl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2010, 11:48 PM
  7. Replies: 3
    Last Post: 01-25-2009, 12:34 AM

Tags for this Thread

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