Average

[Link]

Hello Excel experts

I would like to ask you for favor.

I am getting a report every month with data covering last three months (see example in the attachment). On the "raw" sheet are the data what I got for processing. I would like to have a macro which will count average of data in column "D" for every month separately. Then the result will be loaded to a table like you can see on the "avg" sheet. The macro should be executable by hitting the "count button".

All replies are appreciated.

Thank you in advance.

[Domski]

Have you thought about using a pivot table?

Dom

[Link]

Have you thought about using a pivot table?

Dom

Hi,

Yes I know pivot table is an option, but for this I would need a solution as I described. The attached report is just a small part of a much bigger entity.

Thank you for you advise.

[Domski]

You wouldn't want to use a pivot to summarise the data then? It would be quite easy to put together a macro to create one automatically.

Dom

[Link]

You wouldn't want to use a pivot to summarise the data then? It would be quite easy to put together a macro to create one automatically.

Dom

The length of raw data differs every month as each month has different count of day so I am bit confused by defining input data for the pivot table. I don't want to do that manually. Would it be possible to automatize it? Could you please show me an example?

Thank you

[Domski]

How about this?

Please Login or Register  to view this content.

Dom

[Link]

Hi Dom,

Thank you very much for this code. It works perfectly in a stand-alone solution but it is not implementable into a complex reporting system. I would really appreciate if you can help me to figure out my original request.

Thank you

[shg]

Link, please don't quote whole posts; it just clutters the thread. Use the REPLY button, not the QUOTE button.

Thanks.

[Link]

Can anybody help me to figure it out please?