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 |
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 |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com