VBA: Copy All Data Including Filtered Cells From Table

egarcia7

New Member
Joined
Aug 9, 2016
Messages
17
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

Code:
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

New Member
Joined
Aug 9, 2016
Messages
17
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
 
Last edited:

Forum statistics

Threads
1,077,955
Messages
5,337,391
Members
399,144
Latest member
Lauren Ward

Some videos you may like

This Week's Hot Topics

Top