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