How do I find the adress that shares the column of a certain cell and row of another?

Help wanted!

I am making an excel solution for a competition. The first sheet has a table of all the participants and all the courses in the competition.

This is what the sheet looks like:

[Number Input]	[Name Input]	[Answer Input]	[BUTTON]
	Course:	1			2			3
Number	Name	Start	Finish	Answer	Start	Finish	Answer	Start	Finish	Answer
101	John Smith
102	Jane Smith
103	Harvey Dent

The user inputs Number of participant, number of Course and maybe and Answer in the topmost input boxes and then presses a button that calls a sub.

That sub is supposed to first find the cell in the "Start" column that corresponds to the course number and participant number inputted, and fill it with current time. If that is already done, then the next click it should fill the corresponding "Finish"-cell with the time. And if an Answer is given, the corresponding "Answer" cell with the answer input.


How do I best go about this with VBA?

All help greatly appreciated!

well, you could use the Cells(row,column) approach where the row/column come from the cells.find(what:="text to find in the worksheet").

Please Login or Register  to view this content.

-----Edit----
Ok, i just posted my reply and now you've posted some code (which wasn't there a moment ago ) what exactly are you trying to do with that code?

ohhhh...

try this one out. I'm going to assume the values are entered in cells labled Nummer and Sträcka (where the label is above the value).

Please Login or Register  to view this content.

SEE ATTACHMENT FOR DEMO

I have a hard time explaining it. I'm gonna start over.