Hey Carlos
This sould pretty stright forward and a good one to learn on.
And as always with Excel there is many ways to skin the cat.

Your Macro need merely hold the value to look up 15/01/2008 in yr eg.
Then activate the other workbook, systematically search an area for your
lookup value.
You will now have a location to copy to it is a simple step to code the
copy.

Have fun

Aloha
Jeff


"Carlos" wrote in message
...
Hi,

I'm trying to work out if it's possible to create a macro that will find a
cell from one workbook and identify that as the "range" cell so it can
paste
information into relative cells.

For example. I have this information being updated daily.

A1 B1 C1 etc
15/01/2008 data 1 Data 2 etc

And I want the a macro that will search another workbook to find the Date
15/01/2008 and make this the range cell so that I can copy and paste B1,
C1
etc into the next cells.?

Can this be done?

Thanks
Carl