search workbook

Hi, I require assistance with the following On Sheet 1, the person completes a form (each cell contains a drop down menu) - once the form is completed they press "SUBMIT" a search is done on a separate workbook based on the info provided on the form - answers are emailed to the requestor...

Hello, fellow excel nerds. I am trying to get a macro to work (again) that is designed to find all sheets in a workbook that have formulas that are linking to the current active sheet. I found this solution online and it actually worked when I first got it. I created an XLAM to have it on...

Hi all, I work for an oil company and have a master list of all of the leases that we service along with other information specific to each lease. Along with the master lease (which is on one worksheet), I have also created a template for each separate lease using individual worksheets within...

VBA to find and list all sheets with specific text, and place the sheet names in range to be used as loop. I need help to make a few macros please. The first Macro “FindSheets” is to find and list all the sheet names which have a specific word/text/phrase. Let’s say “BOWCHICAWOWWOW”. Then...

I need help with the final touches on this portion of this code. I am trying to use the entry of the "LOT" to activate or select the open workbook with that entry. So if 1023987 was entered, I would want 1023987.WQ1 to activate on the desktop. I have posted a couple of my tries so far. Dim PC...

I'm a relativly new VBA user, so this may be a rather elementary question, but: Is there a way to search for a text string through the entire workbook instead of searching each page individually? My wookbook has 100+ worksheets with lots of data and calculation, and inputs new data as well...