macro deleting important data in column F:EC

[Pete]

Hi

See attached workbook......

Not sure why the macro is deleting the source data in columns F:EC for tables with the heading demand only three tables in total....

row 27, 68 and 109 worksheet "Volume Summary"....

when the user click the macro button in the worksheet "Volume Summary" is adjust to accordlingly to the data in worksheet "Deal Selection" columns B and I......

however the macro is also deleting the data in tables for demand customers only starting in row 27, 68 and 109

how do i amend to stop this happening....

[Pete]

work book

[mdmackillop]

Hi Pete,
You need to step through your code and watch what is happening. You may need to add some Activate and Select code to move to affected ranges. That should let you pin down the code section involved.