Comments by vbn.saravanakumar (Top 4 by date)

Hi Zachary.shupp,

I have no exact solution. But possible other options are:

- If you are maintaining separate sheet for each day, then please enter current date in a cell. Instead of Today(), we can use that cell.

- We may use a macro to get the date. There we can check whether the cell is already filled with a date. If not filled, we can take that row for processing.
For example:

Dim Counter As Integer
Dim CurrentValue As String

For Counter = 2 To 10
Range("D" & Counter).Select
If ActiveCell.Value = "" Then
CurrentValue = Range("B" & Counter).Value
If CurrentValue = "Mitigated" Or CurrentValue = "Escalated" Or CurrentValue = "Offline" Then
ActiveCell.Value = Now()
End If
End If
Next Counter

But we have to run the macro if any value changed in column B. Otherwise we cannot get correct result.

Hi..<br>
 <br>
Let me know the exact error message you got..<br>
Please make sure that, <br>
- you have enough number of columns in the data grid view (as per your requirement I have added 7 columns in the dgv). <br>
- you have data in the data table. <br>
- the dgv is not a data bound one.

Hi..

Another possible solutions is to read the Excel data into a data table and apply RowFilter to get all the records that meets the required criteria..