keilah
06-03-2008, 11:40 AM
See attached workbook..
Please use current workbook as amendments have been made to up date to this verison...
Hi Experts
Firsty, goto worksheet "Iberdrola" and see arrows make a mental note.....
1. Goto Worksheet "Deal Selection" and Row 6 Grey ADD/REMOVE supply buttons
2. Click ADD Select Iberdrola from the radio buttons
3. Select from the check boxes Elba_Island as this is not already been added to the iberdrola worksheet....
4. Select FOB from Second USerform radio button
5. Click ok
6. Go back to Iberdrola worksheet all the origianl prices are gone...........
So need to modifiy the current macro to keep the prices unless otherwise manually amended.
The problem occurs on ADD macro button ONLY row 6 GREY
Please use current workbook as amendments have been made to up date to this verison...
Hi Experts
Firsty, goto worksheet "Iberdrola" and see arrows make a mental note.....
1. Goto Worksheet "Deal Selection" and Row 6 Grey ADD/REMOVE supply buttons
2. Click ADD Select Iberdrola from the radio buttons
3. Select from the check boxes Elba_Island as this is not already been added to the iberdrola worksheet....
4. Select FOB from Second USerform radio button
5. Click ok
6. Go back to Iberdrola worksheet all the origianl prices are gone...........
So need to modifiy the current macro to keep the prices unless otherwise manually amended.
The problem occurs on ADD macro button ONLY row 6 GREY