Comparison of two sheets

S

sambradley

New Member
Joined
Jul 21, 2017
Messages
5
Hi,
So I am creating an inventory workbook, which I receive my inventory data from a POS system that allows me to export to Excel.

What I am trying to do is automate a process that compares one report to another report(ran a couple days later) and allow it to tell me which products are not in my new report(they have been sold) or any products in new report that wasn't in my older report(we added inventory).

I tried using VLOOKUP and use the SKU's as the LookupValue but the report has duplicate SKU's so that is not working for me. Also not sure VLOOKUP will even be what I need.

I hope someone can help me out! I would also like everything in a macro!

My explanation of what I need may be confusing, and I can clear-up anything if needed!

Thanks.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
.
Paste into a Routine Module :

Code: 
Option Explicit
Sub Compare()
'
' Macro1 Macro
'
' compare two different worksheets in the active workbook
  CompareWorksheets Worksheets("Sheet1"), Worksheets("Sheet2")
End Sub
 
Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
  Dim dupRow As Boolean
  Dim r As Long, c As Integer, m As Integer
  Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer, lr3 As Long
  Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
  Dim dupCount As Long
  Dim DiffCount As Integer
  Dim i As Integer
  Dim t As Integer
  
  
  Application.ScreenUpdating = False
  Application.StatusBar = "Creating the report..."
  Application.DisplayAlerts = True
  With ws1.UsedRange
    lr1 = .Rows.Count
    lc1 = .Columns.Count
  End With
  With ws2.UsedRange
    lr2 = .Rows.Count
    lc2 = .Columns.Count
  End With
  maxR = lr1
  maxC = lc1
  If maxR < lr2 Then maxR = lr2
  If maxC < lc2 Then maxC = lc2
  DiffCount = 0
  lr3 = 1
  For i = 1 To lr1
    dupRow = True
    Application.StatusBar = "Comparing worksheets " & Format(i / maxR, "0 %") & "..."
    For r = 1 To lr2
        For c = 1 To maxC
            ws1.Select
            cf1 = ""
            cf2 = ""
            On Error Resume Next
            cf1 = ws1.Cells(i, c).FormulaLocal
            cf2 = ws2.Cells(r, c).FormulaLocal
            On Error GoTo 0
            If cf1 <> cf2 Then
                dupRow = False
                Exit For
            Else
                dupRow = True
            End If
        Next c
        If dupRow Then
         Exit For
        End If
     Next r
       If Not dupRow Then
        dupCount = dupCount + 1
        ws1.Range(ws1.Cells(i, 1), ws1.Cells(i, maxC)).Select
        Selection.Copy
        Worksheets("Sheet3").Select
        Worksheets("Sheet3").Range(Worksheets("Sheet3").Cells(lr3, 1), Worksheets("Sheet3").Cells(lr3, maxC)).Select
        Selection.PasteSpecial
        lr3 = lr3 + 1
        ws1.Select
        For t = 1 To maxC
            ws1.Cells(i, t).Interior.ColorIndex = 19
            
            Selection.Font.Bold = True
        Next t
     End If
    Next i
Application.StatusBar = "Formatting the report..."


m = dupCount
Application.StatusBar = False
Application.ScreenUpdating = True
MsgBox m & " Rows contain different values!", vbInformation, _
"Compare " & ws1.Name & " with " & ws2.Name
End Sub

WS1 = Your new report
WS2 = Your old (previous) report
Sheet3 = The differences between the two sheets is printed out here. This is your discrepancy report.

Difference row data is highlighted in WS1

Paste this data in Sheet1:



[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Location[/TD]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[TD]Item 5[/TD]
[TD]Item 6[/TD]
[TD]Item 7[/TD]
[TD]Item 8[/TD]
[TD]Item 9[/TD]
[TD]Item 10[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 1[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 2[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 3[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 4[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 5[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 6[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 7[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 8[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 9[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 10[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 11[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 12[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 13[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 14[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 15[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 16[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 17[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 18[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 19[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 20[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 21[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 22[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 23[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 24[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 25[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[/TR]
</tbody>[/TABLE]



Paste this into Sheet 2:

Excel 2007 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Location[/TD]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[TD]Item 5[/TD]
[TD]Item 6[/TD]
[TD]Item 7[/TD]
[TD]Item 8[/TD]
[TD]Item 9[/TD]
[TD]Item 10[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 1[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 2[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 3[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 4[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 5[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 6[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 7[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 8[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 9[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 10[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 11[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 12[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 13[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 14[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 15[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 16[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 17[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
5​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 18[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 19[/TD]
[TD]
4​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
3​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 20[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 21[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 22[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
5​
[/TD]
[TD]
2​
[/TD]
[TD]
4​
[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
0​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 23[/TD]
[TD]
2​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
1​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 24[/TD]
[TD]
4​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
1​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Store 25[/TD]
[TD]
5​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
0​
[/TD]
[TD]
3​
[/TD]
[TD]
2​
[/TD]
[TD]
0​
[/TD]
[TD]
1​
[/TD]
[/TR]
</tbody>[/TABLE]


Then run the macro.
 
Upvote 0
.
Duplicate post.
 
Last edited:
Upvote 0
Wow!! Excellent, works perfectly!

Thanks so much for your help!

This took a lot of looping, which is not my strongsuit! Lol

Thanks again Logit
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
VLOOKUP (or VBA Alternative?) From another workbook, depending on Financial Year
Replies
2
Views
460
paun_shotts
P
B
  • Solved
VBA Help - Same Function needed for multiple sheets
Replies
2
Views
572
birdman15
B
S
  • Question Question
Excel VBA - Sort & Get Totals - Logic
Replies
4
Views
352
STARL0RD
S
B
  • Solved
Vlookup or IF Function...HELP!
Replies
3
Views
502
barkpi1597532
B
B
  • Solved
VBA Loop for data transfer
Replies
6
Views
340
Joe4
Joe4

Forum statistics

Threads
1,223,716
Messages
6,174,069
Members
452,542
Latest member
Bricklin

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