Excel formula to copy data from one sheet to another sheet in same workbook

[msk]

Hello All ,

Any assistance in the following regard is appreciated. Thanks in advance.

I need an excel formula for below :

I have an excel sheet(sheet-A) with 10 rows of data. I need it to be copied into another sheet(sheet -B) in the same work book.
If there are some rows added to sheet -A in future , the same should be reflected in sheet-B .

 

[Villalobos]

Hi,

If the VBA is allowed for you then check this approach.