Trend Reporting Function help - possible Macro

[M4RSH]

Hi,

Need some help in being able to produce some trend reporting. I can build what I want with countifs but I believe the longer term solution may be a Macro. The trend reporting looks like below

................................STAFF NAME 1...............................STAFF NAME 2
.......................Yes.......No........N/A......Percent......Yes........No........N/A.......Percent
Question 1..........3..........1..........0..........75%..........4..........0..........0..........100%....................> ETC.
Question 2..........4..........0..........0.........100%..........4..........0..........0..........100%

The number of yes's are set up as countifs of range=agent name & range=Yes. Example =COUNTIFS('DB'!$A$6:$A$155,H3(STAFF NAME),'DB'!$L$6:$L$155,$H$4(YES'S)) & this is the same for No's & N/A's.

What I would this to be able to do is have all the staff names on a drop down, click a "Generate" button and then it perform the Countifs so that the trend is only showing one person at a time. I.E

................................STAFF NAME 1
.......................Yes.......No........N/A......Percent
Question 1..........3..........1..........0..........75%
Question 2..........4..........0..........0.........100%

Anyone any ideas?

[M4RSH]

BUMP - to shift post back up the list from page 4

[M4RSH]

Bump - To shift my question back up.... Anybody any ideas?

[M4RSH]

Can anybody help this? I am in real need here....

[M4RSH]

So no-one can help me or offer any suggestions on this one?