HI all
I have the following code
1. How can i simplify it . (it is basically merging data from columns, im repeating the same code for different column ranges)
2. For range O6:O355 & Q6:Q355 i would like the following format mmm-yy
Sub site_assumptions_calcul_P9_p501_valued()
With Range("M6:M355")
.Formula = "=IF(B6<>"""",B6,INDEX(H$6:H$355,ROWS(M$6:M6)-COUNTA(B$6:B$355)))&"""""
' .Value = .Value
.Copy
.PasteSpecial xlPasteValues
End With
With Range("N6:N355")
.Formula = "=IF(C6<>"""",C6,INDEX(I$6:I$355,ROWS(N$6:N6)-COUNTA(C$6:C$355)))&"""""
' .Value = .Value
.Copy
.PasteSpecial xlPasteValues
End With
With Range("O6:O355")
.Formula = "=IF(D6<>"""",D6,INDEX(J$6:J$355,ROWS(O$6:O6)-COUNTA(D$6:D$355)))&"""""
' .Value = .Value
.Copy
.PasteSpecial xlPasteValues
End With
With Range("P6:P355")
.Formula = "=IF(E6<>"""",E6,INDEX(K$6:K$355,ROWS(P$6:P6)-COUNTA(E$6:E$355)))&"""""
' .Value = .Value
.Copy
.PasteSpecial xlPasteValues
End With
With Range("Q6:Q355")
.Formula = "=IF(F6<>"""",F6,INDEX(L$6:L$355,ROWS(Q$6:Q6)-COUNTA(F$6:F$355)))&"""""
' .Value = .Value
.Copy
.PasteSpecial xlPasteValues
End With
many thanks!!!
Antonio
Bookmarks