Inputting UserForm data into specific cells

[porky2j]

Hi Guys - hoping you can help again. By far the most useful and
helpful group I have been on so thanks for your help so far!

I have put together a UserForm to help with data input to a large
worksheet. The worksheet contains information on various fitness
assessments. Each assessment is grouped in columns (overly simplistic
example below).

A B
C D
test 1 test
2 test 3
1 Name
2 Test date
3 DoB
4 Run score
5 Bike Score

What I am trying to achieve is twofold:
1) For each entry on the UserForm I want to assign to a specific cell
in the worksheet for it to be dumped into.
2) I have "Test #" as a text box on the UserForm. Is it possible to
use this to further define where the data should be dumped? i.e. If I
specified that it was test 2 on the User form the data would be dumped
in column C, test 3 into column D etc..

I have been trying to get the "Test #" input to define the column, and
other variables (name, test date etc..) to define the row (like co-
ordinates). However I am not sure if this is the right way to approach
this?

I would be very grateful for any help or advice. Thanks so much for
your help on this

Best wishes
Paul

 

[porky2j]

Sorry, my attemt at an example was terrible!! Trying again....


A B C D
1 Test 1 Test 2 Test 3
2 Name
3 test Date
4 DoB
5 Run Score
6 Bike Score