VBA to automatically cut, paste entire row based on date input and delete row

Jun 14, 2017
Reaction score
Hi need help urgently!!

Am trying to transfer a record (row) from sheet 1(transfer list) to sheet 2(transferred list), transfer list will have customers details with column G blank with date. Once I input a transfer date on the customer record on G, I would like VBA to transfer the record to transferred list sheet (next available row) and delete the row in transfer list sheet.

Please help!!!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question