+ Reply to Thread
Results 1 to 3 of 3

Help! How to display Passport & Visa Almost Expired Dates to another Sheet

  1. #1
    Registered User
    Join Date
    03-02-2013
    Location
    QA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Help! How to display Passport & Visa Almost Expired Dates to another Sheet

    Hi,

    Would like to ask your help or idea on this issue, i would like to display all the employee whose passport and visa is almost expired (30 days before expiry) to another
    sheet. I have done conditional formatting highlighting both fields 30 days before expiry but i want to display the list on another sheet.



    Your valuable input is highly appreciated.

    Thanks

  2. #2
    Registered User
    Join Date
    03-02-2013
    Location
    QA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help! How to display Passport & Visa Almost Expired Dates to another Sheet

    Sample Excel File is attached, all i want is a simple formula that can display to the PROGRAM sheet all the rows showing expired passport
    and expired visa from the DATABASE Sheet.

    Thanks in advance.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Re: Help! How to display Passport & Visa Almost Expired Dates to another Sheet

    Is this any good to you? You might need to play with it a bit to do exactly what you want,
    I couldn't see any of your conditional formatting!
    Attached Files Attached Files
    Last edited by nje; 03-03-2013 at 12:48 PM.

+ 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