Macro for copying filtered slicers data

Learn_VBA

New Member
Joined
Oct 9, 2017
Messages
25
I had filters on a Excel sheet and had a macro which would copy across only the filtered data to another workbook.

I recently introduced slicers to the data, however the macro now copies across all the data and not just the filtered data from the slicers.
Anyone know how I an over come this?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
3,944
An example:

Code:
Sub Act_Sheet_to_other_sheet()
Dim r As Range, dest As Worksheet, i%
Set dest = Sheets("sheet2")                                 ' destination sheet
Set r = ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisible)
For i = 1 To r.Areas.Count
    r.Areas(i).Copy
    dest.Cells(dest.Range("a" & Rows.Count).End(xlUp).Row + 1, 1).PasteSpecial _
    xlPasteValues, xlNone, False, False
Next
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,096,287
Messages
5,449,461
Members
405,566
Latest member
JeIIyfish

This Week's Hot Topics

Top