Reverse engineer data sheets from excel spreadsheet with summary percentages.

Question

I need to make 100 individual data sheets with the answers that correspond to this summary sheet:&nbsp;&nbsp;&nbsp;YesRefusedNot offeredRedYellowBlue&nbsp;CodeQuestion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;G1aDid the dog eat his food?98%1%1%&nbsp;&nbsp;&nbsp;&nbsp;G2aWhat color is the ball?&nbsp;&nbsp;&nbsp;95%1%4%&nbsp;G2bWhat color is the dress?&nbsp;&nbsp;&nbsp;28%34%38%&nbsp;

harun24hr · Answer

What problem you are facing to do so? You may need VBA coding.

janine_dismukes · Answer

Harun24HR&nbsp;I was referred here by the Excel Customer Service because they did not know how to help me.&nbsp; I do not know what VBA coding is.

mtarler · Answer

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, )

janine_dismukes · Answer

mtarler&nbsp;Here is the summary page:&nbsp;&nbsp;YesRefusedNot offeredRedYellowBlueCodeQuestion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;G1aDid the dog eat his food?98%1%1%&nbsp;&nbsp;&nbsp;G2aWhat color is the ball?&nbsp;&nbsp;&nbsp;95%1%4%G2bWhat color is the dress?&nbsp;&nbsp;&nbsp;28%34%38%&nbsp;I need to make 100 sheets of this same page, but have the computer enter the answers, like this:5/30/2023&nbsp;YesRefusedNot offeredRedYellowBlueCodeQuestion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;G1aDid the dog eat his food?x&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;G2aWhat color is the ball?&nbsp;&nbsp;&nbsp;x&nbsp;&nbsp;G2bWhat color is the dress?&nbsp;&nbsp;&nbsp;&nbsp;x&nbsp;

mtarler · Answer

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?

Forum Discussion

Reverse engineer data sheets from excel spreadsheet with summary percentages.

Share

Resources

		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%