Hello:
Please refer to attached file.
I have monthly sheet as shown with data.
I need to summarize highlighted data for all 12 months in Table as shown in "Summary" Tab so that i can use the PIVOT feature of excel.
I dont mind having formula approach or VB Code to perform this task.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks