Hello Team,
am ready reach to a point that am stuck, cant find the proper solution, so i want some help from your expertise.
basically i have 2 sheet, current employee (sheet1) and leaver employee (sheet2), to move the employee from sheet1 to 2 very simple, i use
that move to the end row the employee leaving, however if the employee withdraw, i want to create the button in sheet2 to putting back the employee back in his specific row based on his employee number not at the end of the sheet ..
example,
1 - nameOF1stEmployee - HisDepartment-Age1
2 - nameOF2ndEmployee - HisDepartment-Age2
3 - nameOF3rdEmployee - HisDepartment-Age3
4 - nameOF4thEmployee - HisDepartment-Age4
5 - nameOF5thEmployee - HisDepartment-Age5
6 - nameOF6thEmployee - HisDepartment-Age6
7 - nameOF7thEmployee - HisDepartment-Age7
so to remove the 4th employee, i easily remove him using the above code at the end of sheet2, however if i want to bring him bacl to sheet 1 between 3rd and 5th employee, i cant do it, please help.
thank you
am ready reach to a point that am stuck, cant find the proper solution, so i want some help from your expertise.
basically i have 2 sheet, current employee (sheet1) and leaver employee (sheet2), to move the employee from sheet1 to 2 very simple, i use
VBA Code:
ActiveCell.EntireRow.Cut Sheets("Sheet2").Range("A65536").End(xlUp).Offset(1, 0)
ActiveCell.EntireRow.Delete
example,
1 - nameOF1stEmployee - HisDepartment-Age1
2 - nameOF2ndEmployee - HisDepartment-Age2
3 - nameOF3rdEmployee - HisDepartment-Age3
4 - nameOF4thEmployee - HisDepartment-Age4
5 - nameOF5thEmployee - HisDepartment-Age5
6 - nameOF6thEmployee - HisDepartment-Age6
7 - nameOF7thEmployee - HisDepartment-Age7
so to remove the 4th employee, i easily remove him using the above code at the end of sheet2, however if i want to bring him bacl to sheet 1 between 3rd and 5th employee, i cant do it, please help.
thank you