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

Hi!

Using a formula to do this requires the Indirect function and the Indirect
function requires the other file to be open. If the other file is not open
you will get errors. Still interested?

Biff

"edwardpestian"
wrote in message
news:edwardpestian.2atenx_1152678312.6027@excelfor um-nospam.com...

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

More often than not, the workbook containing the data would not be
open.

Thanks anyway Biff.

ep


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

There's another option available but I have never tried it. It's a VBA coded
routine by Harlan Grove. The utility name is PULL. I don't have any handy
links for this but I'm sure a Google search will find many hits.

Biff

"edwardpestian"
wrote in message
news:edwardpestian.2atj21_1152684004.8836@excelfor um-nospam.com...

More often than not, the workbook containing the data would not be
open.

Thanks anyway Biff.

ep


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

I will check it out Biff. I'll let you know how it goes.

Thanks.


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