Hi,
Basically I was wondering if there is a way to copy data from a row if a previous condition is met. I have the fields,
Name
Surname
Gender
december
april
july

and basically i was wondering if there is a way so if the gender field has an M in it if excel can copy that entire row? this data is on sheet one and i was wondering if it could copy it to sheet 2?
thank you for any help.
dan