Search Button

[waqarqrl]

Hi all

I have long detail sheet where hundreds of number and name, many time in a day i have to find out so many things.
For this i use Ctr+F.
Any other easy solution for that ???
Or
Search button can be created on sheet's top so that i use that

Help will appreciated ..

Regards

[nathansav]

Record a macro next time you do the Ctrl F and then dissect that code produced, you'll find its easier than you think.

[waqarqrl]

Thanks alot nathansav

Will u more elaborate ur solution?????

Regards

[AB33]

wagarqrl,
Please attach a sample and will write you a code.

[waqarqrl]

Thanks Alol Ab33

No need to sample ...... i just ask how can add search button on sheet.???

REgards

[AB33]

If you just want a button with no code attached to it, just go to developer and choose form, but what is the point of a button with out a code? You write a code and attach a button to it and run it when ever you want.

[Ryk1969]

I have the same problem. I put an attachement. please put the macro so I can understand.

I have a table with the datas and I want to create a search button instead the CTRL+F. I put the "data" I want to search (ex. AA) and he select the cell. like CTRL+F.

Thanks for your Time.

[AB33]

RYk,
Unfortunately, your request does not comply with form's rule. You need to start your own thread.
When you post your thread, you need to have a proper heading which reflects your question. You would also get a speed reply if you could attach your desired result.
On the attached for example, you have data in sheet1, but we do not know what and where to search. And when search is found which columns/row you want return? Is it a single cell, or many?

[Ryk1969]

ok. thanks. I'll start a new post.