Copy Column from one worksheet to another

[hemants]

Morning All,

need help developing a VBA that will copy a column from a DataDump to a next work sheet

trying to make so it does it in the background without having to keep flipping back and forth between worksheets

attached is a sample of the data

Sheet 1
This is where the sorted date will be stored

Sheet 2
lite version of the datadump from my client db and this is where I would like to grab the info from

[stnkynts]

need help developing a VBA that will copy a column from a DataDump to a next work sheet

Which column in sheet 2 do you want to copy?
Where does it need to go in sheet 1?

[hemants]

The headings in Sheet1 match the dump in Sheet2
copy the matching column from Sheet2 to Sheet1

[stnkynts]

Sorry for the delay.

Let me know if this works

Sub CopyDataDump()

Sheets("Sheet1").Range("A:A").EntireColumn.Value = Sheets("Sheet2").Range("P:P").EntireColumn.Value
Sheets("Sheet1").Range("C:C").EntireColumn.Value = Sheets("Sheet2").Range("M:M").EntireColumn.Value
Sheets("Sheet1").Range("D:D").EntireColumn.Value = Sheets("Sheet2").Range("B:B").EntireColumn.Value

End Sub

[hemants]

Thx, that works perfectly