Forum Discussion
Reverse engineer data sheets from excel spreadsheet with summary percentages.
I need to make 100 individual data sheets with the answers that correspond to this summary sheet: Yes Refused Not offered Red Yellow Blue Code Question ...
What problem you are facing to do so? You may need VBA coding.
I was referred here by the Excel Customer Service because they did not know how to help me. I do not know what VBA coding is.
The question is why do you need 100 data sheets. and what do those data sheets need to look like?
I would recommend against creating 100 data sheets and there could be a better solution.
But in simple terms for what you ask, you could
a) create 100 data sheets
b) highlight / copy header
c) highlight/select all 100 data sheets
d) paste header where you want it
e) Use a formula like =index(sheet1!a2:m102, sheet()-1, )Here is the summary page:
Yes Refused Not offered Red Yellow Blue Code Question G1a Did the dog eat his food? 98% 1% 1% G2a What color is the ball? 95% 1% 4% G2b What color is the dress? 28% 34% 38% I need to make 100 sheets of this same page, but have the computer enter the answers, like this:
5/30/2023 Yes Refused Not offered Red Yellow Blue Code Question G1a Did the dog eat his food? x G2a What color is the ball? x G2b What color is the dress? x - oh and you need those answers to be in the percentages shown in the original (hence the reverse engineering part) and let me guess the combinations need to be random too? So we can't give a solution with sheets#1-N be the first answer where N is the percentage for that first response and then sheets#N+1 to M be the next response% where M-N is the second response %, ... But instead you want random selections / combinations for the positions of each corresponding response?
