but let me start from the beginning:
"I am hoping that the users can go into the form" . . . from where?
a spreadsheet? when that file opens? From a user form? it's not
an issue of being correct, it's an issue of what you are trying to
do from the point that the user makes that 'request . . . the first
part is where they are when they make that request.
what is the user looking at when they press that button? . . . a
spreadsheet, a user form? . . . opening the file from windows?
"and do a criteria search (based on one column in the datadump
spreadsheet)"
okay . . . only one column? do you have any other criteria, or just
that one column?
and what kind of criteria would they be searching with? . . .
date? . . . time? . . . product? . .. ????
at this point in the conversation, if anyone else in the group has
some experience with this kind of situation, please jump in . . .