I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?

"DA_Potts" wrote:

I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?

Sorry... I forgot to mention I am using Excel 2003.

See your other post

--
Biff
Microsoft Excel MVP


"DA_Potts" wrote in message
...
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents
a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?

I have no idea what you mean by this response....
"T. Valko" wrote:

See your other post

--
Biff
Microsoft Excel MVP


"DA_Potts" wrote in message
...
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents
a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?

What he means is that you asked broadly the same question in another group,
and his answer is there. Ths sort of confusion (and particularly when you
omit some of the detail in one version of the message) is why multi-posting
is a breach of netiquette. Next time, choose one group and stick to it.
--
David Biddulph

"DA_Potts" wrote in message
...

I have no idea what you mean by this response....
"T. Valko" wrote:

See your other post

--
Biff
Microsoft Excel MVP


"DA_Potts" wrote in message
...
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3"
represents
a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls,
(where
E3=3), sheet 1, and cell E22.

Any ideas?