Search Box

[MR DOPPEY]

Hi Apologies to start as I have no idea where this question should be posted, furthermore I'm a complete beginner when it comes to Excel, although I have worked with it for some years and no the basics.


This is my problem; I am trying to create a workbook that contains many individual pages each page will contain information on a specific product including; Stock, Movement, Materials, Costs, etc
Rather than using the tradition "CTRL F" find box to locate an individual product page; I would like to have on say page 1 a cell that I could;

(1) enter the product code (Any)
(2) hit a button

And the search would take me directly to that page.

I guess this is a pretty basic question so I'm hoping someone can give me an answer.

Thanks in advance

[udprocks]

Hi,

Can you please upload a sample file.

[MR DOPPEY]

Sorry No sample file available this is a from scratch project. The individual data is irrelevant really as I only need the search cell and button to find the product pages once there I can enter the details required

Thanks

[udprocks]

Hi,

See the below link if its help you.

http://www.mrexcel.com/forum/excel-q...hyperlink.html

[MR DOPPEY]

Thanks for the info and very interesting reading but way way over my head !
Anyone got an idiots guide?

[udprocks]

Mate,

ok so what you understand from this, is this ? what you want , request to you please make a dummy data and post here. if you want suggestion or help.

[MR DOPPEY]

Ok I'll put a small worksheet together

Thanks for your help

[MR DOPPEY]

Hope this helps;

[samba_ravi]

is in every case sheet name = product name?

[MR DOPPEY]

yes every sheet will have individual product name

[samba_ravi]

see the attached file
there is small vba code

[MR DOPPEY]

Thats fantastic Thank you

[MR DOPPEY]

how do I close this thread