Hi!

Can anybody help me with a macro that checks all empty cells in a column and copies the data from the column beside?
I'll show you an example

A B
1 MYPKG IDJKT
2 ZADUR
3 KRPUS KRICH
4 CNSHA
5 HKHKG


So, I want a macro that checks all empty cells in column A, i.e., A2, A4 and A5, and then copy the data from column B.
In this sense, A2 would have the same as B2.
A4 would have the same as B4
A5 would have the same as B5
and so on, and so on...

Thanks beforehand.

Gustavo.