Microsoft Excel - Combo Boxes Saving data 1

[bluebilly]

I have several lists in an Excel Spreadsheet that I can select records from using combo boxes. How can I save the results of my selections in a separate worksheet.
For instance if I have a list of names in say Worksheet 1 in one Combo box & a list of Activities in the same worksheet in another Combo box - I want to select a single name & a single activity and then save these selections in a separate worksheet. I don't use VB - so an explanation without the use of code woule be very much appreciated.

Thank you

bluebilly

 

[Nikita6003]

Range("StartHere").End(xlConstant)

replace xlConstant with one opf the following to set the direction of the End:

xlToLeft
xlToRight
xlUp
xlDown

Replace Range("StartHere&quot with whatever cell you're starting from

Cheers
Nikki