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