Formula that referance a Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use this in B4 then copy across

=C5+INDIRECT("'[Actual Sales Report.xls]"&A1&"'!F1")

note I don't know if you want C5 to change to D5, if not use absolute
references
Also note that it won't work if you close the [Actual Sales Report.xls]
workbook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula that referance a Cell 5
adding cells upto and including a specified cell 6
Find the position of a date 6
Skip Reference Sequences during copy 3
Want formula to turn to value by itself 2
change change cell reference to Absolute reference 5
Lookup a particular cell in another excel workbook 1
Conditional Averages with Multiple Columns 3

Back
Top