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" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> 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" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> 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