Results 1 to 8 of 8

Need help with generating 3 reports from one file

Threaded View

RD350B Need help with generating 3... 10-21-2012, 11:54 AM
arlu1201 Re: Need help with generating... 10-21-2012, 01:28 PM
RD350B Re: Need help with generating... 10-21-2012, 01:34 PM
FDibbins Re: Need help with generating... 10-21-2012, 02:02 PM
RD350B Re: Need help with generating... 10-21-2012, 02:25 PM
FDibbins Re: Need help with generating... 10-21-2012, 07:22 PM
RD350B Re: Need help with generating... 10-22-2012, 04:11 PM
RD350B Re: Need help with generating... 10-22-2012, 04:24 PM
  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    8

    Need help with generating 3 reports from one file

    Dear All,
    Greetings! This is my first post here and I will admit am a total novice with excel as far as macro or vba and all the other high end stuff is concerned. Please take a look at the attached spreadsheet. I need help in generating the below 3 results/reports from the attached file. Would it be possible to run an exception report that would return the below three results/reports.

    • An exception report that reflects those candidates that are missing training.
    • An exception report to reflect those positions that are missing the mandatory training for the positions listed on the REQUIREMENTS tab. The REQUIREMENTS tab reflects the list of positions if mandatory training is required or not.
    • Would it be possible to format the names in such a way so that the name turns red in colour a month before his training expires? The validity of the training is mentioned under the REQUIREMENTS tab against the names in the first row.

    Any help will be greatly appreciated, thank you so very much.
    Kind regards,

    Jan
    Attached Files Attached Files

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