Hi All,
I have a Jobtime sheet1 with four column Job No. and Emp ID and Time in and Time out.
I want to move/transfer Job No. and Emp ID and Time in and Time out (Job No. and Emp ID and Time in and Time out if all value exist) from sheet 1
to sheet 2 and remove the value from sheet 1 also shift cell up(or remove row)
If Time out value is not present then don't move/transfer.