Hi Friends,

Following is the code which i sorted out with the help of this forum earlier,
This code will copy data from range A to N continuously from Sheet1 and
paste in to Sheet2 along with filter criterias(see code)


Dim Source As Worksheet
Dim dest As Worksheet
Set dest = Worksheets("FTA Metrics")
dest.Range("A2", dest.Range("A" & Rows.Count).End(xlUp).Offset(1, 0)).Resize(columnsize:=11).ClearContents
    Set Source = Worksheets("Master Sheet")
    Source.Range("A:A", "H:H").AutoFilter 8, "<FIRST TIME ACCEPTED>"
    Source.Range("A2", Source.Range("N" & Rows.Count).End(xlUp)).SpecialCells(xlCellTypeVisible).Copy dest.Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    Source.AutoFilterMode = False
All I need is instead of continous selection of range from A to N I want specific ranges such as A,B,D,F & H only to be copied and pasted in sheet2.I dont want rest of the ranges to be copied and pasted in sheet2

Hope my explanation is clear.

Please provide me a solution.