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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

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,692
Messages
5,409,839
Members
403,280
Latest member
sepanikm

This Week's Hot Topics

Top