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