KPI Report in excel

35 pts.
Tags:
VBA EXCEL 2003
I have a KPI report that I would like to to automate with VBA code which I have been able to do where there was only one score from each region for each company but I am now stuck when the second scores are added to the same list, PLEASE HELP.

The headings to the columns that I need to filter by are (Column F, Category) (column E, Company) (Column C, Region) these are in order of filter;

I then need to extract several rows of data with the same critera as the above filter from the list (This is depending how many scores have been performed by each region over a period of time) and get an average score for each field or Column (Columns G;M).

Then with the filtered columns copy them to the next avalible row in another sheet named "Ave Data" along with the combined average score for each field column. This should give me the average score of all scores for each region for each company  and my original basic VBA should work with a few tweaks.

Any help at all, even if it just how to seperate the rowes after the filter would be much appreciated.



Software/Hardware used:
Excel 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.

Building KPIs with Excel is lost of time… try BSC Designer software, its much better for <a href=”http://www.bscdesigner.com/”>KPI creation</a>.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Sameh
    it's good
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following