RB: thanks again for your effort in helping me out. The format would
be:

'c:\new project\[school 1.xls]school summary'!$B$6

The WB is "School 1" (there will be many of these, called school 1,
school 2, school 3 etc); the WS is "school summary" (this will exist in
every workbook); and the top cell of the column of numbers to be summed
is B6. I am trying to get the master summary (for school districts) of
all of the individual "school summary" pages. If we can get this to
work than I would copy/paste the rest of the column.


--
AlZee
------------------------------------------------------------------------
AlZee's Profile: http://www.excelforum.com/member.php...o&userid=15906
View this thread: http://www.excelforum.com/showthread...hreadid=273888