Copying row using if function
Sorry to be a pain again
I tried to make it easier to understand but I have now totally confused
myself again.
What I tried to do is a if function where if the date of the entry is more
than 2 years old mark it as yes.
Then I wanted a control to copy all the yes answers and place then on sheet
2 here is a diagram
date comment
21 feb 2002 back from school yes <- this will be hidden in white
text.
I want it to the copy from sheet 1 to sheet 2 and delete the entry from
sheet 1.
I am sorry to be such a pain but I am struggling with this vba language.
Greg
|