Tet Htut Naing
Board Regular
- Joined
- Mar 28, 2015
- Messages
- 101
Hi,
I have a big question of insertion of new rows.
I have excel book, in which 4 sheets have data of staff of my organization. But all of the staff name are put in column B of all sheets, especially with same numbering. For example,
<colgroup><col><col></colgroup><tbody>
</tbody>These numbers and names are identically the same in all sheets. I use the formula of =IF(TRIM(B4)<>"",COUNTA($B$4:B4)&".","") in Column A, whenever I put a name in column B, then it will automatically numbering in Column B. That is simple.
But one of the staff is to delete in sheet 1, I need a macro for deleting the same row in sheet 2, 3 and 4.
Again, more complecated, maybe, if a row is inserted in-between number 2 and 3 in Sheet 1 for new staff, then I need two things:
1. In those row insertions, fill always the formula for numbering in Column A in sheet 1.
2. Moreover, In sheet 2, 3 and 4, there will be formula for linking with Sheet 1, to auto appearing of Staff name; I need it with relative reference. For example, in sheet 2, row number 1, Column B, I put this - =Sheet 1!B1. That formula is not working relative referencing of new insertion.
Is it possible to do so with macros. I tried several times with record macros with relative reference, it always ends with errors.
Please Help me!!!
I have a big question of insertion of new rows.
I have excel book, in which 4 sheets have data of staff of my organization. But all of the staff name are put in column B of all sheets, especially with same numbering. For example,
1. | Tet Htut Naing |
2. | Moe Thar |
3. | Myat Thu |
4. | Myat Ko |
<colgroup><col><col></colgroup><tbody>
</tbody>
But one of the staff is to delete in sheet 1, I need a macro for deleting the same row in sheet 2, 3 and 4.
Again, more complecated, maybe, if a row is inserted in-between number 2 and 3 in Sheet 1 for new staff, then I need two things:
1. In those row insertions, fill always the formula for numbering in Column A in sheet 1.
2. Moreover, In sheet 2, 3 and 4, there will be formula for linking with Sheet 1, to auto appearing of Staff name; I need it with relative reference. For example, in sheet 2, row number 1, Column B, I put this - =Sheet 1!B1. That formula is not working relative referencing of new insertion.
Is it possible to do so with macros. I tried several times with record macros with relative reference, it always ends with errors.
Please Help me!!!