Excel Cell Value Problem

[eithne]

Thanks for this but the reports run automatically and there are a coupl
of hundred of them. I can't go =sheet1!F45 in sheet 2 as the name o
sheet1 will be different for every report.

I thought there might be a way to set the value in sheet 1 for sheet
e.g set sheet2!G56 = F45 and put this function in sheet 1

 

[Govind]

How do the reports get generated ? If you are using a macro , then build
this equation also as a part of the macro

Regards

Govind.