Move data in two columns

[YasserKhalil]

Hello everybody
In my attachment I have to type marks and dates in just column B and C
I need a worksheet_change if I typed a new mark and a new date to move data like that :

Column B Column C Column D Cloumn E Cloumn F Cloumn G Cloumn H Cloumn I Cloumn J Cloumn K
85 09/12/2014 80 08/12/2014 70 20/08/2014 75 01/05/2014 60 01/01/2014

If I put new data in column B & C (for example : 88 13/12/2014)
the desired result should be like that:

Column B Column C Column D Cloumn E Cloumn F Cloumn G Cloumn H Cloumn I Cloumn J Cloumn K
88 13/12/2014 85 09/12/2014 80 08/12/2014 70 20/08/2014 75 01/05/2014

Simply to clear the mark and the date in columns J & K and to transit data to its suitable place
Hope it is clear

[YasserKhalil]

Any idea about how to start

[YasserKhalil]

Can I store data in column B and Column C to get it after typing new data over them?

[YasserKhalil]

Thanks everybody I have devised this code

Please Login or Register  to view this content.

And it worked