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/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"singlgl1" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> singlgl1
> ------------------------------------------------------------------------
> singlgl1's Profile:
> http://www.excelforum.com/member.php...o&userid=26389
> View this thread: http://www.excelforum.com/showthread...hreadid=479533
>

[singlgl1]

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

[Anne Troy]

That'd be correct. Sorry.
Have you seen this post at ****'s?
http://www.*****-blog.com/archives/2...sed-workbooks/
************
Anne Troy
www.OfficeArticles.com

"singlgl1" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks Anne for the suggestion .Unfortunately, the workbook that I'll be
> referencing will not always be open , therefore I'm not sure if the
> indirect function would work for me.
>
>
> --
> singlgl1
> ------------------------------------------------------------------------
> singlgl1's Profile:
> http://www.excelforum.com/member.php...o&userid=26389
> View this thread: http://www.excelforum.com/showthread...hreadid=479533
>