Search across multiple worksheets

**coupe2t** · 01-04-2010, 10:29 AM

Hi Guys,

I have an Excel workbook with sheets named by month, ie Jan10, Feb10, Mar10 etc etc, On each sheet I input a list of jobs in column B as and when I have to make changes to jobs in a seperate system, What I want to do is create a search form where I am able to enter a job name in a text box, then click a command button and it will take me to the first instance of the job (starting in Jan10) but also offering a find next / find previous option, So basically I would like it to work similar to the actual find function in Excel but I don't want to have to highlight all the sheets everytime etc.

Can anyone help? Also I am an extreme VB newbie and so far have only managed to create the text box and the command button! lol.

Cheers for any help you can offer?

**NBVC** · 01-04-2010, 10:35 AM

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**coupe2t** · 01-04-2010, 10:46 AM

Ok sorry, changed thread title, although it still starts "need help" but is now more accurate to the problem, is this allowed?

**shg** · 01-04-2010, 10:55 AM

In the Find dialog, click the Options button, and then select Workbook from the Within dropdown.

**coupe2t** · 01-04-2010, 11:04 AM

I wanted to work out how to do it via a command button / text box method really, The Excel workbook is centrally stored and used by many, most of whom have no real Excel knowledge and many of whom probably wouldn't realise they could use the find dialog box to search a whole workbook, I want to make everything really simple to use for anyone who accesses the sheet.

Thanks for the input tho.