Hello All!
I think what I want to do is possible. But I cant figure it out. Im not a VBA specialist like most of you guys. Heres my problem. I want to fill blank entries in a column just by plugging in a date.
Name 4/1/2016 4/2/2016 4/3/2016 4/4/2016 4/5/2016 Enter Date
Joe Red Red x x x 4/6/16
Meg Blue x x x x
Sara Green Green Green x x
Tom White x x x x
Paul Tan Tan x x x
So if I enter the date 4/6/16 then every day before with a blank or X would be filled in by the most recent non blank cell or color. Clear as Mud? Thanks in advance!
I think what I want to do is possible. But I cant figure it out. Im not a VBA specialist like most of you guys. Heres my problem. I want to fill blank entries in a column just by plugging in a date.
Name 4/1/2016 4/2/2016 4/3/2016 4/4/2016 4/5/2016 Enter Date
Joe Red Red x x x 4/6/16
Meg Blue x x x x
Sara Green Green Green x x
Tom White x x x x
Paul Tan Tan x x x
So if I enter the date 4/6/16 then every day before with a blank or X would be filled in by the most recent non blank cell or color. Clear as Mud? Thanks in advance!
