Thread: Dynamic column update

Dear All,
I have a sheet in which i have 4 columns. Every day one record will be inserted.
So whenever a record is inserted the cells of the latest inserted record should be inserted into another sheet in the new row.
Ex:
Sheet1
date data1 data2 data3 data4

22/3/2010 3 3 3 5

So in sheet2 the data should be

date data1 data2 data3 data4

22/3/2010 3 3 3 5

Thanks in advance.

Please attach a copy so we can see what your looking at
Regards
Peter

Hello again
Is this what you are after
Regards
Peter

Dear Peter,

Thanks for ur reply. But here in the input sheet record will be added automatically.

So whenevr new record is inserted same should be updated in the another sheet.

But in ur example we are manually the doing updation of column like A1, A2.

Hello krishnamohan
On the attached sheet, if place a date in the "Input" sheet it automatically transferrs to the other two sheeets. The only difference on the "Modified" sheet is that the cells will remain blank until there is an input on the first page.
The input should be going in row 2 from A1 and A2 all the way to Z1 and Z2.
RegardsPeter