VBA to filter Worksheet on manager column & copy all data to new workbook

K

kizzie37

Well-known Member
Joined
Oct 23, 2007
Messages
585
Office Version
  1. 365
Hi, I'm not a VBA person, but tried to take a stab piecing together bits from other posts, but didn't do too well.

I have a worksheet Range A - Z.
Column C is filled with manager names (multiple entries of same manager name as each line represents an employee who reports to a manager, Multiple employees per manager)
I need the code to filter the list by each manager, copy the range for each and paste into a separate workbook (not as values, as is). then save the workbook as "Text workbook & Manager Name)
loop through all managers and do this for every manager on the list.

I cant save a test file here because security wont allow this or upload of code. Below is what I pieced together, I know its not correct, but some of the elements work.

VBA Code: 
Sub FilterCopyPaste()

    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim Cws As Worksheet
    Dim FilterRange As Range
    Dim filteredData As Range
    Dim managerCell As Range
    Dim newWorkbook As Workbook
    Dim newFilePath As String
    Dim Rcount As Long
    Dim Rnum As Long
    Dim FieldNum As Integer
    Dim mailAddress As String
    Dim strbody As String
    Dim DefaultSignature As String
  
    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet
  
    'Set filter range and filter column (Column with names)
    Set FilterRange = Ash.Range("A1:Z" & Ash.Rows.Count)
    FieldNum = 3
    
    'Count of the unique values + the header cell
    Rcount = Application.WorksheetFunction.CountA(Ash.Columns(3))
    'If there are unique values start the loop
        If Rcount >= 2 Then
        For Rnum = 2 To Rcount

            'Filter the FilterRange on the FieldNum column
            FilterRange.AutoFilter Field:=FieldNum, _
                                   Criteria1:=Ash.Cells(Rnum, 1).Value
    
    
        'Add a worksheet for the unique list and copy the unique list in A1
    Set newWorkbook = Workbooks.Add
    FilterRange.Columns(FieldNum).AdvancedFilter _
            Action:=xlFilterCopy, _
            CopyToRange:=Ash.Range("A1"), _
            CriteriaRange:="", Unique:=True
            

        newWorkbook.Worksheets(1).Range("A1").Paste Paste:=xlPaste
        ' Save the new workbook with the department value
        newWorkbook.SaveAs wb.Path & "\" & "Compensation Increase Master Sheet" & ".xlsx"
        newWorkbook.Close SaveChanges:=False
    
        Next Rnum
  
    Application.ScreenUpdating = False
  

    'Close AutoFilter
    Ash.AutoFilterMode = False

    ' Activate the original workbook
    wb.Activate
    End If
    
End Sub
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
It looks like you are on the right track. If I understand what you are looking for, you may want to try this.

VBA Code: 
Sub FilterCopyPaste()

    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim UniqueManagers As Range
    Dim ManagerName As Range
    Dim Manager As String
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long

    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet

    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("C:C")
    FieldNum = 1

    ' Find the last row in the filter range
    LastRow = FilterRange.Find(What:="*", After:=FilterRange.Cells(1), SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

    ' Create a list of unique manager names
    Set UniqueManagers = Ash.Range("C2:C" & LastRow).AdvancedFilter(Unique:=True)

    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers.Rows
        Manager = ManagerName.Value

        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=Manager

        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add

        ' Copy the visible cells (filtered data) to the new workbook
        Ash.UsedRange.SpecialCells(xlCellTypeVisible).Copy

        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste

        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & Manager & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False

        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerName

    Application.ScreenUpdating = True

End Sub



This code should filter the data by manager names, copy the filtered data, create a new workbook for each manager, paste the data into the new workbook, and save it with the manager's name. It loops through all unique manager names in your data and performs these steps for each manager.
 
Upvote 0
dragontbone said:
It looks like you are on the right track. If I understand what you are looking for, you may want to try this.

VBA Code: 
Sub FilterCopyPaste()

    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim UniqueManagers As Range
    Dim ManagerName As Range
    Dim Manager As String
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long

    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet

    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("C:C")
    FieldNum = 1

    ' Find the last row in the filter range
    LastRow = FilterRange.Find(What:="*", After:=FilterRange.Cells(1), SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

    ' Create a list of unique manager names
    Set UniqueManagers = Ash.Range("C2:C" & LastRow).AdvancedFilter(Unique:=True)

    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers.Rows
        Manager = ManagerName.Value

        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=Manager

        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add

        ' Copy the visible cells (filtered data) to the new workbook
        Ash.UsedRange.SpecialCells(xlCellTypeVisible).Copy

        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste

        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & Manager & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False

        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerName

    Application.ScreenUpdating = True

End Sub



This code should filter the data by manager names, copy the filtered data, create a new workbook for each manager, paste the data into the new workbook, and save it with the manager's name. It loops through all unique manager names in your data and performs these steps for each manager.
Click to expand...
Thanks for this, its erroring on :

Code: 
 Set UniqueManagers = Ash.Range("C2:C" & LastRow).AdvancedFilter(Unique:=True)

"Unable to get AdvancedFilter property of the Range class"

?
 
Upvote 0
Try this:

VBA Code: 
Sub FilterCopyPaste()

    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim ManagerNames As Range
    Dim ManagerNameCell As Range
    Dim ManagerName As String
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long
    Dim Dict As Object

    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet

    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("C:C")
    FieldNum = 1

    ' Find the last row in the filter range
    LastRow = Ash.Cells(Ash.Rows.Count, "C").End(xlUp).Row

    ' Create a dictionary to store unique manager names
    Set Dict = CreateObject("Scripting.Dictionary")

    ' Loop through the manager names and add them to the dictionary
    For Each ManagerNameCell In FilterRange.Range("C2:C" & LastRow)
        ManagerName = ManagerNameCell.Value
        If Not Dict.Exists(ManagerName) Then
            Dict(ManagerName) = True
        End If
    Next ManagerNameCell

    ' Get the unique manager names from the dictionary
    Set ManagerNames = Ash.Range("AA1").Resize(Dict.Count, 1)
    i = 0
    For Each Key In Dict.Keys
        ManagerNames.Cells(i + 1, 1).Value = Key
        i = i + 1
    Next Key

    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerNameCell In ManagerNames.Rows
        ManagerName = ManagerNameCell.Value

        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=ManagerName

        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add

        ' Copy the visible cells (filtered data) to the new workbook
        Ash.UsedRange.SpecialCells(xlCellTypeVisible).Copy

        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste

        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & ManagerName & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False

        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerNameCell

    Application.ScreenUpdating = True

End Sub
 
Upvote 0
dragontbone said:
Try this:

VBA Code: 
Sub FilterCopyPaste()

    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim ManagerNames As Range
    Dim ManagerNameCell As Range
    Dim ManagerName As String
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long
    Dim Dict As Object

    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet

    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("C:C")
    FieldNum = 1

    ' Find the last row in the filter range
    LastRow = Ash.Cells(Ash.Rows.Count, "C").End(xlUp).Row

    ' Create a dictionary to store unique manager names
    Set Dict = CreateObject("Scripting.Dictionary")

    ' Loop through the manager names and add them to the dictionary
    For Each ManagerNameCell In FilterRange.Range("C2:C" & LastRow)
        ManagerName = ManagerNameCell.Value
        If Not Dict.Exists(ManagerName) Then
            Dict(ManagerName) = True
        End If
    Next ManagerNameCell

    ' Get the unique manager names from the dictionary
    Set ManagerNames = Ash.Range("AA1").Resize(Dict.Count, 1)
    i = 0
    For Each Key In Dict.Keys
        ManagerNames.Cells(i + 1, 1).Value = Key
        i = i + 1
    Next Key

    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerNameCell In ManagerNames.Rows
        ManagerName = ManagerNameCell.Value

        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=ManagerName

        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add

        ' Copy the visible cells (filtered data) to the new workbook
        Ash.UsedRange.SpecialCells(xlCellTypeVisible).Copy

        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste

        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & ManagerName & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False

        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerNameCell

    Application.ScreenUpdating = True

End Sub
Click to expand...
Thanks, unfortunately all that's happening is its creating new workbooks and only copying the header from the master workbook tot he new workbook and nothing else, it also is naming the file based on a value in column E. I dont see a filter being applied at all to the master.
 
Upvote 0
How about this one?

VBA Code: 
Sub FilterCopyPaste()
    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim ManagerNames As Range
    Dim ManagerNameCell As Range
    Dim ManagerName As String
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long
    Dim UniqueManagers As Collection
    
    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet
    
    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("A1:Z" & Ash.Cells(Rows.Count, "A").End(xlUp).Row)
    FieldNum = 3
    
    ' Find the last row in the filter range
    LastRow = FilterRange.Rows.Count
    
    ' Create a collection to store unique manager names
    Set UniqueManagers = New Collection
    
    ' Loop through the manager names and add them to the collection
    On Error Resume Next
    For i = 2 To LastRow
        UniqueManagers.Add FilterRange.Cells(i, FieldNum).Value, CStr(FilterRange.Cells(i, FieldNum).Value)
    Next i
    On Error GoTo 0
    
    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers
        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add
        
        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=ManagerName
        
        ' Copy the visible cells (filtered data) to the new workbook
        FilterRange.SpecialCells(xlCellTypeVisible).Copy
        
        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste
        
        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & ManagerName & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False
        
        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerName

    Application.ScreenUpdating = True
End Sub

I made several changes to the code to address the issues you mentioned. Here are the key changes:

  1. Changed the range for FilterRange to span columns A to Z and find the last row in column A to determine the range.
  2. Modified the code to collect unique manager names using a Collection instead of a dictionary.
  3. Used the SpecialCells method to copy visible (filtered) cells, which should fix the issue of only copying the header.
  4. Corrected the filename used for saving workbooks to be based on the manager's name.
These changes should ensure that the code filters the data correctly, copies the visible cells, and saves the workbooks with the manager's name.
 
Upvote 0
dragontbone said:
How about this one?

VBA Code: 
Sub FilterCopyPaste()
    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim ManagerNames As Range
    Dim ManagerNameCell As Range
    Dim ManagerName As String
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long
    Dim UniqueManagers As Collection
   
    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet
   
    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("A1:Z" & Ash.Cells(Rows.Count, "A").End(xlUp).Row)
    FieldNum = 3
   
    ' Find the last row in the filter range
    LastRow = FilterRange.Rows.Count
   
    ' Create a collection to store unique manager names
    Set UniqueManagers = New Collection
   
    ' Loop through the manager names and add them to the collection
    On Error Resume Next
    For i = 2 To LastRow
        UniqueManagers.Add FilterRange.Cells(i, FieldNum).Value, CStr(FilterRange.Cells(i, FieldNum).Value)
    Next i
    On Error GoTo 0
   
    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers
        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add
       
        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=ManagerName
       
        ' Copy the visible cells (filtered data) to the new workbook
        FilterRange.SpecialCells(xlCellTypeVisible).Copy
       
        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste
       
        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & ManagerName & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False
       
        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerName

    Application.ScreenUpdating = True
End Sub

I made several changes to the code to address the issues you mentioned. Here are the key changes:

  1. Changed the range for FilterRange to span columns A to Z and find the last row in column A to determine the range.
  2. Modified the code to collect unique manager names using a Collection instead of a dictionary.
  3. Used the SpecialCells method to copy visible (filtered) cells, which should fix the issue of only copying the header.
  4. Corrected the filename used for saving workbooks to be based on the manager's name.
These changes should ensure that the code filters the data correctly, copies the visible cells, and saves the workbooks with the manager's name.
Click to expand...
Thank you, this results in a "compile error" "For each control variable must be Variant or Object" on
VBA Code: 
    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers
 
Upvote 0
Sorry about that. Maybe this will work?

VBA Code: 
Sub FilterCopyPaste()
    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim ManagerNames As Range
    Dim ManagerNameCell As Range
    Dim ManagerName As Variant 
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long
    Dim UniqueManagers As Collection
    
    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet
    
    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("A1:Z" & Ash.Cells(Rows.Count, "A").End(xlUp).Row)
    FieldNum = 3
    
    ' Find the last row in the filter range
    LastRow = FilterRange.Rows.Count
    
    ' Create a collection to store unique manager names
    Set UniqueManagers = New Collection
    
    ' Loop through the manager names and add them to the collection
    On Error Resume Next
    For i = 2 To LastRow
        UniqueManagers.Add FilterRange.Cells(i, FieldNum).Value, CStr(FilterRange.Cells(i, FieldNum).Value)
    Next i
    On Error GoTo 0
    
    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers
        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add
        
        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=ManagerName
        
        ' Copy the visible cells (filtered data) to the new workbook
        FilterRange.SpecialCells(xlCellTypeVisible).Copy
        
        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste
        
        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & ManagerName & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False
        
        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerName

    Application.ScreenUpdating = True
End Sub
 
Upvote 0
dragontbone said:
Sorry about that. Maybe this will work?

VBA Code: 
Sub FilterCopyPaste()
    Dim wb As Workbook
    Dim Ash As Worksheet
    Dim FilterRange As Range
    Dim ManagerNames As Range
    Dim ManagerNameCell As Range
    Dim ManagerName As Variant
    Dim NewWorkbook As Workbook
    Dim NewWorksheet As Worksheet
    Dim NewFilePath As String
    Dim Rcount As Long
    Dim FieldNum As Integer
    Dim LastRow As Long
    Dim UniqueManagers As Collection
   
    ' Set the workbook and worksheet variables
    Set wb = ThisWorkbook
    Set Ash = wb.ActiveSheet
   
    ' Set filter range and filter column (Column with manager names)
    Set FilterRange = Ash.Range("A1:Z" & Ash.Cells(Rows.Count, "A").End(xlUp).Row)
    FieldNum = 3
   
    ' Find the last row in the filter range
    LastRow = FilterRange.Rows.Count
   
    ' Create a collection to store unique manager names
    Set UniqueManagers = New Collection
   
    ' Loop through the manager names and add them to the collection
    On Error Resume Next
    For i = 2 To LastRow
        UniqueManagers.Add FilterRange.Cells(i, FieldNum).Value, CStr(FilterRange.Cells(i, FieldNum).Value)
    Next i
    On Error GoTo 0
   
    Application.ScreenUpdating = False

    ' Loop through each unique manager name
    For Each ManagerName In UniqueManagers
        ' Create a new workbook
        Set NewWorkbook = Workbooks.Add
       
        ' Filter the data for the current manager
        FilterRange.AutoFilter Field:=FieldNum, Criteria1:=ManagerName
       
        ' Copy the visible cells (filtered data) to the new workbook
        FilterRange.SpecialCells(xlCellTypeVisible).Copy
       
        ' Add a new worksheet to the new workbook
        Set NewWorksheet = NewWorkbook.Worksheets.Add
        NewWorksheet.Paste
       
        ' Save the new workbook with the manager's name
        NewFilePath = wb.Path & "\Text workbook " & ManagerName & ".xlsx"
        NewWorkbook.SaveAs Filename:=NewFilePath
        NewWorkbook.Close SaveChanges:=False
       
        ' Clear the filter
        Ash.AutoFilterMode = False
    Next ManagerName

    Application.ScreenUpdating = True
End Sub
Click to expand...
Works perfectly! thank you so much for your help with this, much appreciated!
 
Upvote 1
You must log in or register to reply here.

Similar threads

E
  • Question Question
Automatically populate cell after vba email sent
Replies
1
Views
947
eddieum1
E
E
  • Solved
Hiding first column of Email
Replies
3
Views
563
James006
James006
S
  • Question Question
Can’t hide column using VBA
Replies
3
Views
290
Joe4
Joe4
H
  • Solved
Splitting Data into Workbooks - EDIT HELP
Replies
1
Views
291
horrellbt01
H
K
  • Question Question
Help with VB Code to copy workbook
Replies
0
Views
453
kizzie37
K

Forum statistics

Threads
1,224,815
Messages
6,181,135
Members
453,021
Latest member
Justyna P

Share this page

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