Results 1 to 5 of 5

Search across multiple worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2010
    Location
    England
    MS-Off Ver
    O365
    Posts
    11

    Search across multiple worksheets

    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?
    Last edited by coupe2t; 01-04-2010 at 10:45 AM. Reason: Not conforming to forum rules (Sorry!!!)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1