Thread: Auto Update Formula Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
  
Posts: 65
Default Auto Update Formula Rows
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

Reply With QuoteReply With Quote