Pete
06-10-2008, 01:24 AM
Hi
Need to stop the data in both Supply and Demand Tables in worksheet "Volumne Summary"....
OK kindly follow the following sequence:
1. Goto worksheet "Volume Summary"
2. Note the highligted name in column B for supply NWS and for demand Other_Market_EU
3. Goto worksheet "Deal Selection" and in column B and I add Shell at the bottom of the current list.
4. Go back to worksheet "Volume Summary" and you will notice that the highighted yellow has moved along shifted down 1 row: Hence, making all the sums in the column F onwards all out of line by one column.....
Need to stop the data in both Supply and Demand Tables in worksheet "Volumne Summary"....
OK kindly follow the following sequence:
1. Goto worksheet "Volume Summary"
2. Note the highligted name in column B for supply NWS and for demand Other_Market_EU
3. Goto worksheet "Deal Selection" and in column B and I add Shell at the bottom of the current list.
4. Go back to worksheet "Volume Summary" and you will notice that the highighted yellow has moved along shifted down 1 row: Hence, making all the sums in the column F onwards all out of line by one column.....