Thread: Workbook Links
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cparaske
 
Posts: n/a
Default Workbook Links


pavlai,

Short of actually seeing your report, I can only suggest you create
links into the source workbook. You can use the EditLinks function to
point the workbook to the new source rather easily. EditReplace could
take care of the reference problem (assuming, for example, that the new
data is in Column D as opposed to Column C in the new month).

Could you post a small sample of the differences you are seeing between
reports? There might be a better solution.

HTH,
cparaske


--
cparaske
------------------------------------------------------------------------
cparaske's Profile: http://www.excelforum.com/member.php...fo&userid=3793
View this thread: http://www.excelforum.com/showthread...hreadid=522193