If desired, send your file S to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Curtis" wrote in message
...
Not working for me but it is likely me

Yes all sheets are identically structured

Row 7 (columns D:AI) contain the identifiers for the divisions
Col A (rows 3:277) contain the G/L #
Range (D3:AI277) contain the costing data

Also does the source sheet need to be open all the time or just to update
the file?

thanks Max

"Max" wrote:

Assume that the source book is Book2.xls, and this book is open at the
same
time (this is a requirement for INDIRECT to work)

Then in D7 in the summary sheet in your other book,
you could use this instead:
=IF($C$3="","",OFFSET(INDIRECT("'[Book2]"&$C$3&"'!D7"),ROWS($1:1)-1,COLUMNS($A:A)-1))
Copy D7 across/down as far as required. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Curtis" wrote:
Where do I make reference in the formula to the source workbook say
YTDTB (
note: the summary sheet resides in a different workbook than the source
data)