Artem Kunytsia: thanks, i have tried .. but unfortunately, its working for me only partially. as its not working in case where i want to copy multiple cells from lookup column. i was able to copy only 1 lookup cell into multiple cells in the empty column, but not multiple lookup cells into the same amount of multiple cells in the empty column. however this multiple cells copy / paste if working fine for columns where copy column doest have lookup values. so it this could be fixed it would help a lot as its crucial feature in my case. thanks a lot for looking into it