VBA: Copy All Data Including Filtered Cells From Table

[egarcia7]

Hello All,

I'm copying information from a table on the server and pasting the data onto another workbook. The problem is the table is always being filtered so when the macro runs it pastes the visible data only and not the entire table.

Any help would be appreciated, thank you in advance,

-E

Sub Aggergate_to_Master()


Workbooks.Open Filename:= _
        "\\serverlink\Back_Up_Test_Files\Brian_CIP.xlsx"
        Range("Brian").Select
            Range("A11").Activate
                Selection.Copy
            Windows("Andy_Dashboard_CIP.xlsm").Activate
                Sheets("Brian").Select
                    Range("a2").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Windows("Brian_CIP.xlsx").Activate
       Range("A11").Select
         Application.DisplayAlerts = False
           ActiveWindow.Close

End Sub

 

[egarcia7]

Hello All,

Does anyone know the VBA code to copy the whole table andwhen I paste it, all data regardless of hidden or filtered fields will bepasted?

Thanks again,

-E