Hello,
I know that someone out there can help me with this question. I have a survey spreadsheet that I built. In addition, I have a macro that combines data from each of the survey that someone completes. However, that's where I am stuck. When the data comes back from the macro it puts it in the following format, single number values from the survey are below each buyer. Question # has the question number below it.
Question # Buyer 1 Buyer 2 Buyer 2 Buyer 3
So, when the data comes back there can be mulitple surveys from each buyer as you can see with Buyer 2. What I would like to build a macro for would be to get a total for each question by buyer group and if there are multiple buyer groups with the same name, they need to be averaged.
I hope this makes sense.
Any help would be appreciated.
I know that someone out there can help me with this question. I have a survey spreadsheet that I built. In addition, I have a macro that combines data from each of the survey that someone completes. However, that's where I am stuck. When the data comes back from the macro it puts it in the following format, single number values from the survey are below each buyer. Question # has the question number below it.
Question # Buyer 1 Buyer 2 Buyer 2 Buyer 3
So, when the data comes back there can be mulitple surveys from each buyer as you can see with Buyer 2. What I would like to build a macro for would be to get a total for each question by buyer group and if there are multiple buyer groups with the same name, they need to be averaged.
I hope this makes sense.
Any help would be appreciated.
Last edited: