Can anyone help .I should have done this in a database to start with,
however it’s a working spreadsheet that’s growing all the time.
Basically it’s a tally of what I have sold. the problem I have is if
the customer has paid or not I have the text yes or no in a cell .
what I would like to do is If cell =”No” then copy the complete row
“Name, date, Product etc into another sheet that I will call unpaid .
has anyone got any ideas as to how I can achieve this . so far I have
tried auto filter and macros . I can do it manually by sorting then
copying. I Would appreciate any advice please.
Thanks Paul