How to auto reflect text in the Top cell to below newly created cell in Table

[Muralidhar]

How to auto reflect text in the Top cell to below newly created cell in Table.
The top cell contains RAM (Name of person), when a new row is added,
the then the new cell created (just below the top cell with text RAM) should
reflect the same text RAM automatically,
I tried using the formula = C5 its not updating automatically while adding new cells below (new rows).
Kindly advise

 

[Khalid NGO]

Hi,
I think you need to make your cell absolute by using $ sign in your formula.

If you share your sample file; better answer can be provided.

Regards,

 

[shrivallabha]

You mean Last cell where data is entered to be reflected in the first cell?

=LOOKUP(REPT("z",255),C5:C5000)

where C5000 is the last expected data row

 

[Muralidhar]

Thanks for quick reply, below example is excel table, the ENGR column is
reflects name of engineer aaa. This name aaa should automatically repeat
whenever a new row is created using Tab key.
ENGR
aaa
aaa
aaa

 

[Muralidhar]

Its the revers, The data in first cell (above cell) should automatically copy reflect in the next below newly created cell (of the same column same table)

 

[NARAYANK991]

Hi Muralidhar ,

Normally this is not possible ; what you can do is when you have 2 rows of data in your table , use the formula you have posted earlier ; thus , if your Table header is in row 4 , and the first engineer's name is in C5 , in C6 enter the formula = C5. Excel will prompt you for permission to overwrite all cells in the column with that formula. Accept this.

All cells in the column will now show the header label , say ENGR. In the first cell of data , enter the engineer's name ; the remaining cells in the column will reflect this.

Narayan