VBA to Copy Rows but not the header

[Tom90]

I am looking for VBA code to add to my existing code, I have everything working ok but after I have filtered the data that I need when I copy it to my master sheet it copies the header as well so I have three sheet to copy and I end up with three header rows in my master, I am looking for code to not copy the header,
This is the code below that copy the column and it it just repeats itself but changes the name for Windows and Activate Sheets,
Any help would be appreciated. Thanks TOM90

Windows("ABC Data.csv").Activate
Sheets("ABC Data").Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Columns("K:K").Select
Selection.Copy
Windows("CDE Master.xlsm").Activate
Sheets("Drop").Select
Range("D2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

 

[pecoflyer]

Perhaps like this http://www.mrexcel.com/archive/Data/10541.html

 

[Tom90]

Hi pecoflyer, that works ok but I am finding it hard to make it work for just one column at a time the code works by moving all the columns any idea how to code it for just ("K:K")
this is the code,
ActiveSheet.UsedRange.Offset(1, 0).SpecialCells _
(xlCellTypeVisible).Copy