+ Reply to Thread
Results 1 to 4 of 4

Make a list from Items not checked off

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Brandon, MS
    MS-Off Ver
    Excel 2011 for mac
    Posts
    34

    Make a list from Items not checked off

    I have tables for each unit in a refinery for blinds that need to be installed. I have a column for "Ready to Blind" and a column for "Blinded". I am wanting to have a sheet that list all the blinds (by Blind #, also a column) that are ready to be installed.

    So if Blind #1 in the 500 Unit is "Ready to Blind" but has not been "Blinded" it will show up in the sheet named "ready to install" under 500 Unit as #1.

    If you could show me how to do it for the 500 unit sheet I will be able to figure out the other sheets.

    Thank you
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,915

    Re: Make a list from Items not checked off

    see if the attached is heading where you want to go?

    I added a helper column on your blind list sheets (some of them) in O

    Also, take a look at the formulas on dashboard in column K. Using indirect allows you to use headers to reference sheets
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    Brandon, MS
    MS-Off Ver
    Excel 2011 for mac
    Posts
    34

    Re: Make a list from Items not checked off

    Thank you Very much, I think that is going to work out well. I have moved some things around since i posted but was able to get everything working.


    Thanks again

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,915

    Re: Make a list from Items not checked off

    Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

+ 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