Random search
If column K3 is filled (date) and/or column AC3 if filled (date), I want the
text in column X3 to autopopulate in column AE3 as long as in matches the
mm/yyyy that I have entered in AE1.
Column X will always keep its data. Column AE can changed based on the date
entered in AE1.
AE1
12/2005
K3 X3 AC3
AE3
12/15/2005 Unrepairable 12/20/2005
Unrepairable
12/16/2005 Serviceable 12/21/2005
Serviceable
|