fault

I have set up an advanced filter but it won't update automatically, but then again maybe it's not supposed to! I have a data entry worksheet to which random part numbers are added against known fault codes. All this is numeric. Fault codes are in column A, part numbers in column B. I have...

Has me stumped. Column A: Fault codes (3 digit, multiple instances in random order) Column B: Unique serial number of part that has the fault in Column A. Data is continuously being added to the table. I want to use a formula to extract the serial numbers in column B into columns unique to...

Hi all, I'm new to the world of VBA so forgive me if this is the wrong place to post. I've got a button within an Excel sheet that basically generates an email with some text in the body and the contents of the clipboard (this is always from using the snipping tool). I just can't seem to get...

Greetings! Needing help with a Power Query function. I am trying to do an if formula thatwill find part of a word and return a true if found. Example if I amtrying to find all words that contain fault I want fault and faulty to be returnedas true. Similar to the search function in excel. I...

Dear All, I am working on Excel to make a decision tool. In this task I will have to construct a decision tree (Fault Tree) diagram. First of all A box will be inserted in which the text can be edited, then an AND gate shape or OR Gate shape will be added below it, then one, two or more...

Please can someone tell me if it possible in Excel to look down a column and count if a value (say a user's ID number) appears more than 50 times? I've looked via Google but all of the results are for when you have a known value to count. In my case the data I am using is a list of thousands...

Good afternoon, Can you please help. I have a infrastructure fault spreadsheet, which shows all faults in my building. It has 2 tabs one named Fault and one named EWP. Within the fault tab, there is a column W which states if a job is over due "X" or complete "Y". In What I am after is to copy...

Hi I have a spreadsheet that is produced by a Co-ordinate Measuring Machine. it is a simple 47 row by 11 cols with numbers in black in the cells. If the measurement is outside the tolerance of the part being measured, the result is a number but it is in red with strike-through. I need to...

hi! Can't seem to find the fault in my code. Returns an Object required -error. I think the problem lies where it finds the sheet with the *support*-part and the sets it as the active worksheet... Sub help() Dim wscount As Integer Dim ws As Worksheet wscount = ThisWorkbook.Worksheets.Count...