set cell in one workbook to find in another workbook

[s_smith_iet]

I need a macro that will use "C5" from sheet "P123 Datalogs" in
workbook "data log trending v2.0"
and then find it in workbook "P123 Datalog trending"


Please help

Thanks

 

[Bob Bridges]

I think we need to clean up the syntax of the sentence a bit first, to make
the question clearer. You say you need to use "C5"; do you mean you want to
find the text string "C5" somewhere in that sheet, or do you mean you want
the value of cell C5 from that sheet? Does "use" mean you want to do
arithmetic to it, or print it out, or simply copy it to the other workbook?

It isn't hard to get a VBA program to fetch a value from a cell in one
workbook and paste it to a cell in another workbook. But is your program to
run in data log trending v2.0.xls, or in P123 Datalog trending.xls, or in
some other workbook entirely? And which workbooks must the macro open and
which will already be open?