I don’t understand what you are saying but I’m sure you can think of how to
adapt it.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dick
Sent: Saturday, August 25, 2012 7:15 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ If number
I'm so sorry. I forgot to mention Column B. Can that also be added in the
results as well. Same results as now but include Column B. Thanks so much
for your help!!!
On Saturday, August 25, 2012 7:18:03 PM UTC-4, Don Guillett wrote:
>
> Right click sheet tab>view code>insert this
>
> Private
Right click sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mf As Range
If Target.Count > 1 Or Target.Column <> 3 Then Exit Sub
Set mf = Range("c1:c" & Target.Row - 1).Find(What:=Target, _
LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDir
