vba indexed search syntax

P

parkerbelt

Active Member
Joined
May 23, 2014
Messages
377
I have an Excel workbook that has a sheet that has a list of 500 stores numbered Store number 1, store number 7 store number 11, etc.. - these are my test stores. The store number is in column A. I'm calling this sheet "500 Test Stores". The sheet doesn't contain duplicate store numbers, it is an index if you will.

I have another Excel workbook that has a large list of store data, which includes store number in column A along with Sales data in a different column and Quantity on-hand in another column, and other data in other columns, etc.. I'm calling this sheet "Test Dump". This sheet contains multiple store numbers that are the same, because the data goes with different items that are sold at the same store.

I'm trying to write a program that will look at each cell in column A of the 500 Test Stores sheet and look for a match in the Test Dump sheet and if it finds a match, copy the row of data where the match is and paste it into a different tab that I call "Test Stores Data".
If the store number doesn't match, I want to copy the row of data into a tab called "All Other Stores Data".

I'm a bit inexperienced and rusty - and each time I try to create my loops, I keep duplicating data and the program is really in-efficient.
Does anyone know how to write the code so that my loop is efficient, it sorts the data like I want it to and it doesn't duplicate any data?

Here's what I've attempted, but it is going to duplicate data if allowed to run through:

HTML: 
Dim SearchStore As LongDim lastrow500 As LongDim lastrow As Long           Sheets("500 Test Stores").Select    lastrow500 = Cells(Rows.Count, "A").End(xlUp).Row        Sheets("Temp Dump").Select    lastrow = Cells(Rows.Count, "A").End(xlUp).Row    Dim i As Long        i = 2
Dim its As Long        its = 2
Dim iao As Long
    iao = 2
Dim itsl As Long        itsl = 2

' Start of loop for Test Stores

Do Until itsl = lastrow500 + 1
    Sheets("500 Test Stores").Select
    SearchStore = Range("A" & its).Value.Select        
    Do Until i = lastrow + 1
                Sheets("Temp Dump").Select            Range("A" & i).Select

        If Range("A" & i).Value = SearchStore Then            Rows(ActiveCell.Row).Select            Selection.Copy            Sheets("Test Stores Data").Select            Range("A" & i).Select            ActiveSheet.Paste            i = i + 1            its = its + 1                    Else            Rows(ActiveCell.Row).Select            Selection.Copy            Sheets("All Other Stores Data").Select            Range("A" & iao).Select            ActiveSheet.Paste            iao = iao + 1            i = i + 1                    End If            Loop
    itsl = itsl + 1    Loop
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Try this


Code: 
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
[COLOR=#0000ff]    Set sh1 = Sheets("500 Test Stores")[/COLOR]
[COLOR=#008000]    Set sh2 = Sheets("Test Dump")[/COLOR]
[COLOR=#800000]    Set sh3 = Sheets("Test Stores Data")[/COLOR]
[COLOR=#800080]    Set sh4 = Sheets("All Other Stores Data")[/COLOR]
    
    For Each c In sh1.Range("A2", sh1.Range("A" & Rows.Count).End(xlUp))
        Set f = sh2.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
[COLOR=#008000]            sh2.Rows(f.Row).Copy [/COLOR][COLOR=#800000]sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)[/COLOR][COLOR=#008000][/COLOR]
        Else
[COLOR=#0000ff]            sh1.Rows(c.Row).Copy [/COLOR][COLOR=#800080]sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)[/COLOR][COLOR=#0000ff][/COLOR]
        End If
    Next
    MsgBox "Done"
End Sub
 
Upvote 0
I'm getting Run-Time error '9':
Subscript out of range and this line is where it stopped:
Set sh2 = Sheets("Test Dump")


Not sure why
DanteAmor said:
Try this


Code: 
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
[COLOR=#0000ff]    Set sh1 = Sheets("500 Test Stores")[/COLOR]
[COLOR=#008000]    Set sh2 = Sheets("Test Dump")[/COLOR]
[COLOR=#800000]    Set sh3 = Sheets("Test Stores Data")[/COLOR]
[COLOR=#800080]    Set sh4 = Sheets("All Other Stores Data")[/COLOR]
    
    For Each c In sh1.Range("A2", sh1.Range("A" & Rows.Count).End(xlUp))
        Set f = sh2.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
[COLOR=#008000]            sh2.Rows(f.Row).Copy [/COLOR][COLOR=#800000]sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)[/COLOR]
        Else
[COLOR=#0000ff]            sh1.Rows(c.Row).Copy [/COLOR][COLOR=#800080]sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)[/COLOR]
        End If
    Next
    MsgBox "Done"
End Sub
Click to expand...
 
Upvote 0
Your code worked to find a match and to put one line of data from the match into the Test Stores Data tab, but it didn't put the other rows of data from the other item numbers in there.

It also didn't put any non-matches data into the All Other Stores Data tab.

Thanks though!

DanteAmor said:
Try this


Code: 
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
[COLOR=#0000ff]    Set sh1 = Sheets("500 Test Stores")[/COLOR]
[COLOR=#008000]    Set sh2 = Sheets("Test Dump")[/COLOR]
[COLOR=#800000]    Set sh3 = Sheets("Test Stores Data")[/COLOR]
[COLOR=#800080]    Set sh4 = Sheets("All Other Stores Data")[/COLOR]
    
    For Each c In sh1.Range("A2", sh1.Range("A" & Rows.Count).End(xlUp))
        Set f = sh2.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
[COLOR=#008000]            sh2.Rows(f.Row).Copy [/COLOR][COLOR=#800000]sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)[/COLOR]
        Else
[COLOR=#0000ff]            sh1.Rows(c.Row).Copy [/COLOR][COLOR=#800080]sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)[/COLOR]
        End If
    Next
    MsgBox "Done"
End Sub
Click to expand...
 
Upvote 0
parkerbelt said:
Your code worked to find a match and to put one line of data from the match into the Test Stores Data tab, but it didn't put the other rows of data from the other item numbers in there.

It also didn't put any non-matches data into the All Other Stores Data tab.

Thanks though!
Click to expand...


You can paste a sample of your data from the sheets

("500 Test Stores")
("Temp Dump")
 
Upvote 0
DanteAmor said:
You can paste a sample of your data from the sheets

("500 Test Stores")
("Temp Dump")
Click to expand...

Below is the information that you requested. If the store number is in the 500 Test Stores list, I want to copy all of the rows for that store from the Temp Dump tab and put the data in the Test Stores Data tab. If the store number is not in the 500 Test Stores list, I want to copy all of the rows for that store from the Temp Dump tab and put the data in the All Other Stores Data tab.

500 Test Stores Sample:
[TABLE="width: 513"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Store Nbr[/TD]
[TD]Store Name[/TD]
[TD]City[/TD]
[TD]State[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS, AR[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME AR[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]WEST PLAINS MO[/TD]
[TD]WEST PLAINS[/TD]
[TD]MO[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD]POPLAR BLUFF MO[/TD]
[TD]POPLAR BLUFF[/TD]
[TD]MO[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD]PRYOR OK[/TD]
[TD]PRYOR[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD]MANHATTAN KS[/TD]
[TD]MANHATTAN[/TD]
[TD]KS[/TD]
[/TR]
[TR]
[TD="align: right"]41[/TD]
[TD]BARTLESVILLE OK[/TD]
[TD]BARTLESVILLE[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD="align: right"]45[/TD]
[TD]JONESBORO AR[/TD]
[TD]JONESBORO[/TD]
[TD]AR[/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[TD]BOLIVAR MO[/TD]
[TD]BOLIVAR[/TD]
[TD]MO[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD]RUSSELLVILLE AR[/TD]
[TD]RUSSELLVILLE[/TD]
[TD]AR



[/TD]
[/TR]
</tbody>[/TABLE]



Temp Dump Sample:

[TABLE="width: 3469"]
<colgroup><col><col span="3"><col><col span="2"><col><col><col span="7"><col span="8"></colgroup><tbody>[TR]
[TD]Store Nbr[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip Code[/TD]
[TD]Prime Item Nbr[/TD]
[TD]Prime Item Desc[/TD]
[TD]UPC[/TD]
[TD]Vendor Name[/TD]
[TD]Acct Dept Nbr[/TD]
[TD]Dept Category Description[/TD]
[TD]Dept Subcategory Description[/TD]
[TD]MDSE Category INTL[/TD]
[TD]Fineline Number[/TD]
[TD]Fineline Description[/TD]
[TD]Building Address[/TD]
[TD]Data Type[/TD]
[TD]201908[/TD]
[TD]201909[/TD]
[TD]201910[/TD]
[TD]201911[/TD]
[TD]201912[/TD]
[TD]201913[/TD]
[TD]201914[/TD]
[TD]201916[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]POS Sales[/TD]
[TD="align: right"]19.94[/TD]
[TD="align: right"]39.88[/TD]
[TD="align: right"]29.91[/TD]
[TD="align: right"]19.94[/TD]
[TD="align: right"]39.88[/TD]
[TD="align: right"]9.97[/TD]
[TD="align: right"]39.88[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]POS Qty[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str On Hand Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str On Order Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str In Transit Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str In Whse Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Avg Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]POS Sales[/TD]
[TD="align: right"]39.68[/TD]
[TD="align: right"]19.84[/TD]
[TD="align: right"]19.84[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]59.52[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]39.68[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]POS Qty[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str On Hand Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str On Order Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str In Transit Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str In Whse Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Avg Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]POS Sales[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]22.88[/TD]
[TD="align: right"]22.88[/TD]
[TD="align: right"]28.6[/TD]
[TD="align: right"]17.16[/TD]
[TD="align: right"]17.16[/TD]
[TD="align: right"]28.6[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]POS Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str On Hand Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str On Order Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str In Transit Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Str In Whse Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Avg Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ROGERS[/TD]
[TD]AR[/TD]
[TD]72756[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]2110 W WALNUT ST[/TD]
[TD]Curr Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]POS Sales[/TD]
[TD="align: right"]329.01[/TD]
[TD="align: right"]239.28[/TD]
[TD="align: right"]418.74[/TD]
[TD="align: right"]319.04[/TD]
[TD="align: right"]219.34[/TD]
[TD="align: right"]289.13[/TD]
[TD="align: right"]358.92[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]POS Qty[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str On Hand Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]194[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str On Order Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str In Transit Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str In Whse Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Avg Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]1149131[/TD]
[TD]RIDX 19.6OZ POWDER[/TD]
[TD]0001920080307[/TD]
[TD]RB USA HOLDINGS LLC[/TD]
[TD="align: right"]11[/TD]
[TD]PLUMBING[/TD]
[TD]CHEMICALS[/TD]
[TD]POWER TOOLS[/TD]
[TD]103[/TD]
[TD]Septic Chemicals[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]POS Sales[/TD]
[TD="align: right"]19.84[/TD]
[TD="align: right"]19.84[/TD]
[TD="align: right"]39.68[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]79.36[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]POS Qty[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str On Hand Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str On Order Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str In Transit Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str In Whse Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Avg Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]567066733[/TD]
[TD]MS SN SP SAVER W LNR[/TD]
[TD]0088952621579[/TD]
[TD]IMPORT-TESTRITE INTERNATIONAL[/TD]
[TD="align: right"]11[/TD]
[TD]BATH DECOR[/TD]
[TD]BATH FURNITURE[/TD]
[TD]BATH DECOR[/TD]
[TD]6008[/TD]
[TD]OPP Space Savers[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]POS Sales[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11.44[/TD]
[TD="align: right"]68.64[/TD]
[TD="align: right"]68.64[/TD]
[TD="align: right"]28.6[/TD]
[TD="align: right"]57.2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]POS Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str On Hand Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str On Order Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str In Transit Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Str In Whse Qty[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Avg Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]MOUNTAIN HOME[/TD]
[TD]AR[/TD]
[TD]72653[/TD]
[TD="align: right"]571189411[/TD]
[TD]MS RND WHT WOOD[/TD]
[TD]0694294590008[/TD]
[TD]IMPORT-NINGBO BOFAN SANITARY W[/TD]
[TD="align: right"]11[/TD]
[TD]TOILET SEATS[/TD]
[TD]ROUND[/TD]
[TD]TOILET SEATS[/TD]
[TD]6230[/TD]
[TD]ROUND WOOD SEATS[/TD]
[TD]65 WAL MART DR[/TD]
[TD]Curr Repl Instock %[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
parkerbelt said:
If the store number is in the 500 Test Stores list, I want to
copy all of the rows for that store from the Temp Dump tab and put the data in the Test Stores Data tab.

If the store number is not in the 500 Test Stores list, I want to
copy all of the rows for that store from the Temp Dump tab and put the data in the All Other Stores Data tab.
Click to expand...

Try this please.

Code: 
Sub search_numbers()
    Dim sh1 As Worksheet, sh2 As Worksheet, sh3 As Worksheet, sh4 As Worksheet
    
    Set sh1 = Sheets("500 Test Stores")
    Set sh2 = Sheets("Temp Dump")
    Set sh3 = Sheets("Test Stores Data")
    Set sh4 = Sheets("All Other Stores Data")
    
    sh3.Rows("2:" & Rows.Count).ClearContents
    sh4.Rows("2:" & Rows.Count).ClearContents
    For Each c In sh2.Range("A2", sh2.Range("A" & Rows.Count).End(xlUp))
        Set f = sh1.Range("A:A").Find(c.Value, LookIn:=xlValues, lookat:=xlWhole)
        If Not f Is Nothing Then
            sh2.Rows(f.Row).Copy sh3.Range("A" & sh3.Rows.Count).End(xlUp)(2)
        Else
            sh2.Rows(c.Row).Copy sh4.Range("A" & sh4.Rows.Count).End(xlUp)(2)
        End If
    Next
    MsgBox "Done"
End Sub
 
Upvote 0
I was running my program, the code that I had written and got hung in a loop, so I ended excel using task manager and now Excel is telling me "Because of your security settings, macros have been disabled." and when I try to go into the Trust Center, the option to enable macros is greyed out and I can't turn it back on to try your code. Do you know of a way to turn the option back on? I'm going to make a post on this forum for that. When I get this back up and running, I'll try your code and reply. Thanks!
 
Upvote 0
parkerbelt said:
I was running my program, the code that I had written and got hung in a loop, so I ended excel using task manager and now Excel is telling me "Because of your security settings, macros have been disabled." and when I try to go into the Trust Center, the option to enable macros is greyed out and I can't turn it back on to try your code. Do you know of a way to turn the option back on? I'm going to make a post on this forum for that. When I get this back up and running, I'll try your code and reply. Thanks!
Click to expand...


How many records do you have on the "temp dump" sheet?
 
Upvote 0
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Question Question
Comments on macro to help solve the problem of Excel changing column widths
2
Replies
11
Views
413
JenniferMurphy
JenniferMurphy
N
  • Question Question
Getting Data from a Cell Then Changing the Data Finally Putting it in the Same Cell
Replies
1
Views
48
Jeffrey Mahoney
Jeffrey Mahoney
M
  • Solved
VBA Chart Series title with multiple cells
Replies
4
Views
141
mikejvir
M
G
  • Solved
Variable not storing value
2
Replies
14
Views
578
Gadgetgav
G
J
  • Question Question
vba to find specific text in a column and then when found copy all the rows above it
Replies
1
Views
227
mumps
mumps

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,021
Latest member
Mohamed Magdi Tawfiq Emam

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