Searching data through out the worksheet

Dear All,

I am working on a stock statement for my company. I want to know whether we can insert a textbox on main sheet which contains all the list of equipments , and search thorough the entire workbook.

My main purpose is to know whether we have that equipment in stock or not direlty on the listed page , instead going to that specific page..

for details pls refer my attached workbook

Originally Posted by teylyn

Hello,

why spread the data over multiple sheets? Put all the data into one sheet, add one more column with the equipment type and then use the autofilter to show just the TVs or the Wire Managers or the Mixers with two mouse clicks.

A text box would certainly complicate things.

With best practice spreadsheet design, you can avoid a lot of trouble.

I know that method. But my boss wanted to work this way..Ok thanks anyways