Dear Friends,
I have data in excel sheet named LSR from A2:L3000 sample as below. i want to have a VBA code to change the data as below. please can i have help on this
Data before changing
FK PLATE NO Vehicle
23 1234DB toyota
23 98544DB ford
34 34322SW hyundai
21 34344TR nissan
451 43434FR toyota
39 43423TY nissan
39 34445FE ford
39 43455ER nissan
39 343444E landrover
189 44455E nissan
After running VBA code
FK PLATE NO Vehicle FK PLATE NO Vehicle FK PLATE NO Vehicle
23 1234DB toyota 23 98544DB ford
34 34322SW hyundai
21 34344TR nissan
451 43434FR toyota
39 43423TY nissan 39 34445FE ford 39 43455ER nissan 39 343444E landrover
189 44455E nissan
Thanks
Abdul
I have data in excel sheet named LSR from A2:L3000 sample as below. i want to have a VBA code to change the data as below. please can i have help on this
Data before changing
FK PLATE NO Vehicle
23 1234DB toyota
23 98544DB ford
34 34322SW hyundai
21 34344TR nissan
451 43434FR toyota
39 43423TY nissan
39 34445FE ford
39 43455ER nissan
39 343444E landrover
189 44455E nissan
After running VBA code
FK PLATE NO Vehicle FK PLATE NO Vehicle FK PLATE NO Vehicle
23 1234DB toyota 23 98544DB ford
34 34322SW hyundai
21 34344TR nissan
451 43434FR toyota
39 43423TY nissan 39 34445FE ford 39 43455ER nissan 39 343444E landrover
189 44455E nissan
Thanks
Abdul