VBA Excel on comparison of two columns using empl id or name

[kochkarun]

Hi,

I am a beginner on working with macros in excel. I am currently trying to overcome challenges on the below items.

1. To compare two columns in excel using macros. The challenge I am facing is that I want to compare using empl id or name which are in multiple rows and add the total value (say time spent in office) under the same empl id or name.
   
2. How to compare an entire column value to a single value and assign color coding?

I used the following syntax:

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">Dim c As Range
For Each c In Worksheets("Sheet1").Range("W2:W" & lastRow).Cells
If Columns.Range("W2:W").Value <= 8 Then
c.Interior.ColorIndex = 3

End If
Next</code>

1. How to extract the information of a particular filter value in a column and use that in the email?

Please provide your inputs! Thanks in advance!