vba search

Hi All I have a workbook, and I have included comments throughout the workbook symbolised with "xxxFH: comment", in which the comment varies depending on what I'm trying to comment on in that specific row. I've got a lot of them throughout the workbook. I've basically included an additional...

The situation is as follows: I have a "main table" which is *full* of data. Im talkin abut 1500 entries. Then i have another table, which is for filtering. I have already figured out how to filter the table for what im looking at. But what i now need is a way to search for a selected value...

I have the below code which finds text based on what is in cell D1. I have a button connected to this code but what i want to happen is when the user presses the button once its finds the first instance, then if the press again it goes to the 2nd and so on down. Currently it just finds the first...

Hi Guys, Was hoping someone could look over my code and see if I am doing something weird to cause an issue with my search Function. My code is looking on a data sheet and searching for text I have entered in a named range CYEAR & " " & Rperiod2 = "2018 Budget" For some reason the search...

Hi guys I found this search on sheet change on youtube and have used it in my code as it did look rather impressive. idea is here you select a search range, a search input cell and output cell for the results. You then enter you search term and if prints all matches in and below the output...

OK, so here is what I am looking for. Is there a way to write a VBA code that will search real estate websites for a "keyword" in the property description and if it finds said keyword return the MLS# associated with said property. Why I ask is there are some real estate websites that allow...

Hello, I'm pretty new at using VBA. I would like a button on a UserForm to open up an InputBox that requests a value. The code then needs to look up the value in a particular sheet. Based on that found value (which is always in Column A) I will need a MsgBox to pop up that will display some of...

I am working on a macro that searches through Column A (Sheet 1) for a list of values on Sheet 2 Column A. Once a value is found in Column A (Sheet 1) from Sheet 2 Column A, the macro returns the corresponding value in Sheet 1 column B from Sheet 2 Column B. The number that is being searched in...

Hi guys, I am a beginner when it comes to VBA code. I can write the simplest of codes however am having trouble with one. I have a table of data (a GL download) and am creating a reconciliation macro. As part of this macro i need it to look for a specific format of data, within a certain...

Hi All I am trying to write a code to analyse a column and lookup each value in turn on a seperate table. I would like it to look at the value (text comment) and if it contains a key word in a lookup table return the corresponding value and input it into the adjacent column. So far my code...

Data (i.e. 34864) in cell A110 of "Mod" sheet needs to be copied to Cell B9 of "Email Data" sheet. Logic for copying is - The VBA code will search for "COUNT(DISTINCTM.TRANS_ID)" keyword in "Mod" sheet and when found will move to next two row down and copy data(integer value 34864 / or any...

Hi All, I am fairly new to VBA and am trying to create a automated spreadsheet to record and display. I have managed so far to source and amend codes accordingly todo this but I have hit a wall. As part of the spreadsheet I would like to include an issues log, whereby all problems that have...