VBA : Copy specific "Entire d column" & paste the values to "k column" and the same activity for all the worksheets in the workbook

[Yogesh Joshi]

Hi everyone

I need a vba which can copy the entire d column data and paste the values to k column and this activity for all the worksheets in the workbook.


Any help will be really GREAT in this regard..!!


Many thanks in advance ..!!

 

[My Aswer Is This]

Try this:

Sub Copy_Column()
'Modified 4/20/2022  6:56:49 AM  EDT
Application.ScreenUpdating = False
Dim i As Long

For i = 1 To Sheets.Count
    Sheets(i).Columns("K").Value = Sheets(i).Columns("D").Value
Next
Application.ScreenUpdating = True
End Sub

 

[Yogesh Joshi]

Try this:

Sub Copy_Column()
'Modified 4/20/2022  6:56:49 AM  EDT
Application.ScreenUpdating = False
Dim i As Long

For i = 1 To Sheets.Count
    Sheets(i).Columns("K").Value = Sheets(i).Columns("D").Value
Next
Application.ScreenUpdating = True
End Sub

Thank you soooo much ...

This works like butter .....

I Really appreciate & thankful that you have given your valuable time to resolve my problem..?

 

[My Aswer Is This]

Thank you soooo much ...

This works like butter .....

I Really appreciate & thankful that you have given your valuable time to resolve my problem..?

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.