search and copy

I was hoping you guys could help me with a little vba project I am working on. I have a column of data in Excel that is called "New Status". What I need to do is have code that will search through this column and find all instances of a specific text. There will be 100+ rows of data, and some...

I am teaching myself VB using ms Excel 2010. I am trying to search through 7000+ rows of data for certain keywords, and then pasting these rows to another sheet. I have the code to where it works when I step through line by line with F8, but when I actually run the code I get "Run-time error...

Hi All, I want to automate a sequence so I wanted help in VBA code, the hypothetical example is as below: <TABLE style="WIDTH: 245pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=326><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742"...

I am trying to get the userform to search column B depending on the user input in a text box and then populate text boxes in another userfrom from the cells found in the excel row. the code i have is: Private Sub Printer_Find_Click() Dim ws As Worksheet Dim rng As Range ' possibly...

I have been getting this error: "run-time error 438 object does not support this property or method " when trying to get a click button to search a spread sheet find a value from the entered text box and then read the cells and input them into text boxes in another userform. this is the code i...

Hi i am trying to get a text box to search a worksheet and read the information in that row and input it to other text boxes. at this time all i need to get working is to read the text box and search on the worksheet. so far i have: Range("B1").Find(Columns("b")(Find_Printer.Text, , , xlWhole...

Hello! My name is Francisco and I recently started programming in VBA. I have some knowledge in C and C++, but do an application to work on Excel sheets is posing a different and difficult new challenge to me. I’ve encountered much important information on your site and I want to thank all...

Hi, I've been trying to build a search functionality in excel which acts very much like a web search engine. I have roughly 5 sheets which hold information on a row by row basis. I need to be able to type a keyword into a specified cell, then for every row that contains the keyword (in any...

Hi, I have a list of IDs, say there are 20 of them (that vary) on one sheet (called "ID List"). I need to use this range and search for each ID within a larger sheet of data called ("Estimated Data Log"). What I want is for the code to search for each example of an ID within the log, when it...

I'm trying to write a macro (Excel 2007) that will iterate through one column at a time, searching for a value of "n", and output the value from column A to another sheet. I have managed to make it work for one column, but trying to get it to increment through the other columns is proving more...

To whom it may concern Good Day I have an excel work book with 10 sheets. In that work book 1 to 5 rows are header. I would like to search a Value, Variable or Date as I required. If it found then all rows should copy to a new work book. I need button for run macro. Program should ask what I...

I need to retrieve rows of data from a closed workbook based on a number entered by a user in a cell on the open workbook. The closed workbook has a number of worksheets therefore the code will need to search each sheet and retrieve matching rows. Column a has the number to be searched...

I am very new to VB and Macros and cant find any where two simple tasks. I need to be able to search for a piece of text within a sheet and copy the field next to it.... i.e Search for Grand total and copy value 9. ticket1 4 ticket2 2 ticket3 3 Grand total 9...