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:
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:
something like:
Hope this makes sense and that someone can help!
Thanks
Bookmarks