Not sure if what I am to do is possible with a formula or not but here it is:

I am trying to search column K for any empty cells and if lets say there is 8 (or however many) empty cells and one of those cells is K98, I want to take cells A98, B98 and C98 and put them into a new set of cells.

Basically what I am trying to do is to find jobs that have not paid and create a list of them. In my spreadsheet column K contains the payment method (Cash, BACS etc.) and if this cell is empty then the client has not paid. Cells in column A have the job number, cells in column B have the date of the job and cells in column C have the address. I want to add any jobs that have not paid into a list automatically using this data. I will then have a section that displays only the jobs that are outstanding payment (if that makes sense?).

Is there a formula that can do this?

Thank you for any help,

Margate