Copying Filtered Data

[coopster]

Hi there: does everyone have the issue or is it me? When i filter data to copy and paste elsewhere, sometimes when i paste i get just the data i have filtered (ideal) and sometimes i get all the data (infuriating)..... any ideas? Thanks for your time.

[royUK]

You can use GoTo from the Edit Menu, click Special & select Visible Cells only

[coopster]

Wahoo - thanks for that RoyUK that's fixed it....

[Shieldsy]

Is there a way to copy the filtered data without having to copy all of the visible cells? i.e. a certain range of data is on the left which i need to copy to a seperate workbook and on the right is conifdential info which mustn't be copied across.
It would be simple to copy everything and delete all cells to the right of a certain point but I was just curious as to if it can be done?

Cheers

[stevekirk]

hi ,
try this, change filter field no and criterial to suit. the range it will copy is from a6 to j6 downwards

chage the range to suit

sub Macro1()
Selection.AutoFilter Field:=1, Criteria1:=paul
    Range("a6:J6", ActiveCell.End(xlDown)).Select
    Selection.Sort Key1:=Range("B6"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    Selection.Copy

end sub

hope this helps
steve

[ChemistB]

If you highlight first only the rows or columns that you are interested in copying and then GOTO Visible Cells Only. You will only copy and paste the cells of interest.

ChemistB