Hi,

I think you don't need a macro to do this. What you can do is write a
VLOOKUP() in col B and make col C as '=B1' and so on.

By doing this the values will be automatically fetched in both the columns.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"J.W. Aldridge" wrote:

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