Hello

I am adding cells from different workbooks that are on a network drive
and thier location cannot be changed. This formula is too long part of
the location never changes how would i shorten this:

='S:\Corporate Services\Financial Services\Revenue\Accounts
Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and
Activity Monitoring\Stephan\[Stephan''s Enforcement
Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
Revenue, Cost and Activity Monitoring\Mike\[Mike''s Enforcement
Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
Revenue, Cost and Activity Monitoring\Frank\[Frank''s Enforcement
Stats.xls]Enforcement Stats 2005'!F15+'S:\Corporate Services\Financial
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
Revenue, Cost and Activity Monitoring\Carole\[Carole''s Enforcement
Stats.xls]Enforcement Stats 2005'!F15 'S:\Corporate Services\Financial
Services\Revenue\Accounts Receivable\POA Collections Unit\Enforcement\6
Revenue, Cost and Activity Monitoring\Angie\[Angie''s Enforcement
Stats.xls]En

The constant is
'S:\Corporate Services\Financial Services\Revenue\Accounts
Receivable\POA Collections Unit\Enforcement\6 Revenue, Cost and
Activity Monitoring\

Thanks,
Mike


--
blacktour
------------------------------------------------------------------------
blacktour's Profile: http://www.excelforum.com/member.php...o&userid=25368
View this thread: http://www.excelforum.com/showthread...hreadid=398611