Hi Everybody,
I have a question of deleting rows without changing serial numbers in the A column.
I need this because I am an office staff and have to handle with staff information. Although I have entered one staff information, he/she may resign from our office. So, I need to delete that row. It is simple. But each and every staff in sheet 1 have link to the following sheets. Then it causes two issues.
One, If I deleted staff number 10 row in sheet 1, the staff in another sheets will not be removed automatically. Two, If I deleted that row, there will be a gap between number 9 and 11 rows, cos number 10 is out.
I want the numbers automatically counted in sheet 1 and that changes in sheet 1 will effect to another sheets.
Can anybody help me.
Htut
Bookmarks