I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if

[abdulkharij]

Hi evryone,
I have the following table in sheet-1 from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1.

Column "Name" in sheet2 is linked to Column "Name" in sheet1

Sheet1 Sheet2
Name Hours Rate Total Name Hours Rate Total
jhon 35 10 350 jhon 35 10 350
David 20 11 220 David 20 11 220
Mark 50 12 600 Mark 50 12 600
Hellen 40 11 440 Hellen 40 11 440
Iren 40 13 520 Iren 40 13 520
Nicole 39 14 546 Nicole 39 14 546

Example: If I add a row with the name "Jane" in sheet-1 it should automaticaly be added to similar table in sheet-2
Thank you,

 

[Somendra Misra]

Closing this thread, as this is duplicate.

Regards,