duplicate data automatically

[navkaran]

Hello,

I have a certain Data sheet in which only data is added.
But i have lots of formulas and analyses, on these data, which makes the number of columns huge

So, i wish to automatically update data in a new sheet 'analysis' as and when i enter data into the Data sheet.
here i will hide the data rows, and only work on analysis to be used in my pivot tables and charts.

Is there any way to automatically copy data to another sheet, as and when i am filling it into the data sheet(can be an event too, like after i activate my analysi sheet)

[thinkspac]

So, i wish to automatically update data in a new sheet 'analysis' as and when i enter data into the Data sheet.
here i will hide the data rows, and only work on analysis to be used in my pivot tables and charts.

What data? All? Some? Only the new data?

Is there any way to automatically copy data to another sheet, as and when i am filling it into the data sheet (can be an event too, like after i activate my analysis sheet)

Multiple ways... VBA, Formulas... Depends on what you are actually trying to accomplish as an end result.