Search excel file for multiple values

June 1, 2011 at 23:01:37
Specs: Windows 7
I run a file room and have 55,000 files listed in an excel sheet by rack number / shelf number

RACK FILE1 FILE2
SHELF 2.2.1 00-DCV-115533 TP 01-DCV-121638
SHELF 2.2.2 07-dcv-156148 07-DCV-156329 TP
SHELF 2.2.3 08-DCV-161660 tp 08-CV-161663
SHELF 2.3.1 08-DCV-166310 08-DCV-166316 TP
SHELF 2.3.2 09-DCV-169134 09-DCV-169166

When users request files (by using an excel sheet) I would like to be able to click a 'find' button and use values from the user provided excel sheet to find those files in the file room excel sheet.
Here is a sample file sent by a user:

FILE NUMBER REQUESTOR'S NAME
09-DCV-169193 Erronda Harris
09-DCV-171620 Erronda Harris
09-DCV-173211 Erronda Harris


See More: Search excel file for multiple values

Report •

#1
June 3, 2011 at 13:35:09
A database may be a better tool.

Report •

#2
June 5, 2011 at 00:35:18
re: "When users request files (by using an excel sheet) "

How are the users "requesting" the files?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
June 5, 2011 at 09:58:21
They send an excel sheet via email with the requested files listed within

Report •

Related Solutions

#4
June 5, 2011 at 10:00:08
I concur, however, what would be the easiest way to import the files requested by the users? They send the requests (sometimes over 100 files) using an excel sheet as an email attachment

Report •

#5
June 5, 2011 at 17:47:31
Does the "file room" file look like this?
        A             B	                C
1     RACK          FILE1             FILE2
2  SHELF 2.2.1  00-DCV-115533 TP  01-DCV-121638 
3  SHELF 2.2.2	07-dcv-156148     07-DCV-156329 TP
4  SHELF 2.2.3	08-DCV-161660 tp  08-CV-161663 
5  SHELF 2.3.1	08-DCV-166310     08-DCV-166316 TP
6  SHELF 2.3.2  09-DCV-169134     09-DCV-169166 

Do you need to search for files in both the FILE1 and FILE2 columns?

Note: Before posting data in the forum, please read the instructions found by clicking on the following line.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question