LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with links to another workbook Kev G Excel Worksheet Functions 3 February 14th 06 03:08 PM
workbook links to .xla file on the network compound Excel Discussion (Misc queries) 0 July 6th 05 07:27 PM
find links to another workbook Patricia Excel Discussion (Misc queries) 1 January 21st 05 09:33 PM
Links w/in same workbook not working JenR Excel Discussion (Misc queries) 3 January 20th 05 11:54 PM
#VALUE ! errorr for links to other workbook Janez Banez Excel Worksheet Functions 2 January 15th 05 10:58 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"