copy cell info to another group of cells

I have been trying to get this portion of a job going.
I have a column A A1 = date - 10/10/2012 -- channel info
A2 = Slot Name
A3 - A?
A? + 1 = Slot Name

I have trying to find Slot Name select the cell above which in this case be A1, format that string to a substring of 10/10/2012 then take the value and paste it between the Slot Name.

I have attached the file.
I know I am missing something within the for Next statement.
The number of empty cells between is random along with the number of Slot Name.

Thanks
Dale
New to forum.

Please Login or Register  to view this content.

Thanks Mike that worked great.
Dale