search macro

  1. S

    looking for macro to search workbook

    Hello I thought I would ask you good people a question on a workbook I'm developing for my place of employment. We have many SDS sheets for the many chemicals we have at the workplace. The company didn't have very good organization with the sheets which can be a safety and fire hazard because...
  2. C

    Need help! - Search Macro to retrieve a file from a subdirectory

    Hi! I would like a search macro to retrieve a file from a subdirectory and the file will have a lot number with report on end and be a .xlsm. and then it retrieves it. Example; Click button for msgbox to ask what lot number user enters it then it searches through "L:\Job Packets"Product""Lot...
  3. J

    VBA - search and extract

    Hi, This has probably been discussed at length already but i'm unable to find a response that is suitable to my needs. My problem is that whilst dealing with large datasets, i'd like to be able to create a macro which will give me a pop up box to input different types of keys words to search...
  4. N

    Yet Another Complicated Search Code

    Good Afternoon All, My name is Parker and I recently started a new job working in the aviation industry. My first big project that I was given to work on has been excel based and I don't have all that much experience with vba... I have been search on the web and have picked up on a lot of...
  5. garden_rael

    Search a ID Number in VBA HEEEEELP!!!

    I'm trying to create a button to fill a simple form made in Excel It should prompt the user for the account number... and then look for it in a database located in a hidden sheet in the book... if it finds it... it will put the found number on a cell and easy vlookups do the rest... But the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top