Results 1 to 11 of 11

Create sublist from larger list

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2008
    Location
    Florida
    Posts
    36

    Create sublist from larger list

    I am writing a training program in Excel and fumbling my way through it. Here's the scenario---someone who knows a little more about excel told me that, in order to do what I want, I need to create a macro (which I have never done). Someone else told me it could be done but it would leave a lot of blank spaces-----

    Lets say that column A has "Demonstrates knowledge of CAD System" and columns B-K each represent a separate day in training---showing a trainee's progression from 1 (the lowest) to 5 (the highest). Column L is going to show the average of B-K. There are, for example, 30 separate items in column A. This all appears on 1 sheet of a workbook. Okay, the tough part. If the trainee scores less than a 3 (showing in column L) as the overall average of one of the 30 items from column A, I want the "Demonstrates knowledge of CAD System" (for example) to automatically appear on a separate sheet under the title AREAS OF IMPROVEMENT. In other words, the program would, on a separate sheet, highlight for the trainer/trainee what areas need to be corrected, rather than them having to scour 5 or 6 sheets looking for scores below a 3.

    Under the AREAS OF IMPROVEMENT, I don't want a whole bunch of blank spaces to appear, just the text from sheet 1, column A3,A9, or any other category where the score was below 3.

    So, any assistance you guys could provide would be greatly appreciated. Thanks!!


    EDIT: And whatever the solution is, I would prefer for it to be as automated as possible. Other people, who know even less than I do, are going to be using the program. I want them to just be able to punch in a trainee's score and not have to depend upon knowing how to perform functions in excel.
    Last edited by writeguy37; 06-27-2008 at 10:48 AM.

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