I am trying to use a single worksheet as a user interface for a material database. Basically I want to be able to input our internal material number into Excel and have it pull various parameters from anumber of other sheets within the same workbook.
We use an 11 place number (ex 10435013828) that is broken down into the following
Position(s) Definition #of Worksheets
1 & 2 Material type (ex. Steel) 1
3 Form (ex. Sheet, bar, tubing) 1
4 & 5 Material Specifications 15
6 & 7 Material Tempering 1
8 - 11 Material Size 1
On each worksheet there are as many as 3 columns. I need it to search for the correct value in the first column and return the data from the second and third column of the corresponding row.
For the data that is spread over 15 sheets, there is a designated cell on each that corresponds to one of the material type numbers found in positions 1 & 2. Basically it will have to search for the correct sheet, then search for the correct row.
I am very new to using macros, I assume that they will be necessary, and would appreciate any help I can get.
Thanks in advance
Shane