VBA to Copy Column to next Empty column

[Vijayarc]

Hi Team
i have excel 3 freeze column A B C, were B only column we update daily basis,
B column has fixed row B2: B41
i will copy B column data on daily basis to next new column on date wise
i want VBA button to copy B2:B41 to new empty column with today date header

and also B column value should add to C column value

 

[Marc L]

Hi !

As a very beginner starter :​

Sub Demo1()
    C = ActiveSheet.UsedRange.Columns.Count + 1
    Cells(C).Value = Format(Date, "d mmm")
    Cells(2, C).Resize(40).Value = [B2:B41].Value
    [C2:C41].Value = [B2:B41+C2:C41]
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[Vijayarc]

thank you so much Marc L , you are genius buddy......