PDA

View Full Version : stop macro from replacing existing price and UCF cost assigned to a customer to zero



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

grichey
06-03-2008, 11:41 AM
thread.kill

keilah
06-03-2008, 11:45 AM
accentially posted it twice and you cannot delete on this site in case of a mistake....apologies

keilah
06-04-2008, 12:06 AM
I guess no assistance, can someone kindly delete the question

mdmackillop
06-04-2008, 12:18 AM
Patience is a virtue!

There is no attached workbook.

keilah
06-04-2008, 12:37 AM
Ok try this

keilah
06-04-2008, 12:38 AM
Apologies. Mdmackillop

keilah
06-04-2008, 02:28 AM
ok i an guessing it to complex too do...............

mdmackillop
06-04-2008, 05:42 AM
Some of us have a day job!

mdmackillop
06-04-2008, 03:23 PM
It is complex, but by stepping through, can you not identify the code which deletes the data? That would be my approach.