Trying to Create a Summary Report

[Mcrawiva]

I have a number of worksheets where I have extensive data on Energy Generation. In each worksheet I have added a column (AA) where the data for the day is totalled (I do this manually too and would like to be able to automate it but that is not my biggest issue right now:-)).

I want to take the total power generation by technology type for each day and place it in a summary sheet. In the attached spreadsheet I have done this manually (summary sheet) but it is very time consuming, especially since I have to do this for many many more months of data.
Could someone please help me understand what would be an easier way to summarise the data?

[jaslake]

Hi Mcrawiva

This Code is in the attached (if indeed I can add the Attachment) and appears to do as you require, including this

"In each worksheet I have added a column (AA) where the data for the day is totalled (I do this manually too and would like to be able to automate it"

Please Login or Register  to view this content.

I've not figured how to add Quotes nor Code Tags with the "New Look"...hopefully this will make sense.

[Mcrawiva]

This looks GREAT!! The challenge now is when I try to run the macro against a new data-set I get the following error:

Run time error '91'
Object variable or with block variable is not seen. I am running the debugger and honestly haven't spent any time on it really but this is where I am at

[jaslake]

Hi Mcrawiva

If the Code works for you in your Sample File and does NOT work in the New Data Set, I'd suggest there's something different in the New Data Set.

Please post the New Data Set (with Code) and I'll see if I can Debug it for you.

[Mcrawiva]

Hi Jaslake, I tried to see if I could see the issue but naw.... So here is the file I tried it on, really appreciate your help.....

[jaslake]

Hi Mcrawiva

The issue is that your Summary Sheet has no Headers; I,ll modify the Code to insert them.

[Mcrawiva]

Ah!! I see, when I put the headings in the summary and run the macro then that works too. Brilliant!! Thank you so much, you saved me no end of frustration really appreciate it!!http://www.excelforum.com/images/smilies/smile.gif

[Mcrawiva]

Ah!! I see, when I put the headings in the summary and run the macro then that works too. Brilliant!! Thank you so much, you saved me no end of frustration really appreciate it!!

[jaslake]

Hi Mcrawiva

This Code has been modified to add Headers to Summary if they don't exist.

Mods and Admins...please excuse the absence of Code Tags...my current Interface lacks that Option

Please Login or Register  to view this content.

[Mcrawiva]

mmmm, not quite got it..my brain is numb, will need to look at it tomorrow...Many Thanks