Hi try this

Range("A1") = Range("B1")
Range("A2") = Range("C2")
Range("A3") = Range("D3")
Range("A4") = Range("D4")
--
Howard31


"AlanW" wrote:

I have a table with the data in Cell B1, C2, D3 & D4, how can I move all
these data to Cell A1:A4. Could anyone please help.

Many Thanks