Copy paste into first cell in column, Skip cells with text.

Hi,

I have tried and not got the result i wanted.

The excel file is straight forward in its explanation, please take a look. I hope someone can help!

Select copy column

paste in new sheet

skip cells with text in (but paste over formula's that equal "")

=TEXT(C1, "dd MMMM YYYY")&"-AM"

Please use this formula to copy data from C1.

________________________________________________________________________________________________________________
Please click * to say thank you

Thanks but a VBA solution is required.

The finishrota already has formula displaying information from yet another sheet. If the formula does not find anything (= "") information from baserota is pasted over cell, if cell has text does not paste over.

thanks

Originally Posted by miles.boyle

Thanks but a VBA solution is required.

The finishrota already has formula displaying information from yet another sheet. If the formula does not find anything (= "") information from baserota is pasted over cell, if cell has text does not paste over.

thanks

We can achieve this using formula

=if(C1="","", Text(C1,"dd MMMM YYYY") & "-AM")





____________________________________________________________________________________________
Please click * to say thank you

Something like the below:

Sub test()


Dim rng As Range
Dim cell As Range


Set rng = Range("c1:c400")


For Each cell In rng


If isempty(cell) Then
cell.Value = cell.Offset(0, 1).Value
End If
Next

but if text is present in 'finishedrota' it would paste the value in the next cell instead of skipping it.