Matching cells, adding blank lines

C

chethead

New Member
Joined
Jul 23, 2015
Messages
45
Office Version
  1. 2016
Platform
  1. Windows
Hello,

I've got an idea for a spreadsheet but am not sure where to get started. I have two tabs (Tab A and Tab B); each tab contains materials for a job. Each group of materials "A" column is the system into which the material was taken off. I would like to have all of my column A from Tab A correspond to Tab B (on a separate sheet, Tab C) but insert blank lines where I have extra items from either tab:

From Tab A From Tab B
1100 1100
1100 1100
1100
6600 6600
6600
6600
6600
7900 7900
7900 7900

I don't really think this is possible but if anyone is up for the challenge, feel free to give it a whirl.

Thank you,

Rob
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
So what would the result in Tab C look like, based on the posted data ??
 
Upvote 0
Michael M said:
So what would the result in Tab C look like, based on the posted data ??
Click to expand...
I have assumed that clicking 'Reply with Quote' to post 1 gives you the answer to that.


Rob,
Give this a try in a copy of your workbook.
I have assumed that 'Tab C' already exists and if there is any data in columns A:B it can be removed.

Rich (BB code): 
Sub MatchValues()
  Dim dA As Object, dB As Object
  Dim a As Variant, b As Variant, itm As Variant
  Dim i As Long, r As Long
  
  Set dA = CreateObject("Scripting.Dictionary")
  Set dB = CreateObject("Scripting.Dictionary")
  With Sheets("Tab A")
    a = .Range("A2", .Range("A" & Rows.Count).End(xlUp)).Value
  End With
  For i = 1 To UBound(a)
    dA(a(i, 1)) = dA(a(i, 1)) + 1
  Next i
  With Sheets("Tab B")
    b = .Range("A2", .Range("A" & Rows.Count).End(xlUp)).Value
  End With
  For i = 1 To UBound(b)
    dB(b(i, 1)) = dB(b(i, 1)) + 1
  Next i
  Application.ScreenUpdating = False
  With Sheets("Tab C")
    .Columns("A:B").ClearContents
    .Range("A1:B1").Value = Array("Tab A", "Tab B")
    .Range("A2").Resize(UBound(a)).Value = a
    r = 2
    Do
      itm = .Cells(r, 1).Value
      If dB.Exists(itm) Then
        .Cells(r, 2).Resize(dB(itm)).Value = itm
        If dB(itm) > dA(itm) Then
          .Cells(r + dA(itm), 1).Resize(dB(itm) - dA(itm)).Insert Shift:=xlDown
        End If
        r = r + IIf(dB(itm) > dA(itm), dB(itm), dA(itm))
        dB.Remove itm
      Else
        r = r + dA(itm)
      End If
      dA.Remove itm
    Loop Until dA.Count = 0
    If dB.Count > 0 Then
      For Each itm In dB.Keys()
        .Cells(r, 2).Resize(dB(itm)).Value = itm
        r = r + dB(itm)
      Next itm
    End If
  End With
  Application.ScreenUpdating = True
End Sub
 
Last edited:
Upvote 0
ok I finally figured out the HTML maker (I hope). So to be more precise, Tab A and Tab B feed into Tab C (Comparison worksheet) in a side by side fashion. I can than visually compare if I am missing systems in either Tab A or Tab B:

ABCIJKL
SystemDescriptionQuantitySystemDescriptionQuantity
|| 0100 - TEMPORARY LIGHTING & POWERTEMPORARY POWER AND LIGHTING || 0100 - TEMPORARY LIGHTING & POWERTEMPORARY POWER AND LIGHTING
|| 0100 - TEMPORARY LIGHTING & POWERLIVE COUNT LINK || 0100 - TEMPORARY LIGHTING & POWERTEMPORARY TRAILER CONNECTION
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHSB1 - 4000A 480/277V (4) section || 0100 - TEMPORARY LIGHTING & POWERTEMPORARY SERVICE
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTSLP1 - 250A 277/480V PANEL || 0100 - TEMPORARY LIGHTING & POWERLIVE COUNT LINK
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTT4 - 75KVA TRANSFORMER || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTD2 1200A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTINVERTER || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTMDP-1 1000A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE 3/4" CONDUIT - EMT || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHA 400A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE1" CONDUIT - EMT || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHB 400A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE1 1/2" CONDUIT - EMT || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHC 400A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE2" CONDUIT - EMT || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTLD 100A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE3" CONDUIT - EMT || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTLA 100A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#350 XHHW BLACK - AL || 0500 - LIGHT FIXTURES & LAMPSTYPE A - LED HIGH BAY
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#500 XHHW BLACK - AL || 0500 - LIGHT FIXTURES & LAMPSTYPE AE - LED HIGH BAY W/BATTERY PACK
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#8 TO #10x 7/8 PLAS ANCHOR (3/16) || 0500 - LIGHT FIXTURES & LAMPSTYPE B - 2X4 LED TROFFER
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#10x 1 P/H SELF-TAP SCREW || 0500 - LIGHT FIXTURES & LAMPSTYPE BE - 2X4 LED TROFFER W/ BATTERY PACK
|| 0500 - LIGHT FIXTURES & LAMPSTYPE A1 - 2X4 LED TROFFER || 0500 - LIGHT FIXTURES & LAMPSTYPE B2 - 2X4 LED TROFFER W/DRYWALL FRAME KIT

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"] 1 [/TD]
[TD="align: center"] Original Estimate [/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] New Estimate [/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"] 2 [/TD]

[TD="align: right"][/TD]

[TD="align: center"] 3 [/TD]

[TD="align: right"] 111,000 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 116,000 [/TD]

[TD="align: center"] 4 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 4 [/TD]

[TD="align: center"] 5 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 3 [/TD]

[TD="align: center"] 6 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 5 [/TD]

[TD="align: center"] 7 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 8 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 9 [/TD]

[TD="align: right"] 16 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 10 [/TD]

[TD="align: right"] 10 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 11 [/TD]

[TD="align: right"] 825 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 12 [/TD]

[TD="align: right"] 40 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 13 [/TD]

[TD="align: right"] 20 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 14 [/TD]

[TD="align: right"] 200 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 122 [/TD]

[TD="align: center"] 15 [/TD]

[TD="align: right"] 690 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 45 [/TD]

[TD="align: center"] 16 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 79 [/TD]

[TD="align: center"] 17 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 14 [/TD]

[TD="align: center"] 18 [/TD]

[TD="align: right"] 82 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 10 [/TD]

</tbody>
Comparison​




But what I would like to do is match all of the systems on the left with what is one the right. I do not care what the description or quantity are or if they match; just that the systems match. Like so:

ABCIJKL
SystemDescriptionQuantitySystemDescriptionQuantity
|| 0100 - TEMPORARY LIGHTING & POWERTEMPORARY POWER AND LIGHTING || 0100 - TEMPORARY LIGHTING & POWERTEMPORARY POWER AND LIGHTING
|| 0100 - TEMPORARY LIGHTING & POWERLIVE COUNT LINK || 0100 - TEMPORARY LIGHTING & POWERTEMPORARY TRAILER CONNECTION
|| 0100 - TEMPORARY LIGHTING & POWERTEMPORARY SERVICE
|| 0100 - TEMPORARY LIGHTING & POWERLIVE COUNT LINK
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHSB1 - 4000A 480/277V (4) section || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTD2 1200A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTSLP1 - 250A 277/480V PANEL || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTMDP-1 1000A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTT4 - 75KVA TRANSFORMER || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHA 400A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTINVERTER || 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHB 400A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTHC 400A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTLD 100A 480/277V
|| 0300 - LOW VOLTAGE DISTRIBUTION EQUIPMENTLA 100A 480/277V
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE 3/4" CONDUIT - EMT
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE1" CONDUIT - EMT
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE1 1/2" CONDUIT - EMT
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE2" CONDUIT - EMT
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE3" CONDUIT - EMT
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#350 XHHW BLACK - AL
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#500 XHHW BLACK - AL
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#8 TO #10x 7/8 PLAS ANCHOR (3/16)
|| 0310 - LOW VOLTAGE FEEDER CONDUIT & WIRE#10x 1 P/H SELF-TAP SCREW
|| 0500 - LIGHT FIXTURES & LAMPSTYPE A1 - 2X4 LED TROFFER || 0500 - LIGHT FIXTURES & LAMPSTYPE A - LED HIGH BAY
|| 0500 - LIGHT FIXTURES & LAMPSTYPE AE - LED HIGH BAY W/BATTERY PACK
|| 0500 - LIGHT FIXTURES & LAMPSTYPE B - 2X4 LED TROFFER
|| 0500 - LIGHT FIXTURES & LAMPSTYPE BE - 2X4 LED TROFFER W/ BATTERY PACK
|| 0500 - LIGHT FIXTURES & LAMPSTYPE B2 - 2X4 LED TROFFER W/DRYWALL FRAME KIT

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"] 1 [/TD]
[TD="align: center"] Original Estimate [/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"] New Estimate [/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"] 2 [/TD]

[TD="align: right"][/TD]

[TD="align: center"] 3 [/TD]

[TD="align: right"] 111,000 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 116,000 [/TD]

[TD="align: center"] 4 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 4 [/TD]

[TD="align: center"] 5 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 3 [/TD]

[TD="align: center"] 6 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 5 [/TD]

[TD="align: center"] 7 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 8 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 9 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 10 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 11 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 12 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 13 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"] 1 [/TD]

[TD="align: center"] 14 [/TD]

[TD="align: right"] 16 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 15 [/TD]

[TD="align: right"] 10 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 16 [/TD]

[TD="align: right"] 825 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 17 [/TD]

[TD="align: right"] 40 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 18 [/TD]

[TD="align: right"] 20 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 19 [/TD]

[TD="align: right"] 200 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 20 [/TD]

[TD="align: right"] 690 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 21 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 22 [/TD]

[TD="align: right"] 1 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 23 [/TD]

[TD="align: right"] 82 [/TD]
[TD="align: right"][/TD]

[TD="align: right"] 122 [/TD]

[TD="align: center"] 24 [/TD]

[TD="align: right"][/TD]

[TD="align: right"] 45 [/TD]

[TD="align: center"] 25 [/TD]

[TD="align: right"][/TD]

[TD="align: right"] 79 [/TD]

[TD="align: center"] 26 [/TD]

[TD="align: right"][/TD]

[TD="align: right"] 14 [/TD]

[TD="align: center"] 27 [/TD]

[TD="align: right"][/TD]

[TD="align: right"] 10 [/TD]

</tbody>
Comparison​

This way I can compare if I am missing anything per system when comparing
 
Last edited:
Upvote 0
This time I have assumed that 'Tab C' already exists and if there is any data in columns A:C and J:L it can be removed.
Not highly tested, but give this a go.

Rich (BB code): 
Sub MatchValues_v2()
  Dim dA As Object, dB As Object
  Dim a As Variant, b As Variant, itm As Variant, Headings As Variant
  Dim i As Long, r As Long
  Dim Brng As Range
  
  Set dA = CreateObject("Scripting.Dictionary")
  Set dB = CreateObject("Scripting.Dictionary")
  With Sheets("Tab A")
    a = .Range("A2", .Range("C" & Rows.Count).End(xlUp)).Value
    Headings = .Range("A1:C1").Value
  End With
  For i = 1 To UBound(a)
    dA(a(i, 1)) = dA(a(i, 1)) + 1
  Next i
  With Sheets("Tab B")
    Set Brng = .Range("A1", .Range("C" & Rows.Count).End(xlUp))
    b = Brng.Value
  End With
  For i = 2 To UBound(b)
    dB(b(i, 1)) = dB(b(i, 1)) + 1
  Next i
  Application.ScreenUpdating = False
  With Sheets("Tab C")
    .Range("A:C, J:L").ClearContents
    .Range("A1:C1").Value = Headings
    .Range("J1:L1").Value = Headings
    .Range("A2").Resize(UBound(a), UBound(a, 2)).Value = a
    r = 2
    Do
      itm = .Cells(r, 1).Value
      If dB.Exists(itm) Then
        Brng.AutoFilter Field:=1, Criteria1:=itm
        Brng.Offset(1).Copy Destination:=.Cells(r, "J")
        If dB(itm) > dA(itm) Then .Cells(r + dA(itm), 1).Resize(dB(itm) - dA(itm)).Insert Shift:=xlDown
        r = r + IIf(dB(itm) > dA(itm), dB(itm), dA(itm))
        dB.Remove itm
      Else
        r = r + dA(itm)
      End If
      dA.Remove itm
    Loop Until dA.Count = 0
    If dB.Count > 0 Then
      For Each itm In dB.Keys()
        Brng.AutoFilter Field:=1, Criteria1:=itm
        Brng.Offset(1).Copy Destination:=.Cells(r, "J")
        r = r + dB(itm)
      Next itm
    End If
  End With
  Brng.AutoFilter Field:=1
  Application.ScreenUpdating = True
End Sub
 
Upvote 0
It doesn't look like my reply posted yesterday. Thank you for your help Peter but unfortunately this does not seem to work. I would tweek it if I only knew what I was trying to tweek. I have not learned VBA yet.
 
Upvote 0
I was going to start a new thread, but maybe you are willing to take one more crack at it.

I already have the worksheet that fills in from my feeder worksheets. It looks like the first HTML I have posted with the following exceptions:

- The worksheet name is Comparison
- Cells A1:E1, G1:H1: and J1:N1 are merged and filled with heading type information
- Cells in row 2 are all sub heading type information
- Cells in rows 3 through 2500 are being pulled from feeder sheets

My new thought is to leave everything as is - I populate the two feeder worksheets that feed into the "Comparison" worksheet. I will then add a button to sort the items on the Comparison worksheet. The button will add blank partial rows of cells (either A:E or J:N) where the information isn't the same between column A and column J. The result would then look like the second HTML I posted. All information would need to remain though; just shifted down so columns A:J match.

If you are willing to give it one more go, I would appreciate it. Otherwise, I might through it back out to the community.

Thank you,

Rob
 
Upvote 0
chethead said:
I was going to start a new thread, ...
Click to expand...
Best not to do that - refer to number 12 of the Forum Rules and number 6 of the Forum Use Guidelines. :)


.. unfortunately this does not seem to work.
Click to expand...
That doesn't give us much to go on. ;)
In what way does it not work?
- Does nothing?
- Crashes Excel?
- Puts the right answer in the wrong place
- Puts the wrong answer (examples) in the right place
- etc


I think much of the problem is likely that I didn't have my test sheets set up quite right but some more clarification is needed in that regard.
See comments/questions in red below


chethead said:
- The worksheet name is Comparison OK, you really told us that before but I missed it

Which Sheet(s) do the following apply to?
- Cells A1:E1, G1:H1: and J1:N1 are merged and filled with heading type information
- Cells in row 2 are all sub heading type information
- Cells in rows 3 through 2500 are being pulled from feeder sheets
Click to expand...
 
Upvote 0
I have assumed that clicking 'Reply with Quote' to post 1 gives you the answer to that.
Click to expand...
Yeah, Looked at that but still wasn't certain what the OP was looking for ...:lol:
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Auto populate columns in one tab based on entries in another
Replies
6
Views
149
dermie_72
D
R
  • Question Question
Index Match in multiple tabs
Replies
1
Views
114
Domenic
D
S
  • Question Question
VBA Code that extracts multiple tabs at a time based on lookup tab
2
Replies
10
Views
572
NoSparks
N
W
  • Question Question
Formatting raw data with extra rows automatically added in-between records
Replies
1
Views
79
Peter_SSs
Peter_SSs
P
  • Solved
Hard Question - Chatbot failed with multpile attempts
Replies
3
Views
224
pban
P

Forum statistics

Threads
1,224,820
Messages
6,181,159
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