Hi Hitech,

I downloaded your spreadsheet and made the following changes.

- The VBA Script I posted earlier is in the Code for the Leads sheet. Now when you enter a salespersons name, it will autofill the current date in column B

-- I used conditional formatting so that if you select NOT INTERESTED in column H, it highlights the row RED

--- There is also a dropdown list in Column H for you to select the Status code based on the list you had in the Data tab. Use Data validation to create dropdown lists.

I recommend taking a look through the formatting so you can become more familiar with how this was done.

Hope this helps.

salesleadtracking.xlsm