How to copy the column automatically in to the other column with reference to the date

Suppose i am working with a column, in that 1st cell i give date, i want to store these data in the another column automatically also with reference to the date all the data which i enter should be auto store in the different column as per the date.

calculation-in-excel-1
AttachmentSize
Day Power Reports - Final.xlsx12.54 KB
Almir's picture

Problem is in date at E2 because it changes on a daily basis

Problem is in date at E2 because it changes on a daily basis.
When you change the date, stored data will be changed as well. This could be done in two ways: one is through VBA. Another way is to add one more column on the left table. That column is supposed to contain date. Next day you could copy table and enter another date. For final output you can do pivot table on such new table. I guess that VBA is more elegant solution.

Can i get the solution in the VBA excel

Thanks you for your quick response.

Can i get the solution in the VBA excel, since i am the excel user, i need some help on that.

Almir's picture

Pivot table is also part of Excel

Pivot table is also part of Excel, but if you want VBA solution, I suggest to ask Nick for beginning. Sorry, I am not that good in VBA.

Almir's picture

How to copy the column automatically in to the other column with

Mohan, could you post an example what it should look like?

Example sheet

Please find the example sheet in the main posting.