Formula that referance a Cell

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

Are you missing a Parentesis ???

Because it is not working

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

--
Regards,
Tom Ogilvy

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

 

[Tom Ogilvy]

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

Better?

--
Regards,
Tom Ogilvy

Are you missing a Parentesis ???

Because it is not working

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

--
Regards,
Tom Ogilvy

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

 

[Guest]

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

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

Better?

--
Regards,
Tom Ogilvy

Are you missing a Parentesis ???

Because it is not working

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

--
Regards,
Tom Ogilvy



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

 

[Tom Ogilvy]

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

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

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

Better?

--
Regards,
Tom Ogilvy

Are you missing a Parentesis ???

Because it is not working

:

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

--
Regards,
Tom Ogilvy



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