radio button assistance

[Martyn1986]

Ok my knowledge on Excel is not brillaint im not clue'd up like some people are but know the basics.

The idea and outcome required:
The idea is to create a questionaire using Excel, there will be a list of around 100 diffrent questions depending on what is initally selected (im ok with this part) So for example the first question would be do you like dogs yes or no (radio button) then if yes is selected the next question would appear Do you have a dog (yes or no). Now the end result i am after is a seperate worksheet collating all this information and inserting it into a free text field or something that i can copy and paste from
The end outcome would read something like so.
I like dogs but i do not own a dog (this would be if i like dogs was answered as yes but i own a dog was answered as no)
or
I like dogs and i also own a dog (this would be if yes was answered to both)
IT does not have to read like this it could be in a bullit point fashion but the end result would need to be the same
I like dogs
I own a dog.

My question is how do i get this information onto the other worksheet in this layout?

I have no idea where to start so a very basic step by step explanation would be very much appriecated.

Seriously anyone who can figure this out will be a massive life saver..

[Richard Buttrey]

Hi,

Rather than start off with radio buttons, which might imply the use of macros which may be a bit advanced just at the moment, why not use simple Data Validation drop down cells and create validation lists for the allowable values, e.g. "Yes,No"

Then your final results would be based on the values in the drop down cells.

Regards

[Andrew-R]

Funnily enough I've been looking at something similar to this recently.

I've adapted a cut-down version of what I've been working on to your questions. Does this get you started?

[Martyn1986]

Thats the basics of the start of the questionaire, and im ok with the layout of things its the "report" if thats what you want to call it of the data once all the questions have been answered.

I dont know how to extract the information from what ever questions are answered (through the radio button).

Cheers for the suggestion richard, I did think of this method however i thought it would be a little better on the eye with radio buttons, I think i will have to settle for this option of using data validation drop down boxes.

Question now is, if for example

1.Do you like dogs YES
2.Do you have a Dog Yes
3.Do you like cats Yes
4.Do you have a car No

If this was using a drop down box, how do i then extract the yes's and the no's to another worksheet so it would read (i have split them up so you can

[Richard](inserted from enter name here section) [Likes Dogs](inserted from yes selected from question 1) [He owns a Dog] (inserted from question 2 being selected as yes) [he also likes cats](inserted from question 3 being answered as yes) [however he does not have one](inserted from question 4 being selected as no)

so it would read

Richard Likes Dogs He owns a Dog he also likes cats however he does not have one.

Hope this makes sense what im trying to achieve

If its impossible to insert it all next to each other it would it be possible to do it like so
[Richard]
[Likes Dogs]
[He owns a Dog]
[he also likes cats]
[however he does not have one]

Hope this is a good enough explanation?

[Martyn1986]

Anyone have another opinion how i can do this?

[Richard Buttrey]

Hi,

See if the attached helps.

I've given you two choices. Drop down cells or checkboxes. I don't think radio option buttons are appropriate since unless they're all in different frames only one option button can be selected at any one time.

Regards

[Barrett89]

great but there is something wrong with the attached. I mean, it facing some issue in download.
The other attached files contain so nice work. Thanks all members. Keep it up and where's the
tutorials for beginners(MS Excel 2007)??
pomeranian treats