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.
| Attachment | Size |
|---|---|
| Day Power Reports - Final.xlsx | 12.54 KB |
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.
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.
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.