bluebonnet
01-12-2016, 08:47 AM
Hello,
I am looking to use macros to help with data analysis on a survey. I have a big survey that the results are all located in one sheet, but I want to be able to run a macro that will split the data into sheets based on one variable. For example, if a survey question asks for zip code, I'd like the big sheet (full of all the data) to be split into additional sheets by each zip code. Every zip code responded would get their own sheet, and all of the data for each respondent who identified with that zip code would go into that specific sheet. All of the original data would also remain in the main big sheet. Is there a macro I can write to do this?
Thank you in advance!
I am looking to use macros to help with data analysis on a survey. I have a big survey that the results are all located in one sheet, but I want to be able to run a macro that will split the data into sheets based on one variable. For example, if a survey question asks for zip code, I'd like the big sheet (full of all the data) to be split into additional sheets by each zip code. Every zip code responded would get their own sheet, and all of the data for each respondent who identified with that zip code would go into that specific sheet. All of the original data would also remain in the main big sheet. Is there a macro I can write to do this?
Thank you in advance!