Thread
:
"indirect" cell ref change....
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
"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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett