Help modifying a macro

**_Ryan_** · 02-05-2010, 12:34 PM

I have a macro that was given to me by a colleague, which is great, but I need it to be modified in order for it to do what I want. I work at a hospital and each patient is given a survey. We use this survey to calculate the "% very good." Which is the highest selection that the patient can choose when filling out the survey for each question. We want the care to be the best, so hypothetically we would want the % very good to be 100% for each qusetion.

The macro is used to calculate the average of the % Very Good based on data that is created from where we get the survey data. The problem is that this macro calculates the % very good for all the questions for the whole hospital. I am interested in getting the % Very Good for specific nursing units. So when I run this macro on the unit output, it just gets rid of all the units and bundles the questions together. Is there a way to modify the macro so that it sorts each question by unit, and calculate the % Very Good for each question for each unit?

Please Login or Register  to view this content.

I also attached the file that the macro would be used on. I had to remove the data due to HIPAA regulations.

Thanks!!

**chriseastwood** · 02-05-2010, 01:35 PM

Would a simple solution to your problem be to add a unit column to your data? Imagine that each question had the unit number next to it, (the unit number would repeat,) you could then use the SUMIF function and only sum if the survey's unit number matches a given unit.

**_Ryan_** · 02-05-2010, 02:06 PM

Thats a good idea, the only thing is that I need to utilize the macro. I am trying to calculate the overall patient satisfaction for each unit, but to do that, only certain questions are used to calculate that, this macro pulls out those specific questions, but for the whole hospital. So i need to use this macro, but somehow get it to calculate the overall satisfaction for each unit.

**_Ryan_** · 02-05-2010, 02:10 PM

If its not possible, I guess I could just copy down each unit, for each question, run the macro, sort by unit, and calculate the average for each unit that way...but a macro would be soooo much easier