Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
I have a report that summarizes activity from another worksheet. I want to
be able to update/change the formula if the date of the report changes. As an example: " =SUM(U:\Drew\[INVWKSH09.xls]1996'!$B$409:$B$411)" and I want the formula to change so that whne the date of the report changes, the formula would change to $B$411:$B$413 Thank for the help. -- Allan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
Hi,
Do you always want it to increase by 2 rows? Where is the date changing? So for example today is monday and when you open the file tomorrow you want it to be two cells futher down. What about if its friday and you don't open the file till tuesday? do you want it to increment by 2 cells or 8 or what? You are really not giving us enough info. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Flipper" wrote: I have a report that summarizes activity from another worksheet. I want to be able to update/change the formula if the date of the report changes. As an example: " =SUM(U:\Drew\[INVWKSH09.xls]1996'!$B$409:$B$411)" and I want the formula to change so that whne the date of the report changes, the formula would change to $B$411:$B$413 Thank for the help. -- Allan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |