find

I need to find certain columns based on header name in 1 sheet and copy them to another. My code works for "Task Type" and "User". However it does not copy the other columns. I tried using 2 words and it worked. For ex. Instead of "User Email Address", I changed the column header and array to...

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

Hi all. I am trying to find a way to search for multiple instances of a wildcard match in one cell. I want to exclude a specific match from the results. I can't find a way to find and display a list AND exclude certain terms. I have a sheet which is an export of live chat transcripts. The...

Power Query: I have a column with strings and a list of words I need found in that column AND (this is the difficult part) when found these words need to get cut off from the string (or replaced by "")? How? A sort of textual substraction... have been trying so long... list.accumulate etc...

Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks

I am in need of some help to do this in VBA. I have a range of values in a Workbook1.Sheet1.F2:F1048576. I wish to check if any of these values appears in a second range in Workbook2.Sheet1.A2:A1048576. (The actual length of each of both ranges will vary, hence why I've used the full length...

I appreciate the help with this, which will help me learn. I know I can do this with Query from Table, but I'd like to learn it by formula. I figured out how to extract the numbers within the ( parens ) using left and find. Now, I'd like to work out how to remove only the company names via a...

I have a set of data that is formatted one way (including multiple items in a single cell), and I want to extract that data and display it a different way (each item in its own cell, in a column). The data is always changing, so I am looking for a formula that will auto-update as new rows are...

Hi All, I am new to MRExcel and this is my 1st Post. I am looking for a help regarding a mid function. For example :- EBA//92X:RATE:0.99999A://92X:RATE:0.667766B://92X:RATE:9898.18544444A:// I want to extract 0.0667766 in this example but the number can be different for other cases. I open for...

So I have a sheet called "IDs" that has a list of Ids and a sheet called "Results". I want to look through each Id, search all the sheets and print all the location where each ID is found in "Results" print them on seperate cells. So currently right now, my macro is printing only the last...

Hi All, I could use some help with getting the VBA on the following. I have a large range of data, blanks, and multiple duplicate cell values. I need to find (select) matching cell or cells , and then select the rows of those found cells. Not highlighted, just select. My search value is in (...

Hello guys, how can i find all records within a specific month? I have a Sheet with orders, where every order has a finishdate in column "H" from type Date. I want to find now all orders, which are finished in month february for example and sum up a value which is located in column "L". Is...

My VBA have this run time error 91 on the line below that underline with red color. My MRStart1 didn't found anythings and jump to MBranch2: but if my MRStart2 didn't found anythings then the error 91 come out. What is the problem guys? If...

Hello, [CASE 1] I am working on a code to loop through my data, find through the worksheet based on 2 criterias and offset to the column on the right of the find result. [CASE 2] -- If [CASE 1] is not a match BUT if find isn't a match of both criterias... then look through second range...

I have a report that I need to update from the data in another report. Both reports are large, over 50,000 rows, so I read them into arrays so the process would run faster. I need to split the Source array into separate arrays based on certain conditions in the HR array. I'm getting an object...

Trying the following: set Fnd = Sheet1.Range("A:A").Find("Testing") Sheet1.Range(Fnd.Offset(0,1)).Value Doesn't give an error but also doesn't appear to be working, what am I missing?

Hello everyone, I need to create a macro to find in a worksheet the location of every cells which contains "ETH" ( the location can change) and store each in a variables in order to use it after that . Like the picture below. Thanks guys :D

What is the correct syntax to use with the new 365 FILTER function to filter on a character within a string? In the example below, I would like to search for all ADIDs (column E) that has an "R" as the second character...

Hello, I have the following VBA Set Fnd = Range("A:A").Find("name id:", , , xlPart, , , False, , False) and I want to copy that name id information and currently, I'm trying this but it's not working - what am I missing here? Range(Fnd.Offset(1)).Copy Sheet2.Range("A1") I also...

I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...