Hi Can someone please answer the following:
I want to move an entire line from one worksheet to another but only when another cell on the same line shows for example dead or sold
Eg:
Sheet 1 shows
=IF(AND(N3<>""),"ACTIVE",IF(AND(P3<>"",O3=""),"SOLD",IF(AND(O3<>"",P3=""),"DEAD")))
I want the entire line which contains full details of the animal in question to be placed in another sheet only when the formula above is entered to activate which category the animal falls under rather then just the formula above
The entire line shows
Animal ID - Breed- Sex- DOB- Active- Dead- Sold- Status. The formula above relates to Status.