Auto update

[arnab0711]

HI,
I have this spreadsheet where I want with each updation of column E in planning sheet
will get automatically updated in the C column of site sheet under site planned heading

[teylyn]

Arnab,

sorry, but your data layout is less than optimal, to put it mildly.

Your question lacks some more information. Based on the data you posted, what data should be entered in which cells on the site sheet? Based on which processing logic?

Get rid of merged cells. They only complicate matters.
What is the significance or reason behind using Forms control buttons in lieu of cell data labels? Do you want to make things particularly difficult?

Based on the data in the "planning" sheet, which (merged) cell(s) in the "sites" sheet should receive what value?

[arnab0711]

Hi you may want to remove the merged cells,also I want cell E15 being replicated in cell c6 and likewise.