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)
Bookmarks