Macro to consolidate all into one workbook

kaffal

Board Regular
Joined
Mar 7, 2009
Messages
68
Hi all, I need some help in consolidating all the workbooks into one.
Everyday I recieve one file, showing all the trades.

I wish to consolidate all the workbooks into one Summary Workbook.
So that I can continue to do some reporting.

The daily files stores in a folder C:\trades\Mar\
The Summary WorkBook is in C:\trades\Report\

As the daily files classify the trades into different tab for different products, I wish to copy the detail over to the summary workbook under the correct worksheets(tab)

File1(Spot Tab)
<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 71px;"><col style="width: 104px;"><col style="width: 55px;"><col style="width: 31px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 63px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td></tr><tr style="height: 16px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Courier; text-align: left;">Trade ID</td><td style="font-family: Courier; text-align: left;">Trade Number</td><td style="font-family: Courier; text-align: left;">Folder</td><td style="font-family: Courier; text-align: left;">B/S</td><td style="font-family: Courier; text-align: left;">Cpty</td><td style="font-family: Courier; text-align: left;">Cpty Name</td><td style="font-family: Courier; text-align: left;">Trade Date</td><td style="font-family: Courier; text-align: left;">Value</td><td style="font-family: Courier; text-align: left;">Pair</td><td style="font-family: Courier; text-align: left;">Spot Rate</td><td style="font-family: Courier; text-align: left;">Amount1</td><td style="font-family: Courier;">Mode</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;">123</td><td style="text-align: right;">111</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">13/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.23</td><td style="text-align: right;">100000</td><td>Generated</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;">321</td><td style="text-align: right;">222</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">13/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1</td><td style="text-align: right;">100000</td><td>Captured</td></tr></tbody></table>
File 2(Spot Tab)
<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 71px;"><col style="width: 104px;"><col style="width: 55px;"><col style="width: 31px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 63px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td></tr><tr style="height: 16px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Courier; text-align: left;">Trade ID</td><td style="font-family: Courier; text-align: left;">Trade Number</td><td style="font-family: Courier; text-align: left;">Folder</td><td style="font-family: Courier; text-align: left;">B/S</td><td style="font-family: Courier; text-align: left;">Cpty</td><td style="font-family: Courier; text-align: left;">Cpty Name</td><td style="font-family: Courier; text-align: left;">Trade Date</td><td style="font-family: Courier; text-align: left;">Value</td><td style="font-family: Courier; text-align: left;">Pair</td><td style="font-family: Courier; text-align: left;">Spot Rate</td><td style="font-family: Courier; text-align: left;">Amount1</td><td style="font-family: Courier;">Mode</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="text-align: right;">444</td><td style="text-align: right;">333</td><td>DP</td><td>B</td><td>DDD</td><td>DDD</td><td style="text-align: right;">16/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.3</td><td style="text-align: right;">20000</td><td>Captured</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="text-align: right;">555</td><td style="text-align: right;">444</td><td>ND</td><td>S</td><td>SSS</td><td>SSS</td><td style="text-align: right;">17/3/2009</td><td style="text-align: right;">16/3/2009</td><td>EUR</td><td style="text-align: right;">1.5</td><td style="text-align: right;">300000</td><td>Captured</td></tr></tbody></table>
Summary(Spot tab)

<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td style="font-family: Courier; text-align: left;">Trade ID</td><td style="font-family: Courier; text-align: left;">Trade Number</td><td style="font-family: Courier; text-align: left;">Folder</td><td style="font-family: Courier; text-align: left;">B/S</td><td style="font-family: Courier; text-align: left;">Cpty</td><td style="font-family: Courier; text-align: left;">Cpty Name</td><td style="font-family: Courier; text-align: left;">Trade Date</td><td style="font-family: Courier; text-align: left;">Value</td><td style="font-family: Courier; text-align: left;">Pair</td><td style="font-family: Courier; text-align: left;">Spot Rate</td><td style="font-family: Courier; text-align: left;">Amount1</td><td style="font-family: Courier;">Mode</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="text-align: right;">987</td><td style="text-align: right;">111</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">14/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.23</td><td style="text-align: right;">100000</td><td>Generated</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="text-align: right;">237</td><td style="text-align: right;">222</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">15/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1</td><td style="text-align: right;">100000</td><td>Captured</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;">444</td><td style="text-align: right;">333</td><td>DP</td><td>B</td><td>DDD</td><td>DDD</td><td style="text-align: right;">16/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.3</td><td style="text-align: right;">20000</td><td>Captured</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;">555</td><td style="text-align: right;">444</td><td>ND</td><td>S</td><td>SSS</td><td>SSS</td><td style="text-align: right;">17/3/2009</td><td style="text-align: right;">16/3/2009</td><td>EUR</td><td style="text-align: right;">1.5</td><td style="text-align: right;">300000</td><td>Captured</td></tr></tbody></table>

Summary(Menu tab)
<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>C</td><td>D</td><td>E</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>Directory</td><td>C:\trades\Mar\</td><td> </td></tr></tbody></table>

 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
This macro will copy data from each workbook, including each worksheet, in the Folder listed on your "Menu" page.
Code:
Sub CopyAllWSinDir()
Dim OrigWB As String, myDir As String, fn As String, SourceWS As String
Dim WS As Worksheet
Dim LTargRow As Integer, lrow As Integer, lcol As Integer
    OrigWB = ActiveWorkbook.Name
    myDir = Sheets("Menu").Range("D1")
    fn = Dir(myDir & "*.xls")
Do While fn <> ""
'Open WorkBook
With Workbooks.Open(myDir & fn)
    For Each WS In Worksheets
        'Assign Variables
        SourceWS = WS.Name
        LTargRow = Workbooks(OrigWB).Sheets(SourceWS).Range("A65536").End(xlUp).Row + 1
        lrow = Sheets(SourceWS).UsedRange.Rows.Count + 2
        lcol = Sheets(SourceWS).UsedRange.Columns.Count
        'Copy worksheet data to Target
        Workbooks(fn).Sheets(SourceWS).Range(Sheets(SourceWS).Cells(4, 1), (Sheets(SourceWS).Cells(lrow, lcol))).Copy Workbooks(OrigWB).Sheets(SourceWS).Range("A" & LTargRow)
    Next WS
    .Close 'Close Workbook
End With
fn = Dir()
Loop
End Sub
The code assumes each worksheet exists on the originating (Summary) workbook.
Also, that each worksheets' data starts on row 3 as in your example.
 
Upvote 0
Code:
Sub test()
Dim myDir As String, fn As String, LastR As Range, flg As Boolean
myDir = "C:\trades\Mar\"
fn = Dir(myDir & "*.xls")
Do While fn <> ""
    Set LastR = ThisWorkbook.Sheets("Spot").Range("a1")
    If Not IsEmpty(LastR) Then _
    Sete LastR = ThisWorkbook.Sheets("Spot").Range("a" & Rows.Count).End(xlUp)(2)
    With Workbooks.Open(myDir & fn)
        .Sheets("Spot").Range("b" & IIf(flg, 4, 3) & ", _
        .Range("b" & Rows.Count).End(xlUp)).Resize(, 12).Copy _ LastR
        .Close False
    End With
    flg = True
    fn = Dir
Loop
End Sub
 
Upvote 0
This macro will copy data from each workbook, including each worksheet, in the Folder listed on your "Menu" page.
Code:
Sub CopyAllWSinDir()
Dim OrigWB As String, myDir As String, fn As String, SourceWS As String
Dim WS As Worksheet
Dim LTargRow As Integer, lrow As Integer, lcol As Integer
    OrigWB = ActiveWorkbook.Name
    myDir = Sheets("Menu").Range("D1")
    fn = Dir(myDir & "*.xls")
Do While fn <> ""
'Open WorkBook
With Workbooks.Open(myDir & fn)
    For Each WS In Worksheets
        'Assign Variables
        SourceWS = WS.Name
        LTargRow = Workbooks(OrigWB).Sheets(SourceWS).Range("A65536").End(xlUp).Row + 1
        lrow = Sheets(SourceWS).UsedRange.Rows.Count + 2
        lcol = Sheets(SourceWS).UsedRange.Columns.Count
        'Copy worksheet data to Target
        Workbooks(fn).Sheets(SourceWS).Range(Sheets(SourceWS).Cells(4, 1), (Sheets(SourceWS).Cells(lrow, lcol))).Copy Workbooks(OrigWB).Sheets(SourceWS).Range("A" & LTargRow)
    Next WS
    .Close 'Close Workbook
End With
fn = Dir()
Loop
End Sub
The code assumes each worksheet exists on the originating (Summary) workbook.
Also, that each worksheets' data starts on row 3 as in your example.

It work, but it copy only the last workbook opened. I wan those detail to copy below each other. any idea how to do ?
 
Upvote 0
I am not clear on what is not working or even what you want to do.

Here is what I have done:
Created a Directory "C:\Trade\Mar\"
Created two files called "File 1" and File 2" and put them in the above Directory.
Created two folders in each File, "Spot", and "Spot2". I added the second worksheet I case you had multiple worksheets with data in them.
Pasted your sample data into each worksheet.
I changed the data slightly in each worksheet so I could tell what worksheet it came from.
I created the same named worksheets in the Summary workbook and put in just the Headers on Row 3.
When I ran the macro code, each file in the new Directory would open. Then each worksheet would be copied to the corresponding same named folder in the Summary workbook. Then the file would close and the next would do the same.
The data is added to the Summary workbooks' existing data on the two worksheets each time it is run.

If this is not what you are trying to do, please explain what you want.
 
Upvote 0
I have a similar sheet with more columns about (16) and about 5000 entries per worksheet. I want to compile all these worksheets into 1. I help with the macro.

Sheet1
<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 71px;"><col style="width: 104px;"><col style="width: 55px;"><col style="width: 31px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 63px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td></tr><tr style="height: 16px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Courier; text-align: left;">Trade ID</td><td style="font-family: Courier; text-align: left;">Trade Number</td><td style="font-family: Courier; text-align: left;">Folder</td><td style="font-family: Courier; text-align: left;">B/S</td><td style="font-family: Courier; text-align: left;">Cpty</td><td style="font-family: Courier; text-align: left;">Cpty Name</td><td style="font-family: Courier; text-align: left;">Trade Date</td><td style="font-family: Courier; text-align: left;">Value</td><td style="font-family: Courier; text-align: left;">Pair</td><td style="font-family: Courier; text-align: left;">Spot Rate</td><td style="font-family: Courier; text-align: left;">Amount1</td><td style="font-family: Courier;">Mode</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;">123</td><td style="text-align: right;">111</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">13/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.23</td><td style="text-align: right;">100000</td><td>Generated</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;">321</td><td style="text-align: right;">222</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">13/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1</td><td style="text-align: right;">100000</td><td>Captured</td></tr></tbody></table>
Sheet2
<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 71px;"><col style="width: 104px;"><col style="width: 55px;"><col style="width: 31px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 39px;"><col style="width: 79px;"><col style="width: 63px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td></tr><tr style="height: 16px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="font-family: Courier; text-align: left;">Trade ID</td><td style="font-family: Courier; text-align: left;">Trade Number</td><td style="font-family: Courier; text-align: left;">Folder</td><td style="font-family: Courier; text-align: left;">B/S</td><td style="font-family: Courier; text-align: left;">Cpty</td><td style="font-family: Courier; text-align: left;">Cpty Name</td><td style="font-family: Courier; text-align: left;">Trade Date</td><td style="font-family: Courier; text-align: left;">Value</td><td style="font-family: Courier; text-align: left;">Pair</td><td style="font-family: Courier; text-align: left;">Spot Rate</td><td style="font-family: Courier; text-align: left;">Amount1</td><td style="font-family: Courier;">Mode</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="text-align: right;">444</td><td style="text-align: right;">333</td><td>DP</td><td>B</td><td>DDD</td><td>DDD</td><td style="text-align: right;">16/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.3</td><td style="text-align: right;">20000</td><td>Captured</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="text-align: right;">555</td><td style="text-align: right;">444</td><td>ND</td><td>S</td><td>SSS</td><td>SSS</td><td style="text-align: right;">17/3/2009</td><td style="text-align: right;">16/3/2009</td><td>EUR</td><td style="text-align: right;">1.5</td><td style="text-align: right;">300000</td><td>Captured</td></tr></tbody></table>
Sheet3

<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td style="font-family: Courier; text-align: left;">Trade ID</td><td style="font-family: Courier; text-align: left;">Trade Number</td><td style="font-family: Courier; text-align: left;">Folder</td><td style="font-family: Courier; text-align: left;">B/S</td><td style="font-family: Courier; text-align: left;">Cpty</td><td style="font-family: Courier; text-align: left;">Cpty Name</td><td style="font-family: Courier; text-align: left;">Trade Date</td><td style="font-family: Courier; text-align: left;">Value</td><td style="font-family: Courier; text-align: left;">Pair</td><td style="font-family: Courier; text-align: left;">Spot Rate</td><td style="font-family: Courier; text-align: left;">Amount1</td><td style="font-family: Courier;">Mode</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="text-align: right;">987</td><td style="text-align: right;">111</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">14/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.23</td><td style="text-align: right;">100000</td><td>Generated</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="text-align: right;">237</td><td style="text-align: right;">222</td><td>ND</td><td>B</td><td>TDG</td><td>TDG</td><td style="text-align: right;">15/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1</td><td style="text-align: right;">100000</td><td>Captured</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;">444</td><td style="text-align: right;">333</td><td>DP</td><td>B</td><td>DDD</td><td>DDD</td><td style="text-align: right;">16/3/2009</td><td style="text-align: right;">16/3/2009</td><td>USD</td><td style="text-align: right;">1.3</td><td style="text-align: right;">20000</td><td>Captured</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;">555</td><td style="text-align: right;">444</td><td>ND</td><td>S</td><td>SSS</td><td>SSS</td><td style="text-align: right;">17/3/2009</td><td style="text-align: right;">16/3/2009</td><td>EUR</td><td style="text-align: right;">1.5</td><td style="text-align: right;">300000</td><td>Captured</td></tr></tbody></table>

<b> ... all the way to Sheet18 </b>
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top