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