If Statement..i think
Drop down?
"zak" wrote:
Hi
I'm wondering if anyone can help me..
I have a worksheet with a drop down list in column H2:H100 that has two
options; Complete or Pending.
I want to write some sort of macro to say if pending, then leave the row on
the sheet (rows a1:g1). But if 'Complete' is selected then cut the row and
paste it in the 'History' worksheet.
Is this possible?
Thank you
|