View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default "indirect" cell ref change....


=INDIRECT("[MENU.xls]Sheet4!$A$"&F17&"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ORLANDO VAZQUEZ" wrote in
message ...
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