Auto Update Formula Rows

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "FIRSTROUNDKO via OfficeKB.com" <u15639@uwe>
Date: Thu, 28 Jun 2007 14:07:34 GMT

Hi

Range A1 has the formula ='[apples.xls]Adjustment'!$H$44/1000

but evereyday i want to update the formula by the next H Cell

i.e tommorow I want the formula to read

='[apples.xls]Adjustment'!$H
$45/1000

and the next day

='[apples.xls]Adjustment'!$H
$46/1000

Thanks in advance

--
Message posted via http://www.officekb.com

.

Follow-Ups:
- Re: Auto Update Formula Rows
  - From: Trevor Shuttleworth

Prev by Date: Re: Excel Convert Multiple Rows into Multiple Columns
Next by Date: Re: What is default property of name object
Previous by thread: Automatically Turn on Normal text to hyperlink
Next by thread: Re: Auto Update Formula Rows
Index(es):
- Date
- Thread