C
Carlos
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
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