Split into sheets based on multiple criteria

cdrobinson83 · Nov 1, 2024

Hello,

I'm in need of a macro that splits data in one sheet across multiple new sheets based on variables. For example, I would like to take the information below and split it into separate sheets, including all the existing columns, based on Name and Location. Is someone able to assist with this?

Name	Color	Size	Location	Quantity
Jim	Red	Large	Foreign	3
Steve	Blue	Medium	Domestic	8
Bob	Green	Small	Foreign	4
Jim	Blue	Medium	Domestic	4
Steve	Green	Small	Foreign	7
Bob	Red	Medium	Domestic	5
Jim	Green	Small	Foreign	5
Steve	Red	Large	Domestic	6
Bob	Blue	Large	Foreign	6
Jim	Red	Large	Domestic	6
Steve	Blue	Medium	Foreign	5
Bob	Green	Small	Domestic	7
Jim	Blue	Medium	Foreign	7
Steve	Green	Small	Domestic	4
Bob	Red	Medium	Foreign	8
Jim	Green	Small	Domestic	8
Steve	Red	Large	Foreign	3
Bob	Blue	Large	Domestic	9

DanteAmor · Nov 2, 2024

I'm going to assume that:

1. The data is on Sheet1, adjust the name in the macro.
2. Names start in cell A2.

3. Headers are in row 1

4. The headers should be copied to the new sheet.

5. The name of the new sheet will be composed of the Name - Location.

6. The sheet name must not exceed 31 characters, which is the maximum allowed for a sheet name.

If the above is correct, try:

VBA Code:

Sub create_worksheets()
  Dim sh As Worksheet
  Dim c As Range, ky As Variant, itm As Variant
  Dim dic As Object
  
  Application.ScreenUpdating = False
  
  Set sh = Sheets("Sheet1")     'fit name of your sheet
  
  Set dic = CreateObject("Scripting.Dictionary")
  
  For Each c In sh.Range("A2", sh.Range("A" & Rows.Count).End(3))
    ky = c.Value & "-" & c.Offset(0, 3).Value
    dic(ky) = Empty
  Next c
  
  For Each itm In dic.Keys
    sh.Range("A1").AutoFilter 1, Split(itm, "-")(0)
    sh.Range("A1").AutoFilter 4, Split(itm, "-")(1)
    On Error Resume Next: Sheets(itm).Delete: On Error GoTo 0
    Sheets.Add(, Sheets(Sheets.Count)).Name = Left(itm, 31)
    sh.AutoFilter.Range.EntireRow.Copy Range("A1")
    sh.ShowAllData
  Next
  sh.Select
  
  Application.ScreenUpdating = False
End Sub

In the future try to be more precise in your request, that way you will have more opportunity for help.

cdrobinson83 · Nov 2, 2024

DanteAmor said:
I'm going to assume that:

1. The data is on Sheet1, adjust the name in the macro.
2. Names start in cell A2.
3. Headers are in row 1
4. The headers should be copied to the new sheet.
5. The name of the new sheet will be composed of the Name - Location.
6. The sheet name must not exceed 31 characters, which is the maximum allowed for a sheet name.

If the above is correct, try:

VBA Code:

Sub create_worksheets() Dim sh As Worksheet Dim c As Range, ky As Variant, itm As Variant Dim dic As Object Application.ScreenUpdating = False Set sh = Sheets("Sheet1") 'fit name of your sheet Set dic = CreateObject("Scripting.Dictionary") For Each c In sh.Range("A2", sh.Range("A" & Rows.Count).End(3)) ky = c.Value & "-" & c.Offset(0, 3).Value dic(ky) = Empty Next c For Each itm In dic.Keys sh.Range("A1").AutoFilter 1, Split(itm, "-")(0) sh.Range("A1").AutoFilter 4, Split(itm, "-")(1) On Error Resume Next: Sheets(itm).Delete: On Error GoTo 0 Sheets.Add(, Sheets(Sheets.Count)).Name = Left(itm, 31) sh.AutoFilter.Range.EntireRow.Copy Range("A1") sh.ShowAllData Next sh.Select Application.ScreenUpdating = False End Sub

In the future try to be more precise in your request, that way you will have more opportunity for help.

Thank you VERY much for this. And I will be sure to be clearer in the future. If I wanted to add a 3rd filter, is that simple to do? And if I needed to compensate for the filtered columns being in different locations, how would I do that? I'm basically trying to fit this to other files I may need to split as well; for example, 39 columns instead of only 5. Is it possible to cater this macro to fit?

cdrobinson83 · Nov 2, 2024

Also, will this always find the full range if there are any blank cells? Because that may be the case at times. Like the below just as an example.

BUS DATE	EXCHANGE	INVOICE NUMBER	BUY/SELL	CMF	TMF	ORIGIN	ACCOUNT #	OPPOSITE CMF	OPPOSITE TMF	OPPOSITE ORIGIN	CONTRACT	PERIOD	CVF	PRICE	CONTRACT VALUE	CCY	INTENT DATE	DELIVERY DATE	FACILITY NAME	FACILITY NUMBER	CERTIFICATE NUMBER	GRADE	FORM	BRAND(S)	NUMBER OF BARS	NUMBER OF BUNDLES	NUMBER OF PIECES	NET WEIGHT	FINE WEIGHT	METRIC TONS	STORAGE TYPE	STORAGE DAYS	STORAGE RATE	STORAGE PAID THRU DATE	FUTURES COST	HANDLING OUT CHARGE	STORAGE CHARGE	TOTAL AMOUNT
11/1/2024	COMEX	1273829568	BUYER	ZZZ	ZZZ	CUST	ABCDE	ZZZ	ZZZ	CUST	GC	202411	100	2738.3	273830	USD	10/31/2024	11/4/2024		2001	6709251055			ARHE/ARHE/ARHE	3			96.453	95.97			26	0.5	11/30/2024	-262794.65		-13	-262807.65
11/1/2024	COMEX	1273829568	BUYER	ZZZ	ZZZ	CUST	ABCDE	ZZZ	ZZZ	CUST	GC	202411	100	2738.3	273830	USD	10/31/2024	11/4/2024		2001	6709251056			ARHE/ARHE/ARHE	3			96.453	95.97			26	0.5	11/30/2024	-262794.65		-13	-262807.65
11/1/2024	COMEX	1273829568	BUYER	ZZZ	ZZZ	CUST	ABCDE	ZZZ	ZZZ	CUST	GC	202411	100	2738.3	273830	USD	10/31/2024	11/4/2024		2001	6709251057			ARHE/ARHE/ARHE	3			96.453	95.97			26	0.5	11/30/2024	-262794.65		-13	-262807.65
11/1/2024	COMEX	1273829568	BUYER	ZZZ	ZZZ	CUST	ABCDE	ZZZ	ZZZ	CUST	GC	202411	100	2738.3	273830	USD	10/31/2024	11/4/2024		2001	6709251058			ARHE/ARHE/ARHE	3			96.453	95.97			26	0.5	11/30/2024	-262794.65		-13	-262807.65
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002343	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	60/56/64/50/30	24970				26	0.5	11/30/2024	-107708.1	-625	-162.31	-108495.41
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002391	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	56/62/61/59/30	24981				26	0.5	11/30/2024	-107755.54	-625	-162.38	-108542.92
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002789	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	52/51/48/44/24	25339				26	0.5	11/30/2024	-109299.78	-625	-164.71	-110089.49
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002826	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	53/54/56/50/24	25347				26	0.5	11/30/2024	-109334.28	-625	-164.76	-110124.04
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003131	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/33	24942				26	0.5	11/30/2024	-107587.32	-625	-162.12	-108374.44
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003146	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/30	24910				26	0.5	11/30/2024	-107449.29	-625	-161.92	-108236.21
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003155	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	48/46/43/56/24	24949				26	0.5	11/30/2024	-107617.51	-625	-162.18	-108404.69
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003162	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	45/44/50/40/24	24916				26	0.5	11/30/2024	-107475.17	-625	-161.95	-108262.12
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003209	1	FULL_PLATE	GABY/GABY/GABY/GABY/GABY		1/2/3/4/5	63/66/69/67/34	24505				26	0.5	11/30/2024	-105702.32	-625	-159.29	-106486.61
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003830	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	33/33/31/34/18	24848				26	0.5	11/30/2024	-107181.85	-625	-161.51	-107968.36
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003865	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	33/32/31/30/18	24892				26	0.5	11/30/2024	-107371.64	-625	-161.8	-108158.44
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003874	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	31/32/32/32/18	25184				26	0.5	11/30/2024	-108631.18	-625	-163.7	-109419.88
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003888	1	FULL_PLATE	ABRA/ABRA/ABRA/ABRA/ABRA		1/2/3/4/5	35/35/35/35/15	24847				26	0.5	11/30/2024	-107177.53	-625	-161.51	-107964.04
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004042	1	FULL_PLATE	PDGO/PDGO/PDGO/PDGO/PDGO		1/2/3/4/5	55/45/55/55/20	25273				26	0.5	11/30/2024	-109015.09	-625	-164.28	-109804.37
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004243	1	FULL_PLATE	MELT/MELT/MELT/MELT/MELT		1/2/3/4/5	64/60/56/62/54	24910				26	0.5	11/30/2024	-107449.29	-625	-161.92	-108236.21
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004533	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	61/61/70/64/30	24956				26	0.5	11/30/2024	-107647.71	-625	-162.21	-108434.92
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004653	1	FULL_PLATE	MELT/MELT/MELT/MELT/MELT		1/2/3/4/5	60/60/56/54/59	24993				26	0.5	11/30/2024	-107807.31	-625	-162.46	-108594.77
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992490	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/49/48/48/24	25082				26	0.5	11/30/2024	-108191.21	-625	-163.03	-108979.24
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992503	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/46/48/44/24	25073				26	0.5	11/30/2024	-108152.39	-625	-162.98	-108940.37
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992508	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	40/46/46/46/24	24999				26	0.5	11/30/2024	-107833.19	-625	-162.5	-108620.69
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992522	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	51/49/48/52/24	25058				26	0.5	11/30/2024	-108087.68	-625	-162.88	-108875.56
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992580	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	31/40/38/50/24	25108				26	0.5	11/30/2024	-108303.36	-625	-163.2	-109091.56
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992582	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/46/49/47/24	25024				26	0.5	11/30/2024	-107941.02	-625	-162.66	-108728.68
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992625	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	54/54/47/48/24	24904				26	0.5	11/30/2024	-107423.4	-625	-161.88	-108210.28
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	12345	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992633	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	38/58/42/48/24	25026				26	0.5	11/30/2024	-107949.65	-625	-162.67	-108737.32
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	XYZ	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992648	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/47/46/46/24	25026				26	0.5	11/30/2024	-107949.65	-625	-162.67	-108737.32
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	XYZ	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992649	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	48/37/50/50/24	25093				26	0.5	11/30/2024	-108238.66	-625	-163.11	-109026.77
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	ZZZ	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992652	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	42/37/50/47/24	24995				26	0.5	11/30/2024	-107815.93	-625	-162.47	-108603.4
11/1/2024	COMEX	1273829135	BUYER	ZZZ	ZZZ	CUST	FFF	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992665	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/48/44/50/24	25049				26	0.5	11/30/2024	-108048.86	-625	-162.83	-108836.69
11/1/2024	COMEX	1273829136	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562042	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	33/42/37/40/18	25444				26	0.5	11/30/2024	109752.69	625	165.39	110543.08
11/1/2024	COMEX	1273829132	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562044	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	49/46/38/49/21	24922				26	0.5	11/30/2024	107501.05	625	161.99	108288.04
11/1/2024	COMEX	1273829132	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562046	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	44/37/48/40/22	25204				26	0.5	11/30/2024	108717.45	625	163.83	109506.28
11/1/2024	COMEX	1273829132	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562047	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/44/43/36/17	25198				26	0.5	11/30/2024	108691.57	625	163.79	109480.36
11/1/2024	COMEX	1273829131	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562064	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	34/44/40/49/21	24608				26	0.5	11/30/2024	106146.61	625	159.95	106931.56
11/1/2024	COMEX	1273829131	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562065	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	48/49/39/49/22	25252				26	0.5	11/30/2024	108924.5	625	164.14	109713.64
11/1/2024	COMEX	1273829131	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562066	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	40/36/43/34/20	25346				26	0.5	11/30/2024	109329.97	625	164.75	110119.72
11/1/2024	COMEX	1273829131	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562067	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	42/32/40/34/25	25460				26	0.5	11/30/2024	109821.71	625	165.49	110612.2
11/1/2024	COMEX	1273829131	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562068	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	46/36/40/30/22	24962				26	0.5	11/30/2024	107673.59	625	162.25	108460.84
11/1/2024	COMEX	1273829131	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12562088	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	36/51/41/41/22	24682				26	0.5	11/30/2024	106465.81	625	160.43	107251.24
11/1/2024	COMEX	1273829132	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		2503	12585055	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/30	24814				26	0.5	11/30/2024	107035.19	625	161.29	107821.48
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002343	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	60/56/64/50/30	24970				26	0.5	11/30/2024	107708.1	625	162.31	108495.41
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002359	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	64/61/65/61/30	24935				26	0.5	11/30/2024	107557.12	625	162.08	108344.2
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002391	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	56/62/61/59/30	24981				26	0.5	11/30/2024	107755.54	625	162.38	108542.92
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002413	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	66/62/60/66/30	24982				26	0.5	11/30/2024	107759.86	625	162.38	108547.24
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002789	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	52/51/48/44/24	25339				26	0.5	11/30/2024	109299.78	625	164.71	110089.49
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002815	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	55/44/43/44/24	25322				26	0.5	11/30/2024	109226.45	625	164.59	110016.04
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002826	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	53/54/56/50/24	25347				26	0.5	11/30/2024	109334.28	625	164.76	110124.04
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0002832	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	51/50/50/46/24	25349				26	0.5	11/30/2024	109342.91	625	164.78	110132.69
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003131	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/33	24942				26	0.5	11/30/2024	107587.32	625	162.12	108374.44
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003136	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/30	25031				26	0.5	11/30/2024	107971.22	625	162.71	108758.93
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003146	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/30	24910				26	0.5	11/30/2024	107449.29	625	161.92	108236.21
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003151	1	FULL_PLATE	RT/RT/RT/RT/RT		1/2/3/4/5	60/60/60/60/20	25066				26	0.5	11/30/2024	108122.19	625	162.93	108910.12
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003155	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	48/46/43/56/24	24949				26	0.5	11/30/2024	107617.51	625	162.18	108404.69
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003157	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	46/42/49/46/24	24992				26	0.5	11/30/2024	107802.99	625	162.45	108590.44
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003162	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	45/44/50/40/24	24916				26	0.5	11/30/2024	107475.17	625	161.95	108262.12
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003188	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	46/40/46/40/24	24872				26	0.5	11/30/2024	107285.37	625	161.67	108072.04
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003209	1	FULL_PLATE	GABY/GABY/GABY/GABY/GABY		1/2/3/4/5	63/66/69/67/34	24505				26	0.5	11/30/2024	105702.32	625	159.29	106486.61
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003514	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	46/41/40/46/15	24524				26	0.5	11/30/2024	105784.27	625	159.41	106568.68
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003830	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	33/33/31/34/18	24848				26	0.5	11/30/2024	107181.85	625	161.51	107968.36
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003848	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	29/31/30/29/18	24841				26	0.5	11/30/2024	107151.65	625	161.47	107938.12
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003865	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	33/32/31/30/18	24892				26	0.5	11/30/2024	107371.64	625	161.8	108158.44
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003870	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	33/30/32/33/18	24888				26	0.5	11/30/2024	107354.39	625	161.77	108141.16
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003874	1	FULL_PLATE	ESOX/ESOX/ESOX/ESOX/ESOX		1/2/3/4/5	31/32/32/32/18	25184				26	0.5	11/30/2024	108631.18	625	163.7	109419.88
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003881	1	FULL_PLATE	ABRA/ABRA/ABRA/ABRA/ABRA		1/2/3/4/5	35/35/35/35/15	24831				26	0.5	11/30/2024	107108.52	625	161.41	107894.93
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003888	1	FULL_PLATE	ABRA/ABRA/ABRA/ABRA/ABRA		1/2/3/4/5	35/35/35/35/15	24847				26	0.5	11/30/2024	107177.53	625	161.51	107964.04
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0003928	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	58/65/59/64/25	25075				26	0.5	11/30/2024	108161.01	625	162.99	108949
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004042	1	FULL_PLATE	PDGO/PDGO/PDGO/PDGO/PDGO		1/2/3/4/5	55/45/55/55/20	25273				26	0.5	11/30/2024	109015.09	625	164.28	109804.37
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004045	1	FULL_PLATE	GABY/GABY/GABY/GABY/GABY		1/2/3/4/5	44/60/60/67/40	24859				26	0.5	11/30/2024	107229.3	625	161.59	108015.89
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004243	1	FULL_PLATE	MELT/MELT/MELT/MELT/MELT		1/2/3/4/5	64/60/56/62/54	24910				26	0.5	11/30/2024	107449.29	625	161.92	108236.21
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004256	1	FULL_PLATE	MELT/MELT/MELT/MELT/MELT		1/2/3/4/5	64/66/65/61/45	25035				26	0.5	11/30/2024	107988.47	625	162.73	108776.2
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004533	1	FULL_PLATE	ZALD/ZALD/ZALD/ZALD/ZALD		1/2/3/4/5	61/61/70/64/30	24956				26	0.5	11/30/2024	107647.71	625	162.21	108434.92
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004632	1	FULL_PLATE	MELT/MELT/MELT/MELT/MELT		1/2/3/4/5	63/53/52/63/50	24699				26	0.5	11/30/2024	106539.14	625	160.55	107324.69
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0004653	1	FULL_PLATE	MELT/MELT/MELT/MELT/MELT		1/2/3/4/5	60/60/56/54/59	24993				26	0.5	11/30/2024	107807.31	625	162.46	108594.77
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992482	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	40/40/41/47/24	24971				26	0.5	11/30/2024	107712.41	625	162.32	108499.73
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992490	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/49/48/48/24	25082				26	0.5	11/30/2024	108191.21	625	163.03	108979.24
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992501	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/49/45/48/24	25024				26	0.5	11/30/2024	107941.02	625	162.66	108728.68
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992503	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/46/48/44/24	25073				26	0.5	11/30/2024	108152.39	625	162.98	108940.37
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992506	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	44/48/46/48/24	25027				26	0.5	11/30/2024	107953.96	625	162.68	108741.64
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992508	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	40/46/46/46/24	24999				26	0.5	11/30/2024	107833.19	625	162.5	108620.69
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992511	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	40/40/51/46/24	25069				26	0.5	11/30/2024	108135.13	625	162.96	108923.09
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992522	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	51/49/48/52/24	25058				26	0.5	11/30/2024	108087.68	625	162.88	108875.56
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992574	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	30/43/46/41/24	25065				26	0.5	11/30/2024	108117.88	625	162.93	108905.81
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992580	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	31/40/38/50/24	25108				26	0.5	11/30/2024	108303.36	625	163.2	109091.56
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992582	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/46/49/47/24	25024				26	0.5	11/30/2024	107941.02	625	162.66	108728.68
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992625	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	54/54/47/48/24	24904				26	0.5	11/30/2024	107423.4	625	161.88	108210.28
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992633	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	38/58/42/48/24	25026				26	0.5	11/30/2024	107949.65	625	162.67	108737.32
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992648	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/47/46/46/24	25026				26	0.5	11/30/2024	107949.65	625	162.67	108737.32
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992649	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	48/37/50/50/24	25093				26	0.5	11/30/2024	108238.66	625	163.11	109026.77
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992652	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	42/37/50/47/24	24995				26	0.5	11/30/2024	107815.93	625	162.47	108603.4
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992655	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	47/50/46/41/24	25067				26	0.5	11/30/2024	108126.5	625	162.94	108914.44
11/1/2024	COMEX	1273829134	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992656	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	46/43/45/48/24	25062				26	0.5	11/30/2024	108104.94	625	162.9	108892.84
11/1/2024	COMEX	1273829135	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	CUST	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		4313	CNO0992665	1	FULL_PLATE	SPEN/SPEN/SPEN/SPEN/SPEN		1/2/3/4/5	50/48/44/50/24	25049				26	0.5	11/30/2024	108048.86	625	162.83	108836.69
11/1/2024	COMEX	1273829119	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		5931	4853	1	FULL_PLATE	CSBL/CSBL/CSBL/CSBL/CSBL		1/2/3/4/5	55/55/55/55/55	25176				26	0.4665	11/30/2024	108596.68	600	152.69	109349.37
11/1/2024	COMEX	1273829119	SELLER	ZZZ	ZZZ	CUST	CCC	ZZZ	ZZZ	HOUS	HG	202411	25000	4.3135	107837.5	USD	10/31/2024	11/4/2024		5931	4854	1	FULL_PLATE	CSBL/CSBL/CSBL/CSBL/CSBL		1/2/3/4/5	55/55/55/55/55	25492				26	0.4665	11/30/2024	109959.74	600	154.61	110714.35

cdrobinson83 · Nov 2, 2024

I tried to edit to add that I'd like to create worksheets based on "BUY/SELL" , "ACCOUNT #" and "CONTRACT" , sorry. I waited too long to edit so had to reply instead.

DanteAmor · Nov 4, 2024

cdrobinson83 said:
If I wanted to add a 3rd filter, is that simple to do? And if I needed to compensate for the filtered columns being in different locations, how would I do that? I'm basically trying to fit this to other files I may need to split as well; for example, 39 columns instead of only 5. Is it possible to cater this macro to fit?

As I said, you must be very specific in what you need.

Comment if post #2 worked for what you asked for in your original post.

For everything else you need, create a new thread and there explain in detail what you have and what you expect as a result.

cdrobinson83 · Nov 4, 2024

DanteAmor said:
As I said, you must be very specific in what you need.

Comment if post #2 worked for what you asked for in your original post.

For everything else you need, create a new thread and there explain in detail what you have and what you expect as a result.

Marked as solved and opening a new thread now. My apologies.

Split into sheets based on multiple criteria

cdrobinson83

New Member

Excel Facts

DanteAmor

Well-known Member

cdrobinson83

New Member

cdrobinson83

New Member

cdrobinson83

New Member

DanteAmor

Well-known Member

cdrobinson83

New Member

Similar threads

Forum statistics

Share this page

Split into sheets based on multiple criteria

cdrobinson83

New Member

Excel Facts

DanteAmor

Well-known Member

cdrobinson83

New Member

cdrobinson83

New Member

cdrobinson83

New Member

DanteAmor

Well-known Member

cdrobinson83

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