search and return

Hi, I am trying to build a Macro that searches for a term in the data across a number of worksheets (from the 2nd to the last) and for all rows that contain the search term/partial match, in any column, it returns that row to the first sheet - so it functions like a results page. I almost have...

Hi Everyone, Here's what the data looks like that I'm working with (within a single cell; A1): Eric (2) Dana (3) Tina (4) I am looking for a formula that can extract the number within each pair of parentheses and place each number in a different cell: 2 in cell B1, 3 in cell B2, and 4 in cell...

<tbody> Run ID Carrier ID % LIVE Cut Time LOADING/DONE Trailer # Bills Cut </tbody> Above is the information that is contained in each work book. I need to create a Macro that will allow me to search up to 7 days of these files. Each day of operation is saved to a new file. I need to be...

Hi there, I have a list of text entries eg A1="this dog is a brown one", A2="why is my cat yellow?", A3="the red bird flew away". I would like to search these entries to find a match with any one of the following list, D:D="red, blue, brown, black, yellow" and return the word that matches, eg...

Good day to all I use this code to search an excel with 44000 rows and 18 columns Public Sub FindAll(ByVal MyPath, ByVal myWB As Workbook, ByVal WB As Workbook, Search As String, Reset As Boolean, mycounter As Integer) 'Dim WB As Workbook Dim WS As...

Hi, i am trying to find a value in an array based on partial input from a user. The user will enter the last four digits of a number. then the fomula should find the number in a list and return that complete number i will explain using example. here is the list of numbers (array): <TBODY>...

Hi Guys, Tried a few things to get this working but nothing so far; looking to return multiple cells when text is typed into a cell, for example: <tbody> Moscow Mule Vodka 1 **SEARCH TERM** Lime 3 Ginger Beer 1 Angastora bitter 1 </tbody> So when Moscow Mule is typed into...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am attempting to use Excel to search through several hundred thousand records and return a unique identifier based on two user defined inputs. <o:p></o:p> <o:p></o:p> I have succesfully used...

Hi everyone, I'm not sure how well I can explain this it may be easier to send the excel file so you can see but here we go, this is for a Survival Football League: On Tab 1, I have 15 names in Column A, in Column B I have their pick of team. On Tab 2 I have all the games along with With the...