find a keyword

I have macro in VBA that uses a data set in excel. Then it filters all but one specific vendor. Everyone else is removed from that data set. Unfilter. Then I'm left with headers only and no data lines (line 2 and below) or I'm left with header data and data in lines 2 and usually more. Then...

Hi Guys, Can someone help me how to simplify this code? Sub Macro2() ActiveCell.FormulaR1C1 = "=RC[3]&R1C2&R[1]C[3]" Selection.Copy Range("A2").Select Selection.End(xlDown).Select Range("B1596").Select Range(Selection, Selection.End(xlUp)).Select ActiveSheet.Paste...

Dear all Master.... Example : <tbody> A B C D F G H I J Items 7/6/2018 7/7/2018 7/8/2018 7/9/2018 7/10/2018 7/11/2018 7/12/2018 Result Bananas 1 1 1 ? Apple 1 1 1 ? Orange 1 1 1 ? </tbody> I really need help, i want to find a Date in result column when found first "1"...

Hello, I have a macro that does plotting on a group of files. But if the file has a particular word "[VERISION]" I need to skip it. I wrote the following that is within a loop for the files: ActiveSheet.Cells(1, 1).Select On Error GoTo GoodFile: Cells.Find(What:="[VERSION]"...

I have been working in document.docx where I want to open Excel file as object, find some text in this object and delete entire row of found text. I had opened the EMEA CC FINAL LIST.xls successfully but I am getting error in finding the text. I am new to VBA, please help. Dim xC As Object...

Hi guys/girls I'm needing some help please. I am self taught macro writer and I am having issues trying to figure out how to write this macro. Essentially, this is what I am trying to do:- - use a word filter on column D to find the word "Total" - there will be 8 rows in total - copy the...

So I'm missing something simple but I just can't see it. I'm using .Find to search cells in a range("J6:BFA6") dim'd as "Name" for a user entered word from range("E5") dim'd as "NameS". If the value isn't found, the column becomes hidden, if it's found the column unhides. It hides the columns...

I have a spreadsheet with multiple sheets. I have two columns in sheet1 (Let's say it's column A and C). Column A and C are related (A is name, C is Status) Some of the values in column A can be found in Sheet2 (say column A as well). Some of the values in column A can also be found in Sheet3...

Hi, I am a new macro user I have a folder, which consists of lots of excels. Now I need to create a new excel with a macro that can, (After running the macro) 1. have a text box to ask me to type in what keyword I want to search for. 2. search through all the Sheet1 in all my excels in that...