see attached workbook.
Hi Experts
Need to find a solution, having a slight problem when the user follows the following sequence:
1. Goto Main worksheet "Deal Selection"
2. Grey Add Supplier macro button row 4 column B
3. Click and say Shell as a new supply customer.....follow sequence and complete
4. Click Up date Validation Table macro button same worksheet "Deal Selection"
5. Goto wroksheet "Allocation (Vol)" and scroll down to row 150 and for the new supply customer "Shell" add for row 160 and 161 i.e. Dubai and PetroChina random supply volume number in columns F:I andy single digit numbers will do.
6. Repeat the procees for both worksheet(s) Pricing Supply and Demand i.e. enter for clients Dubai and PetroChina any prices single or double digit numbers....
NOW
7. Goto back to main worksheet "Deal Selection" and Click Blue ADD macro button and create a supply worksheet for the newly add supply customer shell (radio button) and then select chkbox both Dubai and PetroChina. Complete to create worksheet (green = supply)
8. Same worksheet "Deal Selection" goto row 6 column I and creat a demand worksheet click BLue ADD macro button....
9. This time firstly select Dubai then Shell complete step(s) and repeat process for PetroChina for Shell.....(create demand worksheet - red = demand)
10. Goto worksheet "Allocaton (Vol)" and row 2 column B click the Paste macro button
11. Goto worksheet "Modelling (Vol)" and row 2 column B click macro button update data fields....
12. goto back the green shell and two red demand worksheet(s) to see if the volume and prices data has filtered through.
13. Goto worksheet "CashFlow Q4" and row 172/173 and YOU WILL SEE NO INFORMATIN refelected here as to the casflows...........
This only happens when the user adds a new supply customer to the workbook...........
I will be happy to answer any question that you might have...............
Start Free Trial
