ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Search Box & Button for Workbook (https://www.excelbanter.com/excel-programming/297484-search-box-button-workbook.html)

Brian

Search Box & Button for Workbook
 
Sean and Chris tried to help me with this the other day,
but I didn't give enough detail and I don't understand
much about vbs, so I'll try again.

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 aa 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, and 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 of results that are found.

Thanks for your attention and time.


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com