I want to consolidate the monthly data into Yearly in a single work book.

[krishco68]

Dear Expert,
Please understand my problem,
In a workbook, I have opened 31 sheets and Renamed them Date wise, In the daily sheet I have entered some figures and Consolidated some files in a Consolidated Sheet and named the workbook month-wise. then for the next month, I am clearing the entire daily data sheets and renaming the file with the month name. Now I am saving this file month-wise in a folder and then I am consolidating all these monthly sheets manually in a Yearly sheet month-wise.
Now I need all these things in a single file.

Please go through the attached images for your kind reference, I am unable to attach the file. Even if I clear the daily sheet the data should be there in the month-wise consolidated sheet. then all the monthly data should be consolidated into another yearly sheet.

Please help me in this regard,

Regards,
Murali Krishna R.

 

[awoohaw]

I suggest you use power query to do this task. Mr. Excel has another forum page for POWER query questions and information.
There are also youtube channels (ExcelISFun, MyOnlineTrainingHub, and Leila Gharani) that all have videos that can get you started on it.

 

[Joe4]

I suggest you use power query to do this task. Mr. Excel has another forum page for POWER query questions and information.
There are also youtube channels (ExcelISFun, MyOnlineTrainingHub, and Leila Gharani) that all have videos that can get you started on it.

...or considering what you are really talking about is a Relational Database, use a Relational Database program like Microsoft Access or SQL, as it was designed for this sort of thing.

If you are stuck using Excel, then I agree with awoohaw, using Power Query is probably the best way to go.

 

[krishco68]

I suggest you use power query to do this task. Mr. Excel has another forum page for POWER query questions and information.
There are also youtube channels (ExcelISFun, MyOnlineTrainingHub, and Leila Gharani) that all have videos that can get you started on it.

Thank you sir for your valuable suggestion.

 

[krishco68]

...or considering what you are really talking about is a Relational Database, use a Relational Database program like Microsoft Access or SQL, as it was designed for this sort of thing.

If you are stuck using Excel, then I agree with awoohaw, using Power Query is probably the best way to go.

Thank you sir for your valuable suggestion.

 

[Joe4]

Note: Question re-posted here in "Power Tools" forum: Consolidating some fields from Daily sheets to Monthly and then yearly sheets in a single work book