hi all,
so heres my problem,
im trying to loop some code using vba.
i have a sheet running which displays my sales orders and i need to know by clicking a button which sales orders are behind schedule
in cell a2 i have the formula = today()
the dates for my sales orders are in cells h7 : h238
and i need the results to be displayed in cells L7 : L238
this is what i need to happen, if h7 < a2 + 3 then display "dates behind schedule" in L7
if h8 < a2 + 3 then display "dates behind schedule" in L8
and so on untill row 238
ok so here is what i have so far: sub blah blah ()
if h7 < a2+3 then
range ("L7") = dates behind schedule
endif
end sub
this works but will only apply the results to cell L7
i also dont want the formula in the cells just the results
ps i have basic experience with excel so i know how to insert and apply code to a button.
please help this has been driving me mad for weeks now
Bookmarks