I am looking for a way to automate updating an existing formula within a selected range. This is my situation:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
I currently have 12 adjacent cells selected. The formula in the first cell selected reads =ROUND((Jan!AK16),0). The formulas in the remaining 11 cells making up the range may have a different column reference. I only want to update the row reference portion.<o
></o
>
In this example I need to take the number 16 and replace it with 13. Ultimately what I want automated is whatever is showing as 16 (17, 18, 19, 20, etc.), replace that value less 3. How can this be programmed?<o
></o
>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




I currently have 12 adjacent cells selected. The formula in the first cell selected reads =ROUND((Jan!AK16),0). The formulas in the remaining 11 cells making up the range may have a different column reference. I only want to update the row reference portion.<o


In this example I need to take the number 16 and replace it with 13. Ultimately what I want automated is whatever is showing as 16 (17, 18, 19, 20, etc.), replace that value less 3. How can this be programmed?<o

