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!!!
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!!!