OK Thanks it Works, but one problem, due to the fact that "'!$F$1" is text it
does not change when I copy the formula even if I take the absolute values
off.

This because I want to copy the formula to another Cell C4 and want it to
update to the value in Cell B1



"Tom Ogilvy" wrote:

Cell B4 =C5+Indirect("'[Actual Sales Report.xls]" & A1 &"'!$F$1")

Better?

--
Regards,
Tom Ogilvy

"MESTRELLA29" wrote in message
...
Are you missing a Parentesis ???

Because it is not working

"Tom Ogilvy" wrote:

Possibly:
Cell B4 =C5+Indirect("'[Actual Sales Report.xls]" & A1 &"'!$F$1"

--
Regards,
Tom Ogilvy



"MESTRELLA29" wrote in message
...
Is it possible to do the following if So how.

Cell A1 = Feb
Cell B1 = Mar

Cell B4 =C5+'[Actual Sales Report.xls]Feb'!$F$1
Cell Ref A1

This because I want to copy the formula to another Cell C4 and want it
to
update to the value in Cell B1

A1 isn't a string and it updates fine for me. What does updating to B1 have
to do with the $F$1 reference being a string.

copying to C4 would produce

Cell C4 =C5+Indirect("'[Actual Sales Report.xls]" & B1 &"'!$F$1")

--
Regards,
Tom Ogilvy

"MESTRELLA29" wrote in message
...
OK Thanks it Works, but one problem, due to the fact that "'!$F$1" is text
it
does not change when I copy the formula even if I take the absolute values
off.

This because I want to copy the formula to another Cell C4 and want it to
update to the value in Cell B1



"Tom Ogilvy" wrote:

Cell B4 =C5+Indirect("'[Actual Sales Report.xls]" & A1 &"'!$F$1")

Better?

--
Regards,
Tom Ogilvy

"MESTRELLA29" wrote in message
...
Are you missing a Parentesis ???

Because it is not working

"Tom Ogilvy" wrote:

Possibly:
Cell B4 =C5+Indirect("'[Actual Sales Report.xls]" & A1 &"'!$F$1"

--
Regards,
Tom Ogilvy



"MESTRELLA29" wrote in
message
...
Is it possible to do the following if So how.

Cell A1 = Feb
Cell B1 = Mar

Cell B4 =C5+'[Actual Sales Report.xls]Feb'!$F$1
Cell Ref A1

This because I want to copy the formula to another Cell C4 and
want it
to
update to the value in Cell B1