Search Page for Inventory Workbook

T

TredderX

First off, I know next to nothing about VBS in Excel, and could use som
detailed steps on how to implement a solution for this situation.
greatly appreciate anyones help in this matter.

I have an inventory workbook with mutliple worksheets that
I would like to add a search page to.
I would like to place the search page as the first sheet
in the workbook.

My inventory data is set up as follows:
Each page has 3 columns:

1st (column B)is part number which is alphanumeric

2nd (column C) is a text description of the part

3rd (column D) is quantity on hand.

I would like to be able to search by either part number or description
this may require 2 separate search boxes?

Once the search is complete, I would like it to jump to the location o
results that are found.

Thanks for your attention and time
 
T

TredderX

I didn't seem to get much input on that one, so how about this:


How can I search an entire workbook?
The default Ctrl+F only seems to work on the current worksheet.

Thanks.
 
S

steveb

Select all the worksheet tabs and than do Ctrl + F

The easiest way is to select the first tab. Go to the last tab and holding
the Shift key select the last tab.

(Use the arrows in the lower left corner to navigate between the sheets)

hth
 
Top