+ Reply to Thread
Results 1 to 2 of 2

Build List based on a cell value, with row data from another sheet

  1. #1
    Registered User
    Join Date
    02-05-2008
    Posts
    17

    Build List based on a cell value, with row data from another sheet

    What I am trying to accomplish is a search sheet ('SEARCH') for easy access.
    I want to know if there is a way that I can enter a number into a cell, then from the number entered, pull data from another sheet ('Master Acct') to populate a list.

    Here is an example.

    On the data sheet, there is a column that contains a date that a piece of equipment is due inspection. The difference between that date and todays date gives us how many days out until inspection.

    On the "search" sheet, I want to be able to put a number and then have a list populate from the data sheet onto the search sheet showing all pieces of equipment that fall in that window (i.e. If I put 120, then all equipment that is due 120 days or less from today() will show up on the search page)


    I have included my example (sloppy I know, but it's a work in progress):

    What I'm trying to do:

    Enter a value into A10 on 'search'
    All values in column A of 'Master Acct' that are <= the entered value, I want displayed on 'Search' A11-?? (I only want Column B,C, and E info from 'Master Account brought over)
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-05-2008
    Posts
    17

    re:

    No help?

    Did I not explain well enough, is it not possible or not the best way, or did I mess up the request somehow automatically putting the thread in the "do not reply" junkpile.

    Thanks

+ 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