write userform data to cell based on column header

I've got a question about writing data to cells in a spreadsheet.

While I can locate the row I need to input data in a Sheet, and then copy the data by stipulating the letter head of the column (eg. Column A, Column B, etc), is there anyway to write the data based on the column header (the value that I put in the first row.

My current code is as follows:

Please Login or Register  to view this content.

In the Sheet, the first row of column K is marked as obuPreChangeSubmit
the first row of column L is marked as cboPreChangeMetricBlocks
etc.

Ideally, instead of identifying the particular cell based on the column letter, and then writing the data to that cell, can I identify the column based on the data in the first row?

eg. instead of:

Please Login or Register  to view this content.

something like:

Please Login or Register  to view this content.

Hope this makes sense and that someone can help!

Thanks

Cross-post http://www.ozgrid.com/forum/showthread.php?t=169753