automated process within Excel

Hi,

I really have no idea how to do this, but the short story is that I have two spreadsheets within one workbook.The requirement is that when a particular field gets filled in on Sheet1, the content of column (a) through (d) needs to be copied to the equivalent row, column (a) through (d) in Sheet 2.

Can someone please assist ?

Thanks

On Sheet 2

In Column A1 Enter =Sum(Sheet1!A1) etc...

Is this was what you are looking for?

Regards