Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 2nd 06, 06:17 AM posted to microsoft.public.excel.misc
Vellarian
 
Posts: n/a
Default How do I update data in 3 related files in Excel?

I have file A which content of Price List. All the items in the File A is
calculated in other Calculation files which named according to the names of
the items (ex.File B), so there are lots of files B. Every File B is a
calculation of materials which related to File C which consist of the
Material Price list.
Usually the sequence is : When I made changes in File C, then I have to open
each of file B so the calculation can be automatically updated. And then I
opened File A so excel can update the price list.
It seems that excel will only automatically update data if we open the file.
What I want to do now is : When I change any material price in File C, then
I wish excel will automatically update the value in File A, without having to
open each of File B, because there are hundreds of File B.
How to do that? Thank you very much.


Reply
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
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Linking the data from one excel to another mrbalaje Excel Discussion (Misc queries) 2 June 13th 05 10:44 AM
Update Excel Data List for Drop Down use LynnS Excel Discussion (Misc queries) 2 June 10th 05 11:35 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Excel Files Acting Weird Anat Excel Discussion (Misc queries) 0 March 29th 05 03:07 AM


All times are GMT +1. The time now is 12:04 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017