I have an excel spreadsheet with a few simple columns. The spreadsheet has over 500 entries in it.
Size: 216mm
Underlap: 12mm
Left or Right: Left
Height: 450mm
Is there a way to create a search page so that if I enter the criteria I want it will show the desired result.
I need all cells to be part of the search. ie. What record has a size of 200mm but is also 450mm in height?
Is this somthing I can do in excel, or do I need to use acces??
Thanks in advance for any help.
Bookmarks