Hi,

I have a column of formulated data (results from looking up on another
sheet) in column B.
Based on the date value anyone puts in cell a1 this sheet...

I need a macro that would copy the results in row B, and paste values
in C.

(ex. If someone puts 9/2 in cell a1, the macro would find that date
value and copy the cells in column B based on matching that criteria
and paste in C.).

Cell A1= date

A B C
results from formula values copied
9/2 123 123
9/2 456 456
9/2 789 789
9/2 012 012
9/3 123
9/3 456
9/3 789
9/3 012

If there are any easier ideas, please let me know. thanx.
Thanx