found

Hello all, I'm trying to draft my own search function from a list found on one sheet. Function Contactr(target As Long) Set NOCws = ThisWorkbook.Worksheets("NOC") Set Conws = ThisWorkbook.Worksheets("Contact") lrow = Conws.Cells(Rows.Count, 3).End(xlUp).Row With Conws.Range("C5:C" &...

I spent a while trying to find out if there is an up-to-date version of the Selenium add-in, but haven't had much luck. It's an add-in that allows VBA to manipulate Chrome and Firefox as object models just like IE. This would be tremendously useful since IE is not able to navigate some...

How do I get excel to Highlight words that have the same first two characters from two different cells For example <tbody> A B 1 abfgr( this should highlighted since the same first two letters is found in cell B2) gh( this should highlighted since the same first two letters is found in cell...

I have a macro which I have written to color A3:E3 with an accent style as well as where "Grand total" is found + 4 columns after Grand total is found The macro colors A3:E3 + E4 and does not color the rows where"Grand Total is found" + 4 columns after this for eg if Grand Total is in A64...

Hello... My work computer was recently upgraded and Excel now is hiding workbooks that I have open. I'm not hiding them, but until I found out about how to find hidden files, thought I was losing them. When I Googled "excel hides my workbook and I can't get it to stop", I found all sorts of...

I know that's title gore and I am sorry - that was my best effort! I need some VBA to help search for the word "Qualification" which will always be found ONCE in column A. Once found I need to copy the whole cell contents and paste it to the left of cell that contains the string "Name" (which...

I've imported an XML file into excel but it did not input that neatly and am now trying to extract the data out that I need. There are a number of department in the data with performance ratings. The number of departments is not always the same and the number of performance ratings is never the...

The List Search add-in developed by Excel Campus is fabulous. Exactly what I needed. A number of other people are going to be using my workbook, and doing so on a number of different computers. Having everyone download and install the List Search add-in may not be practicable. I would therefore...

Well this is probably an easy answer but all I have tried gives me an error. This is the part that works as intended but I cannot derive the sheet name where found and the row it was found on that sheet. ElseIf rng Is Nothing Then Set ra =...

Hi All, I've seen many posts with questions similar to my own but cant find one to solve my problem. In fact I have a few issues which I will detail here, any solutions to any of them will be extremely helpful. I have a report I export into excel, the report is multiple sheets each sheet...

Hi After browsing a bit on the topic I cant find any information if it is possible to follow hyperlinks to hidden sheets through the hyperlink function? I have found several ways with the normal link option but the name in my function is a value found by formulas it would require some extra...

Hi - I have data on Sheet1 A:Z. I want to search column A for text that is entered on Sheet2A5. Once that value is found on Sheet1, i want to copy from where its found in A to Z and down 6 rows. So if Sheet2A5 is found in sheet1A30 Sheet1A30:Z36 is copied and pasted to sheet2AB5. thanks!

Hi all, I have a macro that loops through a list of items, locates them on another sheet via a FIND method and collects some data pertaining to the found item. It works well, except that it stops when the item is not found. To handle this, I used an On Error Resume Next statement, so that the...

I am looking for some sample code that will create a visio document from info in an excel sheet. I had done a couple of versions myself about 8-10 years ago but have been out of the game and lost my toolbox of code modules. There used to be a lot of examples out on the web but I don't see very...

Hello All, I'm looking for efficiency so a formula or VBA will work for this. I'm trying to find the best way to create a title that is as close to 80 characters as possible So the title is broken down like this Quantity - Color1 - Brand1 - Size1 - Style1 - Pattern1 - Size2 - Brand2 -...

hello all, i have been searching quite some time for this but have not found a VBA script that meets my needs. hoping you can help. I am looking to have a button at the top of my sheet when clicked, will search col. F in sheet8 for any duplicates. If duplicate entries are found it will display...

Hi all, I have the following LOOKUP formula =IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($FL$3:$FL$10002=C3)*($FM$3:$FM$10002=I3)),$FO$3:$FO$10002),"Backorder")) This seems to work most of the time but for some reason results "" when there is nothing found in FO3:FO10002 Sometimes...

Hello, I'm trying to code a macro to search for specific text in one column, then looking in the same row in the next column for specific text, and if found, deleting that entire row. For example, in Column G I want to search for FILL CP VHCL. Say this is found in G7 and G8. If the text in...

What I would like the code below to do is find the value of the variable "str" then place the value of the textbox called "TxtBxBlkBlnd" inside Range(found.row, "Column Letter Here") but I keep getting that same Runtime error '1004'. Would someone mind explaining what this error means in simple...

I have code that High Lights Duplicates in a Workbook. Out of the 12 sheets only 7, I want to find dup's. All 7 are formatted as Table's and are identical. It also high lights the tab when one is found. It works perfect but I cant figure out how to exclude 4 of the sheets. Columns are A - T and...