I am comparing data in two adjacent columns, one is the 'expected' values and
one is the 'actual' values. I need to use these to create a final column that
contains the 'approved' values. This will involve manual comparing the
actuals against the expected and selecting/approving which one is to be
approved. I thought to do this using checkboxes in the next column. For each
row if a checkbox is ticked the actuals are approved/unticked the expected
are approved. I thought I could write a macro executed with a command button
once all selections have been made/approvals have been completed.

The macro will check each populated row to see whether the check box is
checked/unchecked and based on this, copy the related value
('actual'/'expected')from one of the adjacent column values to the next
available row in the 'approved' column.

However whilst I have them theory my practical skills are limited and the
only way I have managed to do this is to write a macro for each checkbox/row
specifying cells etc.
If anyone can help of a more automated process, or has a better way of
achieving this, please help!!

Thanks!