Filtering different brands of items into new sheet

[alvin97]

I needs help on with filter different brand of item, as current VBA code was all using range cell to filter into different column. This make a lot of code needed to amend when there is a new product. Is there a way to filter each brand with unique SKU like (BrandA, BrandB, BrandC)? Thanks

Before

After

Sub Report()

Sheets("Sheet1").Select
Sheets("Sheet1").Name = "Main"

Dim ResultCell As Range
Dim Sheet As Worksheet

Set Sheet = ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count))
Sheet.Name = "Report"

Sheets("Main").Range("$A$4:$A$21").Copy
Sheets("Report").Activate
Range("A4").Select
ActiveSheet.Paste

Sheets("Main").Range("$A$22:$A$35").Copy
Sheets("Report").Activate
Range("D4").Select
ActiveSheet.Paste

Sheets("Main").Range("$A$36:$A$45").Copy
Sheets("Report").Activate
Range("G4").Select
ActiveSheet.Paste


    Dim LookupValueCell As Range
    Dim LookupVector As Range
    Dim ResultVector As Range

    
    Set ResultCell = Sheets("Report").Range("$B$4:$B$21")
    Set LookupValueCell = Sheets("Report").Range("$A$4:$A$400")
    Set LookupVector = Sheets("Main").Range("$A$4:$A$400")
    Set ResultVector = Sheets("Main").Range("$B$4:$B$23")

ResultCell = WorksheetFunction.Lookup(LookupValueCell, LookupVector, ResultVector)

    Dim LookupValueCell1 As Range
    Dim LookupVector1 As Range
    Dim ResultVector1 As Range
    Dim ResultCell1 As Range
    
    
    Set ResultCell1 = Sheets("Report").Range("$E$4:$E$17")
    Set LookupValueCell1 = Sheets("Report").Range("$D$4:$D$400")
    Set LookupVector1 = Sheets("Main").Range("$A$4:$A$400")
    Set ResultVector1 = Sheets("Main").Range("$B$4:$B$372")

ResultCell1 = WorksheetFunction.Lookup(LookupValueCell1, LookupVector1, ResultVector1)

    Dim LookupValueCell2 As Range
    Dim LookupVector2 As Range
    Dim ResultVector2 As Range
    Dim ResultCell2 As Range
    
    
    Set ResultCell2 = Sheets("Report").Range("$H$4:$H$13")
    Set LookupValueCell2 = Sheets("Report").Range("$G$4:$H$400")
    Set LookupVector2 = Sheets("Main").Range("$A$4:$A$400")
    Set ResultVector2 = Sheets("Main").Range("$B$4:$B$372")

ResultCell2 = WorksheetFunction.Lookup(LookupValueCell2, LookupVector2, ResultVector2)
 
DateString = Format(Now, "DDMMMYYYY")
[B1].Value = DateString
End Sub

 

[alvin97]

But what do you want to see in the column?

I just need column A & M in my report sheet filtered with BrandA, Brand B and BrandC.

 

[alvin97]

This was my sample sheets, and report outcome wanted. Thank you

Book1
	A	B
1	SKU	Total
2	BrandA001	1047
3	BrandA002	2634
4	BrandA003	981
5	BrandA004	1648
6	BrandA005	2163
7	BrandA006	2180
8	BrandA007	2252
9	BrandA008	1680
10	BrandA009	1074
11	BrandA010	901
12	BrandA011	1348
13	BrandA012	1558
14	BrandA013	250
15	BrandA014	252
16	BrandA015	222
17	BrandA016	285
18	BrandA017	659
19	BrandA018	1098
20	BrandA019	1585
21	BrandA020	220
22	BrandB7001	50
23	BrandB7002	2000
24	BrandB7003	25
25	BrandB7005	35
26	BrandB7006	552
27	BrandB7011	41
28	BrandB7012	2
29	BrandB7014	58
30	BrandB7016	56
31	BrandB7017	57
32	BrandB7018	58
33	BrandB7019	59
34	BrandC01	60
35	BrandC02	61
36	BrandC03	62
37	BrandC04	63
38	BrandC05	64
39	BrandC06	65
40	BrandC07	66
41	BrandC08	67
42	BrandC09	68
43	BrandC10	69
Main

Book1
	A	B	C	D	E	F	G	H
1		26-Sep-24
2
3
4	BrandA003	981		BrandB7001	50		BrandC01	60
5	BrandA004	1648		BrandB7002	2000		BrandC02	61
6	BrandA005	2163		BrandB7003	25		BrandC03	62
7	BrandA006	2180		BrandB7005	35		BrandC04	63
8	BrandA007	2252		BrandB7006	552		BrandC05	64
9	BrandA008	1680		BrandB7011	41		BrandC06	65
10	BrandA009	1074		BrandB7012	2		BrandC07	66
11	BrandA010	901		BrandB7014	58		BrandC08	67
12	BrandA011	1348		BrandB7016	56		BrandC09	68
13	BrandA012	1558		BrandB7017	57		BrandC10	69
14	BrandA013	250		BrandB7018	58
15	BrandA014	252		BrandB7019	59
16	BrandA015	222
17	BrandA016	285
18	BrandA017	659
19	BrandA018	1098
20	BrandA019	1585
21	BrandA020	220
Report

 

[HighAndWilder]

Brand A 2 column
Brand B 2 column
Brand C 2 column
View attachment 117349

Give this a go.

Public Sub subFilterBrands()
Dim arrBrands() As Variant
Dim i As Integer
Dim rngData As Range
Dim WsReport As Worksheet
Dim WsMain As Worksheet
Dim Wb As Workbook
Dim Q As String
Dim strFormula As String

  ActiveWorkbook.Save
  
  Set Wb = ActiveWorkbook
  
  Q = Chr(34)
    
  Set WsMain = Wb.Sheets("Main")
  
  WsMain.Activate
   
  strFormula = "=SUBSTITUTE($A2,TEXTJOIN(" & Q & Q & ",TRUE,IFERROR((MID($A2,ROW(INDIRECT(" & Q & "1:" & Q & "&LEN($A2))),1)*1)," & Q & Q & "))," & Q & Q & ",1)"
  
  WsMain.Range("B1").EntireColumn.Insert
  
  With WsMain.Range("A1").CurrentRegion.Columns(1)
  
    With .Offset(1, 1).Resize(.Rows.Count, 1)
      .Cells(1).Offset(-1, 0).Value = "Brand"
      .Formula2 = strFormula
      .Value = .Value
    End With
  
  End With
      
  Application.DisplayAlerts = False
  On Error Resume Next
  Wb.Worksheets("Report").Delete
  On Error GoTo 0
  Application.DisplayAlerts = True
  
  Set WsReport = ActiveWorkbook.Sheets.Add(After:=Wb.Sheets(Wb.Sheets.Count))

  WsReport.Name = "Report"
  
  With WsMain.Range("A1").CurrentRegion
  
    With .Offset(1, 0).Resize(.Rows.Count, .Columns.Count)
    
      arrBrands = Evaluate("SORT(UNIQUE(" & WsMain.Name & "!" & .Columns(2).Address & "),1)")
    
      For i = LBound(arrBrands) To UBound(arrBrands) - 1
            
        strFormula = "=CHOOSECOLS(FILTER(" & WsMain.Name & "!" & .Address & "," & WsMain.Name & "!" & .Columns(2).Address & "=" & Q & arrBrands(i, 1) & Q & ",""""),1,14)"
    
        WsReport.Range("A4").Offset(0, (i - 1) * 3).Formula2 = strFormula
    
      Next i
  
    End With
    
  End With
    
  With WsReport
    .UsedRange.Value = WsReport.UsedRange.Value
    .Cells.EntireColumn.AutoFit
  End With
  
  WsMain.Range("B1").EntireColumn.Delete
  
  MsgBox "Reports Compiled.", vbOKOnly, "Confirmation"
  
End Sub

 

[alvin97]

wasn't able to show any info
this was shown in sample excel,

#VALUE!			#VALUE!			#VALUE!

For my main excel nothing shown on report sheets and error 1004 on "WsReport.Range("A4").Offset(0, (i - 1) * 3).Formula2 = strFormula"

as for main sheet created column B on this formula.

 

[HighAndWilder]

wasn't able to show any info
this was shown in sample excel,

#VALUE!			#VALUE!			#VALUE!

For my main excel nothing shown on report sheets and error 1004 on "WsReport.Range("A4").Offset(0, (i - 1) * 3).Formula2 = strFormula"
View attachment 117354
as for main sheet created column B on this formula.
View attachment 117355

Rename your Main sheet and create a Main sheet from this data and then run the code.

Column B in Main will need to be deleted. This is used to seperate the Brand and the Product for the filter.

Filtering different brands of items into new sheet.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Brand	COLUMN $B$1	COLUMN $C$1	COLUMN $D$1	COLUMN $E$1	COLUMN $F$1	COLUMN $G$1	COLUMN $H$1	COLUMN $I$1	COLUMN $J$1	COLUMN $K$1	COLUMN $L$1	COLUMN $M$1
2	BrandE002	$B$2	$C$2	$D$2	$E$2	$F$2	$G$2	$H$2	$I$2	$J$2	$K$2	$L$2	$M$2
3	BrandC003	$B$3	$C$3	$D$3	$E$3	$F$3	$G$3	$H$3	$I$3	$J$3	$K$3	$L$3	$M$3
4	BrandE004	$B$4	$C$4	$D$4	$E$4	$F$4	$G$4	$H$4	$I$4	$J$4	$K$4	$L$4	$M$4
5	BrandC005	$B$5	$C$5	$D$5	$E$5	$F$5	$G$5	$H$5	$I$5	$J$5	$K$5	$L$5	$M$5
6	BrandE006	$B$6	$C$6	$D$6	$E$6	$F$6	$G$6	$H$6	$I$6	$J$6	$K$6	$L$6	$M$6
7	BrandB007	$B$7	$C$7	$D$7	$E$7	$F$7	$G$7	$H$7	$I$7	$J$7	$K$7	$L$7	$M$7
8	BrandC008	$B$8	$C$8	$D$8	$E$8	$F$8	$G$8	$H$8	$I$8	$J$8	$K$8	$L$8	$M$8
9	BrandA009	$B$9	$C$9	$D$9	$E$9	$F$9	$G$9	$H$9	$I$9	$J$9	$K$9	$L$9	$M$9
10	BrandC0010	$B$10	$C$10	$D$10	$E$10	$F$10	$G$10	$H$10	$I$10	$J$10	$K$10	$L$10	$M$10
11	BrandF0011	$B$11	$C$11	$D$11	$E$11	$F$11	$G$11	$H$11	$I$11	$J$11	$K$11	$L$11	$M$11
12	BrandE0012	$B$12	$C$12	$D$12	$E$12	$F$12	$G$12	$H$12	$I$12	$J$12	$K$12	$L$12	$M$12
13	BrandC0013	$B$13	$C$13	$D$13	$E$13	$F$13	$G$13	$H$13	$I$13	$J$13	$K$13	$L$13	$M$13
14	BrandC0014	$B$14	$C$14	$D$14	$E$14	$F$14	$G$14	$H$14	$I$14	$J$14	$K$14	$L$14	$M$14
15	BrandA0015	$B$15	$C$15	$D$15	$E$15	$F$15	$G$15	$H$15	$I$15	$J$15	$K$15	$L$15	$M$15
16	BrandE0016	$B$16	$C$16	$D$16	$E$16	$F$16	$G$16	$H$16	$I$16	$J$16	$K$16	$L$16	$M$16
17	BrandF0017	$B$17	$C$17	$D$17	$E$17	$F$17	$G$17	$H$17	$I$17	$J$17	$K$17	$L$17	$M$17
18	BrandA0018	$B$18	$C$18	$D$18	$E$18	$F$18	$G$18	$H$18	$I$18	$J$18	$K$18	$L$18	$M$18
19	BrandD0019	$B$19	$C$19	$D$19	$E$19	$F$19	$G$19	$H$19	$I$19	$J$19	$K$19	$L$19	$M$19
20	BrandC0020	$B$20	$C$20	$D$20	$E$20	$F$20	$G$20	$H$20	$I$20	$J$20	$K$20	$L$20	$M$20
21	BrandD0021	$B$21	$C$21	$D$21	$E$21	$F$21	$G$21	$H$21	$I$21	$J$21	$K$21	$L$21	$M$21
22	BrandD0022	$B$22	$C$22	$D$22	$E$22	$F$22	$G$22	$H$22	$I$22	$J$22	$K$22	$L$22	$M$22
23	BrandA0023	$B$23	$C$23	$D$23	$E$23	$F$23	$G$23	$H$23	$I$23	$J$23	$K$23	$L$23	$M$23
24	BrandC0024	$B$24	$C$24	$D$24	$E$24	$F$24	$G$24	$H$24	$I$24	$J$24	$K$24	$L$24	$M$24
25	BrandD0025	$B$25	$C$25	$D$25	$E$25	$F$25	$G$25	$H$25	$I$25	$J$25	$K$25	$L$25	$M$25
26	BrandB0026	$B$26	$C$26	$D$26	$E$26	$F$26	$G$26	$H$26	$I$26	$J$26	$K$26	$L$26	$M$26
27	BrandF0027	$B$27	$C$27	$D$27	$E$27	$F$27	$G$27	$H$27	$I$27	$J$27	$K$27	$L$27	$M$27
28	BrandB0028	$B$28	$C$28	$D$28	$E$28	$F$28	$G$28	$H$28	$I$28	$J$28	$K$28	$L$28	$M$28
29	BrandD0029	$B$29	$C$29	$D$29	$E$29	$F$29	$G$29	$H$29	$I$29	$J$29	$K$29	$L$29	$M$29
30	BrandA0030	$B$30	$C$30	$D$30	$E$30	$F$30	$G$30	$H$30	$I$30	$J$30	$K$30	$L$30	$M$30
31	BrandE0031	$B$31	$C$31	$D$31	$E$31	$F$31	$G$31	$H$31	$I$31	$J$31	$K$31	$L$31	$M$31
32	BrandC0032	$B$32	$C$32	$D$32	$E$32	$F$32	$G$32	$H$32	$I$32	$J$32	$K$32	$L$32	$M$32
33	BrandD0033	$B$33	$C$33	$D$33	$E$33	$F$33	$G$33	$H$33	$I$33	$J$33	$K$33	$L$33	$M$33
34	BrandF0034	$B$34	$C$34	$D$34	$E$34	$F$34	$G$34	$H$34	$I$34	$J$34	$K$34	$L$34	$M$34
35	BrandA0035	$B$35	$C$35	$D$35	$E$35	$F$35	$G$35	$H$35	$I$35	$J$35	$K$35	$L$35	$M$35
36	BrandF0036	$B$36	$C$36	$D$36	$E$36	$F$36	$G$36	$H$36	$I$36	$J$36	$K$36	$L$36	$M$36
37	BrandE0037	$B$37	$C$37	$D$37	$E$37	$F$37	$G$37	$H$37	$I$37	$J$37	$K$37	$L$37	$M$37
38	BrandF0038	$B$38	$C$38	$D$38	$E$38	$F$38	$G$38	$H$38	$I$38	$J$38	$K$38	$L$38	$M$38
39	BrandB0039	$B$39	$C$39	$D$39	$E$39	$F$39	$G$39	$H$39	$I$39	$J$39	$K$39	$L$39	$M$39
40	BrandC0040	$B$40	$C$40	$D$40	$E$40	$F$40	$G$40	$H$40	$I$40	$J$40	$K$40	$L$40	$M$40
41	BrandA0041	$B$41	$C$41	$D$41	$E$41	$F$41	$G$41	$H$41	$I$41	$J$41	$K$41	$L$41	$M$41
42	BrandC0042	$B$42	$C$42	$D$42	$E$42	$F$42	$G$42	$H$42	$I$42	$J$42	$K$42	$L$42	$M$42
43	BrandF0043	$B$43	$C$43	$D$43	$E$43	$F$43	$G$43	$H$43	$I$43	$J$43	$K$43	$L$43	$M$43
44	BrandB0044	$B$44	$C$44	$D$44	$E$44	$F$44	$G$44	$H$44	$I$44	$J$44	$K$44	$L$44	$M$44
45	BrandA0045	$B$45	$C$45	$D$45	$E$45	$F$45	$G$45	$H$45	$I$45	$J$45	$K$45	$L$45	$M$45
46	BrandB0046	$B$46	$C$46	$D$46	$E$46	$F$46	$G$46	$H$46	$I$46	$J$46	$K$46	$L$46	$M$46
47	BrandC0047	$B$47	$C$47	$D$47	$E$47	$F$47	$G$47	$H$47	$I$47	$J$47	$K$47	$L$47	$M$47
48	BrandD0048	$B$48	$C$48	$D$48	$E$48	$F$48	$G$48	$H$48	$I$48	$J$48	$K$48	$L$48	$M$48
49	BrandA0049	$B$49	$C$49	$D$49	$E$49	$F$49	$G$49	$H$49	$I$49	$J$49	$K$49	$L$49	$M$49
50	BrandB0050	$B$50	$C$50	$D$50	$E$50	$F$50	$G$50	$H$50	$I$50	$J$50	$K$50	$L$50	$M$50
51	BrandD0051	$B$51	$C$51	$D$51	$E$51	$F$51	$G$51	$H$51	$I$51	$J$51	$K$51	$L$51	$M$51
52	BrandC0052	$B$52	$C$52	$D$52	$E$52	$F$52	$G$52	$H$52	$I$52	$J$52	$K$52	$L$52	$M$52
53	BrandB0053	$B$53	$C$53	$D$53	$E$53	$F$53	$G$53	$H$53	$I$53	$J$53	$K$53	$L$53	$M$53
54	BrandC0054	$B$54	$C$54	$D$54	$E$54	$F$54	$G$54	$H$54	$I$54	$J$54	$K$54	$L$54	$M$54
55	BrandC0055	$B$55	$C$55	$D$55	$E$55	$F$55	$G$55	$H$55	$I$55	$J$55	$K$55	$L$55	$M$55
56	BrandB0056	$B$56	$C$56	$D$56	$E$56	$F$56	$G$56	$H$56	$I$56	$J$56	$K$56	$L$56	$M$56
57	BrandB0057	$B$57	$C$57	$D$57	$E$57	$F$57	$G$57	$H$57	$I$57	$J$57	$K$57	$L$57	$M$57
58	BrandC0058	$B$58	$C$58	$D$58	$E$58	$F$58	$G$58	$H$58	$I$58	$J$58	$K$58	$L$58	$M$58
59	BrandE0059	$B$59	$C$59	$D$59	$E$59	$F$59	$G$59	$H$59	$I$59	$J$59	$K$59	$L$59	$M$59
60	BrandB0060	$B$60	$C$60	$D$60	$E$60	$F$60	$G$60	$H$60	$I$60	$J$60	$K$60	$L$60	$M$60
61	BrandC0061	$B$61	$C$61	$D$61	$E$61	$F$61	$G$61	$H$61	$I$61	$J$61	$K$61	$L$61	$M$61
62	BrandE0062	$B$62	$C$62	$D$62	$E$62	$F$62	$G$62	$H$62	$I$62	$J$62	$K$62	$L$62	$M$62
63	BrandB0063	$B$63	$C$63	$D$63	$E$63	$F$63	$G$63	$H$63	$I$63	$J$63	$K$63	$L$63	$M$63
64	BrandF0064	$B$64	$C$64	$D$64	$E$64	$F$64	$G$64	$H$64	$I$64	$J$64	$K$64	$L$64	$M$64
65	BrandB0065	$B$65	$C$65	$D$65	$E$65	$F$65	$G$65	$H$65	$I$65	$J$65	$K$65	$L$65	$M$65
66	BrandC0066	$B$66	$C$66	$D$66	$E$66	$F$66	$G$66	$H$66	$I$66	$J$66	$K$66	$L$66	$M$66
67	BrandF0067	$B$67	$C$67	$D$67	$E$67	$F$67	$G$67	$H$67	$I$67	$J$67	$K$67	$L$67	$M$67
68	BrandF0068	$B$68	$C$68	$D$68	$E$68	$F$68	$G$68	$H$68	$I$68	$J$68	$K$68	$L$68	$M$68
69	BrandD0069	$B$69	$C$69	$D$69	$E$69	$F$69	$G$69	$H$69	$I$69	$J$69	$K$69	$L$69	$M$69
70	BrandC0070	$B$70	$C$70	$D$70	$E$70	$F$70	$G$70	$H$70	$I$70	$J$70	$K$70	$L$70	$M$70
71	BrandE0071	$B$71	$C$71	$D$71	$E$71	$F$71	$G$71	$H$71	$I$71	$J$71	$K$71	$L$71	$M$71
72	BrandB0072	$B$72	$C$72	$D$72	$E$72	$F$72	$G$72	$H$72	$I$72	$J$72	$K$72	$L$72	$M$72
73	BrandB0073	$B$73	$C$73	$D$73	$E$73	$F$73	$G$73	$H$73	$I$73	$J$73	$K$73	$L$73	$M$73
74	BrandA0074	$B$74	$C$74	$D$74	$E$74	$F$74	$G$74	$H$74	$I$74	$J$74	$K$74	$L$74	$M$74
75	BrandD0075	$B$75	$C$75	$D$75	$E$75	$F$75	$G$75	$H$75	$I$75	$J$75	$K$75	$L$75	$M$75
76	BrandE0076	$B$76	$C$76	$D$76	$E$76	$F$76	$G$76	$H$76	$I$76	$J$76	$K$76	$L$76	$M$76
Main

Here is a sample of what I get.

Filtering different brands of items into new sheet.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2
3
4	BrandA009	$M$9		BrandB007	$M$7		BrandC003	$M$3		BrandD0019	$M$19
5	BrandA0015	$M$15		BrandB0026	$M$26		BrandC005	$M$5		BrandD0021	$M$21
6	BrandA0018	$M$18		BrandB0028	$M$28		BrandC008	$M$8		BrandD0022	$M$22
7	BrandA0023	$M$23		BrandB0039	$M$39		BrandC0010	$M$10		BrandD0025	$M$25
8	BrandA0030	$M$30		BrandB0044	$M$44		BrandC0013	$M$13		BrandD0029	$M$29
9	BrandA0035	$M$35		BrandB0046	$M$46		BrandC0014	$M$14		BrandD0033	$M$33
10	BrandA0041	$M$41		BrandB0050	$M$50		BrandC0020	$M$20		BrandD0048	$M$48
11	BrandA0045	$M$45		BrandB0053	$M$53		BrandC0024	$M$24		BrandD0051	$M$51
12	BrandA0049	$M$49		BrandB0056	$M$56		BrandC0032	$M$32		BrandD0069	$M$69
13	BrandA0074	$M$74		BrandB0057	$M$57		BrandC0040	$M$40		BrandD0075	$M$75
14	BrandA0082	$M$82		BrandB0060	$M$60		BrandC0042	$M$42		BrandD0092	$M$92
15	BrandA0088	$M$88		BrandB0063	$M$63		BrandC0047	$M$47		BrandD0093	$M$93
16	BrandA00104	$M$104		BrandB0065	$M$65		BrandC0052	$M$52		BrandD0097	$M$97
17	BrandA00109	$M$109		BrandB0072	$M$72		BrandC0054	$M$54		BrandD00103	$M$103
18	BrandA00117	$M$117		BrandB0073	$M$73		BrandC0055	$M$55		BrandD00108	$M$108
19	BrandA00123	$M$123		BrandB0077	$M$77		BrandC0058	$M$58		BrandD00110	$M$110
20	BrandA00132	$M$132		BrandB0080	$M$80		BrandC0061	$M$61		BrandD00111	$M$111
21	BrandA00136	$M$136		BrandB0087	$M$87		BrandC0066	$M$66		BrandD00112	$M$112
22	BrandA00153	$M$153		BrandB0099	$M$99		BrandC0070	$M$70		BrandD00113	$M$113
23	BrandA00155	$M$155		BrandB00115	$M$115		BrandC0081	$M$81		BrandD00114	$M$114
24	BrandA00160	$M$160		BrandB00120	$M$120		BrandC0083	$M$83		BrandD00121	$M$121
Report

 

[alvin97]

I do get your results, but it was limited to the word "brand". May i know which part of the code that i need to change to my code? Thanks

 

[HighAndWilder]

I do get your results, but it was limited to the word "brand". May i know which part of the code that i need to change to my code? Thanks

In what row does your data in the Main sheet start?

 

[HighAndWilder]

I do get your results, but it was limited to the word "brand". May i know which part of the code that i need to change to my code? Thanks

Please post your Main sheet or part of it using XL2BB.

 

[alvin97]

This are sample of the main sheet.

227686c5-9d83-40e5-b33c-6a42c088dd61_Inventory_Products_Stock_Level_Report.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	SKU												Total
3	HTDKG107										914.00		9.14
4	HTDKG108										900.00		9
5	HTDKG109										1,170.00		11.7
6	HTDKG110										490.00		4.9
7	HTDKG111										1,500.00		15
8	HTK001										2,318.00		23.18
9	HTK002										1,518.00		15.18
10	HTK003										2,866.00		28.66
11	HTK005										240.00		2.4
12	HTK006										2,318.00		23.18
13	HTK014										546.00		5.46
14	HTK016										1,505.00		15.05
16	HTDG01										2,198.00		21.98
18	HTDG02										2,214.00		22.14
Main

Cell Formulas
Range	Formula
M3:M14,M16,M18	M3	=$K3/100

 

[alvin97]

In what row does your data in the Main sheet start?

Start from Row3 to Row371