Macro to `populate empty cells in a region

[Malooga]

I'm using Excel 2003, and have data that looks something like this:

Please Login or Register  to view this content.

There can be many more rows. What I'd like to do is build a macro that will
go through a selected region - to include an area such as this - and populate the empty cells in columns D, E and F with the appropriate columns in A, B and C.
So, an empty cell in CorrectLast would mean that Correctlast would receive LastName from the same row, CorrectFirst woudl receive FirstName from that row and CorrectMiddle would receive Middle from that row. In this example, D3 would hold "Agell", E3 would hold "Robert" and F3 would hold "L"

If somebody could point me in th right direction, I'd be very grateful.
Thank you for your help.

[Marcol]

I don't see the point of this.

You seem to be asking effectively, to make
Column D = Column A
Column E = Column B
Column F = Column C

What am I missing?