I have a workbook that pulls data from another workbook. The workbook
that houses the data has a worksheet for each day of the month: 1,2,3,4
etc..

I need the workbook that pulls the data to take it from the worksheet
that corresponds to the date in a specific cell.

Here's my formula so far:

=INDEX('[July 06.xls]11'!$A$34:$D$58,MATCH(LARGE('[July
06.xls]11'!$D$34:$D$58,1),'[July 06.xls]11'!$D$34:$D$58,0),1

As you can see, it is pulling the date from workbook July 06; worksheet
11. I need it to pull from worksheet 11 if the date in B5 is
07/11/2006; worksheet 10 if the date is 07/10/2006..etc.

Thanks in advance.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=560547