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