Thread: Help with indirect
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Help with indirect
My interp was
In A722, OP wanted it as: ='Road Cash Accounting'!A114
In A754, as: ='Road Cash Accounting'!A217
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Bernie Deitrick" wrote:
Stew,

Don't use INDIRECT.

In A690, use

='Road Cash Accounting'!A11

and copy that to A722. Excel will update the formula to

='Road Cash Accounting'!A43

etc.

Reply With QuoteReply With Quote