reject

can someone help to generate weekly summary per this file? raw data entries: <colgroup><col><col span="4"><col></colgroup><tbody> Date Status1 Status2 Status3 Status4 Week 02 April 2019 Approved Approved Approved Approved 14 03 April 2019 Reject 14 08 April 2019 Approved Reject...

Hi Team I have created drop down list in column " C" and i have Client Reject, Offshore Reject , Onsite Reject and so on other drop down filters... Now whenever i select the drop down list and if it has a keyword REJECT from the drop down list the entire row text font color to be changed to...

Hello to all, I'm new to VBA but can understand some. I need help regarding locking/protecting the active sheet when the value on cell matches my required value. For example, The value will appear on column D. If a value appear on D is "REJECT" the active sheet will become protected. But before...

Hi, So for my job, i'm screening a list that has a ton of URLs. And accepting rejecting them on the basis of keywords in the url. For example: =IF(ISNUMBER(SEARCH(".edu",A2)),"Reject"," ") Another category of words I need to reject are city/town websites like www.picayune.ms.us where the format...

Fellow sufferers! I just want to make a pie chart from arrays holding the values. Please see my code below, which loads the array review_statae into memory. I want to do something like below. I did lots of googling, never found the right way to do it. Public Function piechart_build(url As...

Hi, I am trying to update a cell (LR, 3) with Accept or Reject based on the colors from cell range (LR, 4) to (LR, 8). I am having trouble specifically this line, If Rng.Interior.ColorIndex = 3 Then. What I would like to have happen is that is any of the cells are shaded red from being...