I've loaded a sample to help me explain:

The master sheet contains a number of values that may be updated by
either the update or refresh sheets as this information is available.

When applying the update sheet the following needs to occur:

When the sheet, Update Exchange value matches the master Exchange value
the corresponding Capacity value needs to be reflected within the
master,. An example is the Master capacity value for ABCF7 "after
update is applied".

Additionally, the following events are needed when applying the Refresh
sheet to the Master::

When an exchange on the Refresh sheet matches the Master exchange, the
Refresh Upgrade value is applied to the Master Projected value for the
corresponding exchange.

This would be subsequently added to capacity within the projected date
column as per ABCF7 & ABCDA1 examples.

Please let me know if I can explain this better, any help greatly
appreciated.


+-------------------------------------------------------------------+
|Filename: Master.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4591 |
+-------------------------------------------------------------------+

--
ozibryan
------------------------------------------------------------------------
ozibryan's Profile: http://www.excelforum.com/member.php...o&userid=33222
View this thread: http://www.excelforum.com/showthread...hreadid=530424