i know there is a lot of this and i check all of them and really thank you, however, what am searching i cant find it elsewhere, so i decide to check the expert people here in this forum.
so basically, i have a sheet1 where there is information in the row, i want to copy that entire row and paste in the sheet2 only specific cell of that copy row.
I explain, for example, i cut all the row number 5 in sheet1 where the row contain name, department, age , DOB and working day, i delete all this row, and paste only for example the name and age in the sheet2.
this code is very helpful but not what am searching, it copy and delete all the row in sheet1 however it past all the row in sheet2 which i dont like, only specific cell i want them to go to sheet2
thank you very much.