| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formula that referance a Cell
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 |
|
#2
|
|||
|
|||
|
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 -- Regards, Peo Sjoblom "MESTRELLA29" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| looking for a formula | Excel Worksheet Functions | |||
| Cell referance for formula | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
