Hi

I have a set of data from column A to DO, This data are based on
formulas linked to another worksheet. Once the main sheet gets new
data the Sheet having formulas must copy the formulas from the last
row and paste the same in new row, so that the corresponding new data
gets updated in formula sheet.

For example

A B C
1 =([worksheet1]A1) =([worksheet1]B1) =([worksheet1]C1)
2 =([worksheet1]A2) =([worksheet1]B2) =([worksheet1]C2)

When i update the Raw file with ROW 3 details, The formula sheet
should copy the formulas from Row 2 and paste it in row 3 so that new
changes takes place.

Can you please give me the VB code for the same.