I have a workbook with 66 sheets. Each sheet represents a different day and
is named ie. 12-7-08, 12-8-08, etc. I am trying to chart one cell (f40) from
each sheet into one chart to track the change of an account balance day to
day. I have reviewed the similar questions in this forum and have tried each
suggestion to no avail. Is it because the sheets are named with dates? Can
anyone help me not have to enter ='12-7-08 '!F40, etc, etc....66 times?
Thank you in advance.

Hi,

On the sheet where you want the chart enter the dates in the first column

12-7-08
12-7-09
....

Suppose these are in A1:A66, and suppose the entries you want are in F40 on
each sheet, then enter

=INDIRECT("'"&TEXT(A1,"m-d-yy")&"'!F40")

In B1 and copy it down. Be very careful toi include the ' (two single
quotes - one after the (" and one before the !F40)
Use this range to plot your chart.


If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"erriac" <(E-Mail Removed)> wrote in message
news:F197E385-C148-43D1-A817-(E-Mail Removed)...
> I have a workbook with 66 sheets. Each sheet represents a different day
> and
> is named ie. 12-7-08, 12-8-08, etc. I am trying to chart one cell (f40)
> from
> each sheet into one chart to track the change of an account balance day to
> day. I have reviewed the similar questions in this forum and have tried
> each
> suggestion to no avail. Is it because the sheets are named with dates?
> Can
> anyone help me not have to enter ='12-7-08 '!F40, etc, etc....66 times?
> Thank you in advance.

That worked great. Thank you very much for your help.

"Shane Devenshire" wrote:

> Hi,
>
> On the sheet where you want the chart enter the dates in the first column
>
> 12-7-08
> 12-7-09
> ....
>
> Suppose these are in A1:A66, and suppose the entries you want are in F40 on
> each sheet, then enter
>
> =INDIRECT("'"&TEXT(A1,"m-d-yy")&"'!F40")
>
> In B1 and copy it down. Be very careful toi include the ' (two single
> quotes - one after the (" and one before the !F40)
> Use this range to plot your chart.
>
>
> If this helps, please click the Yes button.
>
> Cheers,
> Shane Devenshire
>
> "erriac" <(E-Mail Removed)> wrote in message
> news:F197E385-C148-43D1-A817-(E-Mail Removed)...
> > I have a workbook with 66 sheets. Each sheet represents a different day
> > and
> > is named ie. 12-7-08, 12-8-08, etc. I am trying to chart one cell (f40)
> > from
> > each sheet into one chart to track the change of an account balance day to
> > day. I have reviewed the similar questions in this forum and have tried
> > each
> > suggestion to no avail. Is it because the sheets are named with dates?
> > Can
> > anyone help me not have to enter ='12-7-08 '!F40, etc, etc....66 times?
> > Thank you in advance.
>
>