search and find

is it possible to search by date range and the result will show in textboxes without using datagrid/listbox? i have two rows of 3 textboxes first row should show only the result for the first person, and in the second row of textboxes will show only the result for second person. if date person...

Hi There, I have a code that allows the user to first select a column by choosing header name listed in ComboBox44 and then enter text to search in TextBox1 and displays search results as a row in Listbox1 with headers defined in first part of code , the code runs when I click CommandButton1 All...

Hello, I need to search a keyword across multiple word documents saved in a folder. There are hundreds of such documents and its impossible to open each doc and search for the keyword. I am looking for an excel macro which will go into each of the word documents and return the name of the...

Hello All - When I copy a Balance Sheet from a website the negative figures map over like this "(100,000" as the other parenthesis pastes to the next cell. I then have my own formatted Balance Sheet elsewhere on the worksheet and am able to use Index(Match) to pull over the initial figures I...

Hi I'd like to use the len and search functions in ONE formula. Scenario: I have a spreadsheet where users can input up to 4 characters in a column and they mean a specific thing eg "Jane Fonda" But then they'd only mean that if they contained EITHER a single number or a combination of...

I need to determine if the individual cells in column A (A1:A17933) contain text from any of the cells in column C (C1:C1957), and if so, return the column C cell's corresponding value in column D (D1:D1957) to the column B cell next to the column A cell containing the column C cell text. For...

Hi I'm new here, I'm Debbie and hoping to get some help with a holiday and sickness planner I have been creating. I am looking for a way to copy data from one worksheet to another in a different workbook (I'm using Excel 2010). I have identical column headers in two worksheets, columns D...

Hi, I want to click macro. it searches sheet3 A:A for a value. If it doesnt find it, message just says value not present. If it finds it, it pulls up a userform named "goahead", it consists of three choices yes, no, n/a. whichever one is selected, it places that in sheet3 column z for that...

Hello Guys, I was looking for the codes where I can search for the numbers on the data below so basically it's the [**] <tbody> ID Subject Status Note 1 Science [1] YES 2 Math [49] NO 3 Health [9] YES 4 Sports YES 5 History [29] YES </tbody> Once I run the codes, I can have...

Hi everyone, I'm new with VBA excel and trying to create a dynamic search userform using a textbox and list box. 2 parts to this: 1) When user enters text in userform textbox, it should search the database ( rows and 5 columns), and return the values in list box (with 5 columns in this case)...

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 Would like a code that helps me identify a search criteria and takes me to the entered name or tells me that the entered name does not exist. I have a command box on sheet 1 which will have the stored code, when this button is pressed, it brings up a user entry input box for the name to be...