How do I transfer data from one sheet to another?

[jaybb]

On one of my excel sheets I have a varity of questions (about holiday bookings) where the answers are selected by using drop down boxes.

I was wondering how I can transfer the data collected onto a 'receipt' page that will show the answers selected. (Eventually I will want it to be able to automatically work out the cost of the holiday, but I havn't got that far yet!)

Do I have to use a macro? (I'm not too familiar with these)

Any help would be great.

[SOS]

Hi jaybb

Have a look at the attached sample workbook. It might give you an idea or two. It's by no means perfect but it might give you a start

[jaybb]

Hi thanks for that, its has really given me some ideas. However Im still unsure how you did it!

If you have time could you give me a brief guide to how you set up the macro to record data onto the reciept.

Thanks.

[SOS]

Hi jaybb

I've modified the original code slightly.

There are 3 sheets: Values (where you put in manually questions and answers), Questions (which contains the Dropdown Boxes - taken from the Forms Toolbar) and Receipt (which will show the results of the choices made from the Dropdown Boxes).

There is a Sub assigned to the button "Populate Drop Downs" which fills the Dropdowns with values from Cells B1:B4 of the Values Sheet (ie Scotland, England, Ireland and Wales - and then sets the ListIndex to 0 to show first item first). It then does the same for the second Dropdown - filling it with Plane, Car and Boat.

And another Sub assigned to the button "Fill In Receipt" which takes the values chosen from both Dropdown boxes and places those values in the Receipt sheet.

Revised book attached.

Feel free to pm me if you want any more info