Summarization of a master Stock count / Inventory report, to produce several smaller reports.

warrima · Aug 3, 2020

I have a stock count sheet with all the material we have in our warehouse. Once a month i do a stock count against the month starting total. I then go through each variance and write down what jobs used how much in a column ie 53067 (2) 53297 (3) and so one down the list. List is about 500 items long and typically there is around 10 -15 jobs open a month. Report is sent to buyers.

A summarized version then needs created for finance that then lists all the material used against each job separately. They then add cost data etc. Currently i compile the second report manually from the first. However its time consuming and easy to make mistakes.

I've tried using pivot tables but i cant get them to work. Im open to changing the main report but any changes would need to be easily reversible as the format is a standard that is used. Are there any formula that can help me with this. Ive played around with vlookup and match but having limited success.

Many thanks for any suggestions

mrshl9898 · Aug 3, 2020

If you added a column for each Job, 53152, 53296 etc and had the quantities against the rows 1,2 etc then you could Pivot that and keep your original table. Could even get a formula or VBA to populate the JN column to save time typing that out.

warrima · Aug 3, 2020

Hi mrshi9898 - Do u mean something like this below. i was playing around with that. Some parts are used on up to 6 or 7 jobs. still cant get a pivot to make sense. Or do you mean the qty in another separate column

mrshl9898 · Aug 3, 2020

Sorry, had a blank. To Pivot it you'd need the data like this, with a new line for each Order, so maybe not suitable.

No.	Description	Type	SIZE	Qty	Count	JN	Qty
142	1-12"	Round Bar	12'	69.5	69.5
143	1-1/4"	Round Bar	12'	29	22.5	53152	5
143	1-1/4"	Round Bar	12'	29	22.5	53296	0.5
143	1-1/4"	Round Bar	12'	29	22.5	53067	1
144	1-1/4"	Round Bar	12'	33	31	53296	2
145	1-1/8"	Round Bar	12'	33	33

What I was suggesting originally looked like this:

No.	Description	Type	SIZE	Qty	Count	53152	53296	53067
142	1-12"	Round Bar	12'	69.5	69.5
143	1-1/4"	Round Bar	12'	29	22.5	5	0.5	1
144	1-1/4"	Round Bar	12'	33	31		2
145	1-1/8"	Round Bar	12'	33	33

Is the first suggestion ok? If not is the second?

warrima · Aug 4, 2020

Hi ok ive altered my latest report to reflect the second version. Have you any idea though how to structure the pivot to try and replicate the 'used' report i need for finance. Ive tried discription and type in the columns and the jobs as values but it gives me something similar to the main table.

mrshl9898 · Aug 4, 2020

Ok, so if set out as per the 2nd example. And "No." is in A1 then try this code.

VBA Code:

Sub CreateSummary()

Dim rownum As Long
Dim colnum As Long
Dim rownum2 As Long
Dim ws As Worksheet
Dim ws2 As Worksheet
Dim lastrow As Long
Dim lastcol As Long

Application.DisplayAlerts = False

For Each Sheet In ThisWorkbook.Worksheets
    If Sheet.Name = "FinanceSummary" Then
        Sheet.Delete
    End If
Next

Set ws = ActiveSheet  --Best to change this to Set ws = Sheets("nameofyoursheetwiththedata")
Sheets.Add.Name = "FinanceSummary"
Set ws2 = Sheets("FinanceSummary")

lastrow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
lastcol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
rownum = 2
colnum = 7
rownum2 = 2

ws.Range("A1:F1").Copy ws2.Range("B1")
ws2.Range("A1") = "JN"
ws2.Range("H1") = "Qty. Used"

Do Until rownum = lastrow + 1
    Do Until colnum = lastcol + 1
        If ws.Cells(rownum, colnum) <> "" Then
            ws.Range(ws.Cells(rownum, 1), ws.Cells(rownum, 6)).Copy ws2.Cells(rownum2, 2)
            ws2.Cells(rownum2, 8) = ws.Cells(rownum, colnum)
            ws2.Cells(rownum2, 1) = ws.Cells(1, colnum)
            rownum2 = rownum2 + 1
        End If
    colnum = colnum + 1
    Loop
colnum = 7
rownum = rownum + 1
Loop
       
Application.DisplayAlerts = True

End Sub

Turning this:

No.	Description	Type	SIZE	Qty	Count	53152	53296	53067
142	1-12"	Round Bar	12'	69.5	69.5
143	1-1/4"	Round Bar	12'	29	22.5	5	0.5	1
144	1-1/4"	Round Bar	12'	33	31		2
145	1-1/8"	Round Bar	12'	33	33

Into this

JN	No.	Description	Type	SIZE	Qty	Count	Qty. Used
53152	143	1-1/4"	Round Bar	12'	29	22.5	5
53296	143	1-1/4"	Round Bar	12'	29	22.5	0.5
53067	143	1-1/4"	Round Bar	12'	29	22.5	1
53296	144	1-1/4"	Round Bar	12'	33	31	2

mrshl9898 · Aug 4, 2020

Or use the below to turn this

No.	Description	Type	SIZE	Qty	Count	JN	53152	53296	53067
142	1-12"	Round Bar	12'	69.5	69.5
143	1-1/4"	Round Bar	12'	29	22.5		5	0.5	1
144	1-1/4"	Round Bar	12'	33	31			2
145	1-1/8"	Round Bar	12'	33	33

Into this

No.	Description	Type	SIZE	Qty	Count	JN	53152	53296	53067
142	1-12"	Round Bar	12'	69.5	69.5
143	1-1/4"	Round Bar	12'	29	22.5	53152 (5) 53296 (0.5) 53067 (1)	5	0.5	1
144	1-1/4"	Round Bar	12'	33	31	53296 (2)		2
145	1-1/8"	Round Bar	12'	33	33

and

JN	No.	Description	Type	SIZE	Qty	Count	Qty. Used
53152	143	1-1/4"	Round Bar	12'	29	22.5	5
53296	143	1-1/4"	Round Bar	12'	29	22.5	0.5
53067	143	1-1/4"	Round Bar	12'	29	22.5	1
53296	144	1-1/4"	Round Bar	12'	33	31	2

VBA Code:

Public lastrow As Long
Public lastcol As Long
Public ws As Worksheet
Public rownum As Long
Public colnum As Long

Sub CreateSummary()

Dim rownum2 As Long
Dim ws2 As Worksheet

Application.DisplayAlerts = False

For Each Sheet In ThisWorkbook.Worksheets
    If Sheet.Name = "FinanceSummary" Then
        Sheet.Delete
    End If
Next

Set ws = ActiveSheet
Sheets.Add.Name = "FinanceSummary"
Set ws2 = Sheets("FinanceSummary")

lastrow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
lastcol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
rownum = 2
colnum = 8
rownum2 = 2

ws.Range("A1:F1").Copy ws2.Range("B1")
ws2.Range("A1") = "JN"
ws2.Range("H1") = "Qty. Used"

Do Until rownum = lastrow + 1
    Do Until colnum = lastcol + 1
        If ws.Cells(rownum, colnum) <> "" Then
            ws.Range(ws.Cells(rownum, 1), ws.Cells(rownum, 6)).Copy ws2.Cells(rownum2, 2)
            ws2.Cells(rownum2, 8) = ws.Cells(rownum, colnum)
            ws2.Cells(rownum2, 1) = ws.Cells(1, colnum)
            rownum2 = rownum2 + 1
        End If
    colnum = colnum + 1
    Loop
colnum = 7
rownum = rownum + 1
Loop
        
Application.DisplayAlerts = True

FillinJN

End Sub


Sub FillinJN()

rownum = 2
colnum = 8

Do Until rownum = lastrow + 1
    Do Until colnum = lastcol + 1
        If ws.Cells(rownum, colnum) <> "" Then
            ws.Cells(rownum, 7) = ws.Cells(rownum, 7) & ws.Cells(1, colnum) & " (" & ws.Cells(rownum, colnum) & ") "
        End If
    colnum = colnum + 1
    Loop
colnum = 7
rownum = rownum + 1
Loop

End Sub

warrima · Aug 4, 2020

Many many thanks this appears to be getting me somewhere. Apologies i dont know much about code and appear to be messing it up altering it. My worksheet is called Raw Material Inventory.

mrshl9898 · Aug 5, 2020

Try this:

If it doesn't quite work then paste some sample data in that I can copy instead of pasting a picture of it.

VBA Code:

Public lastrow As Long
Public lastcol As Long
Public ws As Worksheet
Public rownum As Long
Public colnum As Long

Sub CreateSummary()

Dim rownum2 As Long
Dim ws2 As Worksheet

Application.DisplayAlerts = False

For Each Sheet In ThisWorkbook.Worksheets
    If Sheet.Name = "FinanceSummary" Then
        Sheet.Delete
    End If
Next

Set ws = Sheets("Raw Material Inventory")
Sheets.Add.Name = "FinanceSummary"
Set ws2 = Sheets("FinanceSummary")

lastrow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
lastcol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
rownum = 3
colnum = 9
rownum2 = 2

ws.Range("A1:H1").Copy ws2.Range("B1")
ws2.Range("A1") = "JN"
ws2.Range("I1") = "Qty. Used"

Do Until rownum = lastrow + 1
    Do Until Cells(2, colnum).Value = "Used at Saw/Job"
        If ws.Cells(rownum, colnum) <> "" Then
            ws.Range(ws.Cells(rownum, 1), ws.Cells(rownum, 8)).Copy ws2.Cells(rownum2, 2)
            ws2.Cells(rownum2, 10) = ws.Cells(rownum, colnum)
            ws2.Cells(rownum2, 1) = ws.Cells(1, colnum)
            rownum2 = rownum2 + 1
        End If
    colnum = colnum + 1
    Loop
colnum = 9
rownum = rownum + 1
Loop
        
Application.DisplayAlerts = True

''FillinJN

End Sub

warrima · Aug 5, 2020

Ah ok sure. Many thanks

	Raw Material Inventory	Date :			31-Jul-20		JN1	JN2	JN3	JN4	JN5	JN6	JN7	JN8	JN9	JN10	JN11	JN12	JN13	JN14	JN15	JN16	JN17	JN18	JN19	JN20	JN21	JN22	JN23	JN24	Unresolved Check count (ok if green)	0
No.	Description	Type	SIZE	Loc.	Qty.	Calc Count (Verify Only)	Count	5241	5244	52827	53067	53152	53196	53199	53202	53212	53216	53238	53240	53245	53249	53269	53270	53275	53276	53286	53287	53288	53293	53296	53297	Used At Saw/Job	Status	Weight (#) Each	Total Weight	Value Each*	Price Per Pound	Total	Invoice number	Invoice Date	Exchange Rate	Total	qty ordered	product usage
-2	14" x 6" x 3/8"	ASTM A500 Gr B Tube	20'(check 185-5/8" next)	1B	18	18	18																									0	OK	958.00	17,244.0	$708.80	$0.7399	$12,758.40	829THI-1(27184)817THI-8(27003)817THI-7(26981)817THI-5(26816)	multi	31.48966538	฿401,757.75	1	E28502
-1	14" x 6" x 1/4" (multi)	ASTM A500 (Q345) Tube	17'-22'	1B, 2B, 14D,15D,16D	113.7	112	112			0.7																					1	1.7	OK	811.48	90,886.2	$242.43	$0.2988	$27,152.43	#REF!	multi	31.40662448	฿852,766.04	15	E175,E176,E240,E259,E262,E28502
0	12" x 8" x 3/8"	ASTM A500 Gr B Tube	20'	2D	1.3	1.3	1.3																									0	OK	958.00	1245.4	$1,576.75	$1.6459	$2,049.78	571	11-May-11	29.922	฿61,333.37
1	12" x 8" x 1/4"	ASTM A500 Gr B Tube	20'	2C	2.5	2.5	2.5																									0	OK	652.60	1631.5	$217.62	$0.3335	$544.06	778THI	10-Apr-18	31.0702	฿16,903.90		AM-2718
2	12" x 6" x 3/8" (multi)	ASTM A500 Gr B Tube	18' to 20'	14A,14B	40	40	40																									0	OK	788.19	31,527.7	$341.17	$0.4329	$13,646.89	multi	multi	31.25812643	฿426,576.36	32	E175, E281,E20801
3	12" x 6" x 1/4" (6mm)(MAL)	ASTM A500 Gr B Tube	20'	12D,13C,D	47	45	45																		2							2	OK	584.60	26,307.0	$223.53	$0.3824	$10,058.91	multi	multi	30.56196495	฿307,420.02	22	956A7644,102716,E082,E240,E248,E259,E262,E272,E277,AM-2228,AM-2811
4	12" x 4" x 1/2"	ASTM A500 Gr B Tube	20'	3D	2.5	2.5	2.5																									0	OK	977.00	2,442.5	$723.00	$0.7400	$1,807.50	817THI-4(26816)	31-Jan-19	31.0788	฿56,174.93		E28175
5	12" x 4" x 3/8" (multi)	ASTM A500 (Q345) Tube	14' to 24.5'	10C,11C	52	52	52																									0	OK	742.49	38,609.6	$308.54	$0.4155	$16,043.92	multi	multi	31.3558942	฿503,071.59	36	AM-1802,??AM-2563??,AM-2811,??E237??,E248,E281,E285
6	12" x 4" x 1/4"(6mm Tianjin)	ASTM A500 (Q345) Tube	16'-20'	2A,10D,11D	77	71	71																3			3						6	OK	464.76	32,998.0	$203.62	$0.4381	$14,457.06	multi	multi	31.99415938	฿462,541.57	62	AM-1802,AM-2563,E18602,E237,E248
7	12" x 3" x 1/4"	ASTM A500 Gr B Tube	80-5/8"	2A, 4B	17	17	17																									0	OK	162.04	2,754.7	$207.00	$1.2774	$3,519.01	multi	multi	31.85039038	฿112,081.87	8	E17502-7/-9
8	12" x 2" x 1/4"	ASTM A500 Gr B Tube	20'	5C	0.6	0.6	0.6																									0	OK	448.40	269.0	$299.29	$0.6675	$179.57	multi	multi	31.10105463	฿5,584.86	2	E107,E281
9	10" x 10" x 3/8"	ASTM A500 Gr B Tube	20'	1C	4.8	4.8	4.8																									0	OK	958.00	4,598.4	$621.12	$0.6483	$2,981.37	multi	multi	$30.50	฿90,929.70	5	956A7644 (80" per cradle/set)
10	10" x 6" x 1/2"	ASTM A500 Gr B Tube	18'	2C	1	1	1																									0	OK	879.30	879.3	$306.95	$0.3491	$306.95	700THI	19-Sep-16	34.7028	฿10,652.02
11	10" x 6" x 1/4"	ASTM A500 Gr B Tube	20'(check 141")	2C	1	1	1																									0	OK	516.40	516.4	$246.64	$0.4776	$246.64	854THI(28190)	10-Oct-19	30.1362	฿7,432.79		9C6001(9426M22), E13301
12	10" x 4" x 1/2"	ASTM A500 Gr B Tube	124-5/8"	3C	8	8	8																									0	OK	436.71	3,493.7	$254.13	$0.5819	$2,033.05	733THI	23-Jun-17	33.8158	฿68,749.14		E203
13	10" x 4" x 1/4"(6mm Tianjin)	ASTM A500 (Q345) Tube	16'-20'	7C,7D	55	50	50																1			2		2				5	OK	403.56	20,178.0	$160.52	$0.3978	$8,025.89	multi	multi	32.23248104	฿258,694.31	68	AM-1928,AM-2701,E166,E169,E175,E18602,E248
14	10" x 4" x 3/16"	ASTM A500 Gr B Tube	20'	3C	6	6	6																									0	OK	341.60	2,049.6	$253.40	$0.7418	$1,520.40	813THI(26623)	27-Dec-18	32.4077	฿49,272.67		E241
15	10" x 3" x 1/4"	ASTM A500 Gr B Tube	20'		0.5	0	0																								0.5	0.5	OK	414.40	0.0	$445.80	$1.0758	$0.00	780THI-3	4-May-18	31.4696	฿0.00		9C6001(9426M23)
16	10" x 2" x 3/16"	ASTM A500 Gr B Tube	20'		0	0	0																									0	OK	290.60	0.0	$252.00	$0.8672	$0.00	796THI-3(26020)	29-Aug-18	32.5065	฿0.00		AM-1802-300
17	9" x 5" x 1/2"	ASTM A500 Gr B Tube	20'	4C	25	25	25																									0	OK	841.00	21,025.0	$574.69	$0.6833	$14,367.25	705-1 THI	14-Dec-16	35.402	฿508,629.38		956A7644P154/P155
18	8" x 8" x 3/8"	ASTM A500 Gr B Tube	20'	2B	2	2	2																									0	OK	753.80	1,507.6	$489.20	$0.6490	$978.40	817THI-6(26920)	21-Feb-19	30.9701	฿30,301.15	6	E28502
19	8" x 8" x 1/4"	ASTM A500 Gr B Tube	23'	2D	1	1	1																									0	OK	593.00	593.0	$0.00	$0.3500	$0.00	700THI	19-Sep-16	34.7028	฿0.00		Found 1 in August count
20	8" x 6" x 1/2"	ASTM A500 Gr B Tube	20'	4C	3	3	3																									0	OK	841.00	2,523.0	$538.20	$0.6400	$1,614.60	586	23-Apr-12	30.7959	฿49,723.06		E20803
21	8" x 6" x 3/8"	ASTM A500 (Q345) Tube	18' to 20'	3B	7.3	7.3	7.3																									0	OK	641.83	4,685.3	$270.89	$0.4221	$1,977.48	multi	multi	31.48569301	฿62,262.33	6	AM-2811, S/B 18.5' per order
22	8" x 6" x 5/16"	ASTM A500 Gr B Tube	16' to 19'	2B, 3B	10	10	10																									0	OK	482.83	4,828.3	$237.18	$0.4912	$2,371.84	860THI(28590)	23-Dec-19	31.41597276	฿74,513.69	8	E107,E202
23	8" x 6" x 1/4"	ASTM A500 Gr B Tube	20'	3B	25	25	25																									0	OK	448.40	11,210.0	$239.53	$0.5342	$5,988.24	778THI	10-Apr-18	31.10603517	฿186,270.26		AM-1928,AM-2228,AM-2718
24	8" x 4" x 1/2"	ASTM A500 Gr B Tube	20'	4B	13.5	13.5	13.5																									0	OK	704.80	9,514.8	$422.19	$0.5990	$5,699.63	829THI-1(27184)817THI-8(27003)817THI-7(26981)817THI-4(26816)	multi	31.39787106	฿178,956.27	1	E184,E21509,E28514
25	8" x 4" x 3/8"	ASTM A500 Gr B Tube	20'	4B	18	18	18																									0	OK	549.60	9,892.8	$356.60	$0.6488	$6,418.80	829THI-1(27184)	multi	31.59545909	฿202,804.93	2	E281,E28514
26	8" x 4" x 1/4" (6mm)(MAL)	ASTM A500 Gr B Tube	6.1m(20')	14C,15C	146	144	144																		2							2	OK	380.40	54,777.6	$143.94	$0.3784	$20,726.77	PO 1912-080	multi transfers	32.32231396	฿669,937.17	123	986A7644,AM-2563,E107,E240,E259,E260,E262,E272,E277,E285
27	8" x 4" x 3/16"	ASTM A500 Gr B Tube	20'	4D	3	3	3																									0	OK	290.60	871.8	$187.53	$0.6453	$562.60	805THI-2(26414)618A pg 1	multi	32.41941792	฿18,239.16		E241
28	8" x 3" x 1/2"	ASTM A500 Gr B Tube	14'		0	0	0																									0	OK	445.76	0.0	$534.80	$1.1997	$0.00	810THI-1(26604)	20-Dec-18	32.5871	฿0.00		AM-2067M-401/-402
29	8" x 3" x 1/4" (TianJin)	Q345B-ASTM A500 Gr B/C Tube	5.98m(19.6')	8B, 13B	52	47	47																2.5					2.5				5	OK	346.40	16,280.8	$116.77	$0.3371	$5,488.18	Bank transfer	11-Oct-19	30.31104116	฿166,352.45	30	AM-2228,AM-2472,AM-2563,E169,E186,E237
30	8" x 3" x 3/16"	ASTM A500 Gr B Tube	20'	4D	7	7	7																									0	OK	265.00	1,855.0	$192.00	$0.7245	$1,344.00	581A	30-Jan-12	30.9059	฿41,537.53
31	8" x 2" x 1/4"	ASTM A500 Gr B Tube	18' to 20'	5C	1.5	1.5	1.5																									0	OK	312.40	468.6	$177.71	$0.5689	$266.56	multi	multi	30.82883769	฿8,217.85		E184,E215
32	8" x 2" x 3/16"	ASTM A500 Gr B Tube	20'		0	0	0																									0	OK	239.40	0.0	$155.80	$0.6508	$0.00	817THI-8(27003)	14-Mar-19	31.4869	฿0.00	5	AM-2718 (8x2x1/4 ok)
33	7" x 5" x 3/8"	ASTM A500 Gr B Tube	12'	2A	1	1	1																									0	OK	329.76	329.8	$165.00	$0.5004	$165.00	861THI(28716)	16-Jan-20	30.1091	฿4,968.00
34	7" x 5" x 1/4"	ASTM A500 Gr B Tube	20'	2C	4.7	4.7	4.7																									0	OK	380.40	1,787.9	$210.89	$0.5544	$991.21	708THI612A pg 1	multi	33.28952763	฿32,996.75
35	7" x 4" x 3/8" (China)	ASTM A500 (Q345) Tube	18' to 20'	11A	65	65	65																									0	OK	473.67	30,788.6	$203.42	$0.4295	$13,222.24	multi	multi	30.70481903	฿405,986.56	54	956A7644,E175
36	7" x 4" x 1/4" (Tianjin)	ASTM A500 (Q345) Tube	18' to 20'	9C	43	35	35													1.5											6.5	8	OK	346.40	12,124.0	$129.36	$0.3734	$4,527.60	multi	multi	30.50883454	฿138,131.80	75	9426M23, E108, E175
37	7" x 3" x 1/4"	ASTM A500 Gr B Tube	22'	5B	4.3	4.3	4.3																									0	OK	343.64	1,477.7	$256.78	$0.7472	$1,104.17	861THI(28716)	16-Jan-20	30.09069658	฿33,225.25	2	956A7644P02 (84" long per base)
38	6" x 6" x 1/2"	ASTM A500 Gr B Tube	20' (check 148")	2A	0.8	0.8	0.8																									0	OK	704.80	563.8	$0.00	$0.0000	$0.00	N/A	N/A	34.95	฿0.00		found in 2019 pre-audit count
39	6" x 6" x 3/8"	ASTM A500 (Q345) Tube	18' to 20'	7B	80	80	80																									0	OK	548.20	43,856.0	$210.31	$0.3836	$16,824.59	multi	multi	30.40086457	฿511,482.16	100	956A1618,956A7644,102716,E13201,E281,E285
40	6" x 6" x 1/4"	ASTM A500 Gr B Tube	20'	9B	0	0	0																									0	OK	380.40	0.0	$204.20	$0.5368	$0.00	772THI	16-Mar-18	31.0549	฿0.00		AM-2700,AM-2774-701,E082,E132,E166,E18401,E18424,E215,9C6001
41	6" x 4" x 1/2" (Tianjin)	ASTM A500 (Q345) Tube	6.0m(19.7')	11B	94.5	94.5	94.5																									0	OK	560.07	52,926.7	$215.98	$0.3856	$20,410.23	multi	multi	30.94947633	฿631,685.92	46	E108,E079,E082,E175,E176,E28514
42	6" x 4" x 3/8" (Tianjin)	ASTM A500 (Q345) Tube	18' to 20'	5C,6C,6D	95	90	90											5														5	OK	425.03	38,252.7	$178.82	$0.4207	$16,094.01	PO 2002-131 (partial 2)	multi	32.42987826	฿521,926.69	126	956A7644,102716,E082,E20801,E240,E248,E259,E262,E272,E277,AM-2228,AM-2811
43	6" x 4" x 1/4"	ASTM A500 Gr B Tube	18' to 20'	13A,13B	113.5	96	96											6		1	6				1						3.5	17.5	OK	296.78	28,490.9	$118.36	$0.3988	$11,362.23	multi	multi	31.57680456	฿358,782.96	162	AM-1928,AM-237108,E082,E108,E132,E175,E176,E203,E240,E241,E259,E262,E272
44	6" x 4" x 3/16"	ASTM A500 Gr B Tube	20'	2A	12	11.5	11.5		0.5																							0.5	OK	239.40	2,753.1	$144.61	$0.6040	$1,662.97	multi	multi	32.04319235	฿53,286.85		E241, E27604
45	6" x 3" x 3/8" (Jiade)	ASTM A500 (Q345) Tube	18' to 20'	5B	14	14	14																									0	OK	376.58	5,272.1	$177.33	$0.4709	$2,482.56	PO 2003-007	multi	32.13386172	฿79,774.14	16	102716,E203,E20801,E237,E281
46	6" x 3" x 1/4"(Tianjin)	ASTM A500 (Q345) Tube	18' to 20'	8B,8C	144	138	138																3		3							6	OK	264.29	36,472.0	$104.79	$0.3965	$14,460.44	PO 20-01-059	multi	32.29908402	฿467,059.09	56	956A7644,AM-1802,AM-1928,AM-2811,AM-2701,E108,E166,E18607,E17502
47	6" x 3" x 3/16"	ASTM A500 Gr B Tube	20'	5B	41	41	41																									0	OK	214.00	8,774.0	$103.65	$0.4843	$4,249.56	multi	multi	35.08308453	฿149,087.64		E24830
48	6" x 2" x 3/8" (Tianjin)	ASTM A500 (Q345) Tube	18' to 20'	16A	19	19	19																									0	OK	328.13	6,234.5	$147.73	$0.4502	$2,806.85	PO 2002-131 (partial 1)	multi	32.48616415	฿91,183.93	36	AM-2811
49	6" x 2" x 1/4" (Tianjin)	ASTM A500 (Q345) Tube	18' to 20'	8C	47	42	42								4.5									0.5								5	OK	231.99	9,743.6	$95.11	$0.4100	$3,994.61	PO 2002-131 (partial 1)	multi	32.48616415	฿129,769.64	58	AM-1802 ok,AM-2228,AM-2718 ok,C052,C069,E132,E20801,L03405
50	6" x 2" x 3/16"	ASTM A500 Gr B Tube	20'	5D	3	3	3																									0	OK	188.40	565.2	$94.00	$0.4989	$282.00	861THI(28716)	16-Jan-20	30.1091	฿8,490.77		AM-1802,AM-2718 (6x2x/14 ok)

Summarization of a master Stock count / Inventory report, to produce several smaller reports.

warrima

New Member

Excel Facts

mrshl9898

Well-known Member

warrima

New Member

Attachments

mrshl9898

Well-known Member

warrima

New Member

mrshl9898

Well-known Member

mrshl9898

Well-known Member

warrima

New Member

mrshl9898

Well-known Member

warrima

New Member

Similar threads

Forum statistics

Share this page

Summarization of a master Stock count / Inventory report, to produce several smaller reports.

New Member

Excel Facts

Well-known Member

New Member

Attachments

Well-known Member

New Member

Well-known Member

Well-known Member

New Member

Well-known Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock