I have a worksheet that uses vlookup to read values from a
input sheet based on date. From the summary sheet I want
to use the date entered and copy a row of cells to another
sheet where the dates are in column A and paste the values
of the coppied cells according to the date entered on the
summary page. When pasting the data I want to use the
value function in order to preserve the data as it is
calculated based on the specific date entered. I want to
use a option button and assign the macro to it so when I
click on the button the cels are coppied to the associated
date on the other sheet within the workbook. Any input on
this would be greatly appreciated.

Tony