Searchable Spreadsheet

[poolb1]

I'm looking for a code for a searchable spreadsheet please help.

I have SS that has a list of names, email, web addy, and skills and I need a way to make all that searchable. This will be used by a lot of other users to search for data in that SS. I know they can use the find tool, but for some reason the guy I'm doing this for has asked for a searchable SS.

 

[Dryver14]

good morning poolb1.

In essence all worksheets are searchable and there is not a lot we can tell you here based on what you have put.

If you have a look at the blue line accross the top of this page you will see a search tab, try inputting something like VLookup in the box and see if you can get any ideas. otherwise you need to post a little bit of the page you want to look through and the results you are looking for and we may be able to help.

 

[poolb1]

good morning poolb1.

In essence all worksheets are searchable and there is not a lot we can tell you here based on what you have put.

If you have a look at the blue line accross the top of this page you will see a search tab, try inputting something like VLookup in the box and see if you can get any ideas. otherwise you need to post a little bit of the page you want to look through and the results you are looking for and we may be able to help.

Thanks I try that, Really I don't know what I'm doing in VBA and I'm really confused (and if that wasn't appearent), I bought a VBA book bible and I can't make heads or tail from it...LOL Anyway what he want's is a dialog box that will pop up in the SpreadSheet that will search for the data in the Spreadsheet i.e. names, email, ect. I hope that makes sense.

 

[hiker95]

poolb1,

Welcome to the MrExcel forum.

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples directly in the forum.

Please attach screenshots of your workbook or a sample workbook that accurately portrays your current workbook on one sheet, and what it should look like 'After' on another sheet.

This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or
RichardSchollar’s beta HTML Maker -...his signature block at the bottom of his post

or
Borders-Copy-Paste



If you are not able to give us screenshots:

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

You can upload your workbook to www.box.net and provide us with a link to your workbook.

 

[poolb1]

poolb1,

Welcome to the MrExcel forum.

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples directly in the forum.

Please attach screenshots of your workbook or a sample workbook that accurately portrays your current workbook on one sheet, and what it should look like 'After' on another sheet.

This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or
RichardSchollar’s beta HTML Maker - see the red text in his signature block at the bottom of his post

or
Borders-Copy-Paste



If you are not able to give us screenshots:

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

You can upload your workbook to www.box.net and provide us with a link to your workbook.

OK will do, and I have 2010 version