PDA

View Full Version : Search Excel file



Ildestino
01-22-2014, 12:33 AM
Dear Gurus,

I am trying to build a search excel file. This file should search for descriptions into 3 different excel files and show users the results.

The constellation of files are:

Material List: Descriptions are in column "O"
Equipment List: Descriptions are in column "C"
Vendor List: Descriptions are in column "G"

The master excel file should contain 2 fields for searching

Field 1: Name/Description
Field 2: Dropdown list of Material, Equipment and Vendor.

If the search comes up with a result, it should show the whole row.

I hope you guys can help me out.

Many thanks in advance.

Kind regards

Il

snb
01-22-2014, 04:47 AM
Integrate 3 Excelfiles into 1 (containing several worksheets) first.

Ildestino
01-22-2014, 05:05 AM
and then?

snb
01-22-2014, 05:18 AM
Post you sample workbook here and indicate very clearly what you want to accomplish.