Results 1 to 10 of 10

Search on sheets depending on combobox value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Search on sheets depending on combobox value

    Hello, could you please help me with this.

    I have this excel file with userform that search in sheets.
    Here i just want, when i choose the month in combobox, it will search in corresponding sheets. I have attached the sample file


    For example: If i choose "January" in combobox, and enter task number "4401" it will will search in January sheet and give me a result of PM=2, SA=5, IS=10 and Assoc IS/IDE=11

    or when i chose February and enter task number 4401, it will search February sheet, PM=5, SA=5, IS=5 and Assoc IS/IDE=5.

    if March and 4401, PM=5, SA=4, IS=17 and Assoc IS/IDE=10.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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