Thread: "indirect" cell ref change....
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ORLANDO VAZQUEZ[_2_] ORLANDO VAZQUEZ[_2_] is offline
external usenet poster
  
Posts: 43
Default "indirect" cell ref change....
Hi,

The last three digits (282) has to change to (283) when I change the
contents of cell L1 to 283 and so on. How can I do this ? I tried
"indirect" but am struggling with sytax.

='[Client Rate Sheet New.xls]PersTot'!$P$282



Reply With QuoteReply With Quote