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
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

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,089,239
Messages
5,407,080
Members
403,123
Latest member
excelmyheadache

This Week's Hot Topics

Top