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
