search macro

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...

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...

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...

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...

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...