Pete
07-18-2008, 02:24 AM
Hi
My data in worksheet "Volume Summary" keeping on shiftinig down when a new supply customer is add to worksheet "Deal Selection", if you follow the following routine you well undertsdand...........
and also if just click the update data field macro button on it own it deletes the data in column F and shifts it upwards
when you add say shell to worksheet "Deal Selection" and click the macro button in work Sheet "Volume Summary" and then re delete and re click the update macro button in Volume Summary and you'll see..........
this happen to all the table with heading supply in them ONLY...
what the macro should do is only remove the enteries that are not matching with worksheet "Deal Selection" column b ...
and not shift the data around that should remain fixed to that particular client...
SEE NEW WORKBOOK
My data in worksheet "Volume Summary" keeping on shiftinig down when a new supply customer is add to worksheet "Deal Selection", if you follow the following routine you well undertsdand...........
and also if just click the update data field macro button on it own it deletes the data in column F and shifts it upwards
when you add say shell to worksheet "Deal Selection" and click the macro button in work Sheet "Volume Summary" and then re delete and re click the update macro button in Volume Summary and you'll see..........
this happen to all the table with heading supply in them ONLY...
what the macro should do is only remove the enteries that are not matching with worksheet "Deal Selection" column b ...
and not shift the data around that should remain fixed to that particular client...
SEE NEW WORKBOOK