VBA coding search box through multiple sheets

  • Good day everyone,


    I am working in an engineering company and have been tasked to create a sort of filter for their excel file. There are hundreds of different sheets of products updated monthly.

    Im not sure what vba code to type out, there is a layout of search box on sheet 1 which the user will be able to key any word or number value in text box and similar multiple results from the different sheets of products will populate below it as a full row from month to location. Also im not sure if its possible for photos from data sheets will follow the filter to the sheet 1 too. PS: black collumns also will be populated onto sheet 1 so full row of data...


    I kindly seek your guidance anyone out there if you can provide me a sample coding, reference link or you may edit my sheet to test it out thank you very much


    regards

  • Hi roy,


    Thank you for replying, having it in one sheet does not look clean for the rest of my colleagues because it will be a long list of data. It has always been separated based on different company sector data and now i am tasked to find a solution in creating a filter which loops through all worksheet data.

    If you have any solution in mind appreciate the sharing.


    regards

    rose

  • Did you want to search based on the content of all three text boxes?

    Month
    Company Name
    Description

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Hi Mumps


    thank you for replying, i want to search based on one 1 text box whether it be month, company name or description.

    do you have any sample in mind?

  • rory

    Added the Label Cross Post
  • Please note that we have the same cross-posting guidelines as most forums. Also posted here:


    VBA coding search box through multiple sheet
    Good day everyone, I am working in an engineering company and have been tasked to create a sort of filter for their excel file. There are hundreds of…
    chandoo.org

    https://www.myonlinetraininghub.com/excel-forum/vba-macros/vba-coding-search-box-through-multiple-sheets

    VBA coding search box through multiple sheets

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • If you search by month, what happens when you have data for the same month but in different years? Also, if you search by description, is it possible to have the same description on more than one sheet?

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!