Another linking question

[singlgl1]

I have a Worksheet called “DailyReport” with a number entered in cell
A1, such as 23rd, 24th,25th,etc
I’d like to have it auto enter a number in Cell A2 that comes
From a file called “ProdReports”, and from sheet “23rd” cell A10, or
“24th” cell A10,etc,depending on what sheet number is typed into cell
A1, of the worksheet ”DailyReport”
Thanks, Greg

 

[Anne Troy]

Sounds like a job for Indirect, Greg. See this:
http://www.officearticles.com/excel/indirect_to_switch_worksheets_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[singlgl1]

Thanks Anne for the suggestion .Unfortunately, the workbook that I'll b
referencing will not always be open , therefore I'm not sure if th
indirect function would work for me

 

[Anne Troy]

That'd be correct. Sorry.
Have you seen this post at Dick's?
http://www.dicks-blog.com/archives/2004/12/01/indirect-and-closed-workbooks/
************
Anne Troy
www.OfficeArticles.com