lee

Hi! Could someone help me tweak this macro? I want the macro to find specific texts in the header and (the text will appear multiple times) and delete everything in that column but don't delete the header. For example, I want the macro to look for "Mary Lee" and "Bob Smith" in the header and...

Hi All, I have a worksheet that when a cell in column F is changed I want to email out a message to a particular person. I.E. if the cell in F is changed to Production I want to email Chris Smith with a message letting him know that he has a new Non Conformance that needs actioning. If the cell...

I need a table to highlight the cells from C to J IF Cell D contains "Lee" and any cell from E to J Contains "Yes". So for instance .C.. | . D . |. E . |. F . |. G . |. H . | Lee | YES | YES | YES | YES | YES | (All row should be highlighted) -------------------------- Lee | YES | YES |...

Good afternoon everyone. I'm hoping for some help on a formula. I have a list of users where I want to return the maximum score in a given table for a given person. Example: Name Score MaximumScore Stu 4 7 Stu 7 7 Stu...

Hi, I have three long columns of data that look like this: A B C Sam Tim 24 Tim Lee Sue 36 Ann Sue Lee 48 my goal is to match columns B and C with column A. Is there a macro I can use to match them up side-by-side and make them look like this? A B...

B C <tbody> 1 MICHAEL LEE ARRIGO ALEXANDRA LEE ARRIGO Can someone write me an excel formula that will highlight whenever the same word is in both lists? For the example above, "Arrigo" <tbody> </tbody> </tbody>

Hi I have a huge Raw data. Can someone please assist me with some sort of formula or vba code that can extract my data into different excel sheets. I need a formula or vba code that looks into my “Project Status” column and extract all my “Active” data into one sheet. Then extract all my “#N/A”...