Hi, I am trying to create a spreadsheet whereby the input of
information into a cell on a row will cause the data from that row to
be transferred to another sheet. The workbook I am creating is a log
for warehouse/ stock discrepancies. The first sheet will contain all
the discrepancies as they arise - with a column titled "resolved by"
where the person will enter their initials once they have resolved the
problem. As soon as this cell is completed, I want that entire row to
transferred to the next available row on a "resolved discrepancies"
sheet, and to be deleted from the first "discrepancies" sheet.

I hope this makes sense!

Any help would be much appreciated. I have some limited VBA knowledge
but this is beyond my capabilities!