Auto-Fill values (2)

[Saher Naji]

Hello O great and smart people

actually I posted a similar thread before some days, and Mr. @alansidman graciously did a great help and his code is working very well, 100%
and this is the post link for the solved problem:

Auto-Fill values

Hello Thanks in advance, I tried to crate a formula, but the problem I have to make the formulas fixed by $ symbol, this will cost me a long time What I'm looking for is a formula or a macro to do this thing automatically each time, because I have hundreds of rows, and the number of boxes...

www.mrexcel.com

I'm working on another sheet, which is little different,
the difference is, there a column separating each of the two boxes columns, also the the same thing for the rows

Take a look at this XL2BB please

Dear Mr. Alan, if you can help again this well be kind of you

Thank you very much

Example file filled (1).tsv
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
10
11	Total Units	9
12
13	shipment-total-cases	9
14
15	Pack list	von
16
17
18
19	Merchant SKU	Title	ASIN	FNSKU	external-id	Condition	Who Will Prep?	Prep Type	Who Will Label?	Units per Case	Number of Cases	Shipped	FBA15CXMW2Q7U001 - Case Quantity	FBA15CXMW2Q7U001 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U002 - Case Quantity	FBA15CXMW2Q7U002 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U003 - Case Quantity	FBA15CXMW2Q7U003 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U004 - Case Quantity	FBA15CXMW2Q7U004 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U005 - Case Quantity	FBA15CXMW2Q7U005 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U006 - Case Quantity	FBA15CXMW2Q7U006 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U007 - Case Quantity	FBA15CXMW2Q7U007 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U008 - Case Quantity	FBA15CXMW2Q7U008 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U009 - Case Quantity	FBA15CXMW2Q7U009 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U010 - Case Quantity	FBA15CXMW2Q7U010 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U011 - Case Quantity	FBA15CXMW2Q7U011 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U012 - Case Quantity	FBA15CXMW2Q7U012 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U013 - Case Quantity	FBA15CXMW2Q7U013 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U014 - Case Quantity	FBA15CXMW2Q7U014 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U015 - Case Quantity	FBA15CXMW2Q7U015 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U016 - Case Quantity	FBA15CXMW2Q7U016 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U017 - Case Quantity	FBA15CXMW2Q7U017 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U018 - Case Quantity	FBA15CXMW2Q7U018 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U019 - Case Quantity	FBA15CXMW2Q7U019 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U020 - Case Quantity	FBA15CXMW2Q7U020 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U021 - Case Quantity	FBA15CXMW2Q7U021 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U022 - Case Quantity	FBA15CXMW2Q7U022 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U023 - Case Quantity	FBA15CXMW2Q7U023 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U024 - Case Quantity	FBA15CXMW2Q7U024 Expiration Date (dd.mm.yy)	FBA15CXMW2Q7U025 - Case Quantity	FBA15CXMW2Q7U025 Expiration Date (dd.mm.yy)
20
21	4.26E+17	Blumtal Wنrmflasche mit weichem Bezug - 1,8L Wنrmeflasche, Bettflasche, Wنrmflasche Kinder, weiك	B071WC6RKG	B071WC6RKG	EAN : 4260514530271	Neu	--	--	--	1	1	1	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
22
23	4.26E+17	Blumtal Badezimmerteppich rutschfest - Weiche Badematte, Badvorleger, Badeteppich, 50x80 cm, Spicy-Mustard	B07QPY2MK5	B07QPY2MK5	EAN : 4260514532589	Neu	--	--	--	1	3	1		Not Needed	1	Not Needed	1	Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
24
25	4.26E+17	Blumtal 2er Set Kissenbezug 40 x 40 cm - 100% Baumwolle, Superweicher Premium Jersey Kopfkissenbezug, Kissenhülle, Moonlight Grey	B07V8FXFPJ	B07V8FXFPJ	EAN : 4260514532664	Neu	--	--	--	1	2	1		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
26
27	4.26E+17	Blumtal Mako Satin Bettwنsche 155x220 cm mit Kissenbezug 40 x 80 cm - 100% Baumwolle, Superweiches Bettbezug Set, White	B07X3LR5M9	B07X3LR5M9	EAN : 4260514533487	Neu	--	--	--	1	5	1		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed	1	Not Needed	1	Not Needed	1	Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
28
29	4.26E+17	Blumtal Mako Satin Bettwنsche 155x220 cm mit Kissenbezug 40 x 80 cm - 100% Baumwolle, Superweiches Bettbezug Set, Taupe	B07X3MLW41	B07X3MLW41	EAN : 4260514533531	Neu	--	--	--	1	1	1		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
30
31	4.26E+17	Blumtal Basics Spannbettlaken 180x200cm - 100% Baumwolle Bettlaken, bis 20cm Matratzenhِhe, Grau	B084KM7KQF	B084KM7KQF	EAN : 4260658690374	Neu	--	--	--	3	1	1		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed	1	Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
32
33	4.26E+17	Blumtal Basics 2er Set Spannbettlaken 180x200cm - 100% Baumwolle Bettlaken, bis 20cm Matratzenhِhe, Sommergrün	B084KLDYNF	B084KLDYNF	EAN : 4260658690541	Neu	--	--	--	1	1	1		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
34
35	4.26E+17	Blumtal Basics Spannbettlaken 200 x 200 cm - 100% Baumwolle Bettlaken, bis 20cm Matratzenhِhe, Rot	B084L6CK86	B084L6CK86	EAN : 4260658690619	Neu	--	--	--	2	1	1		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
36
37	4.26E+17	Blumtal Basics Spannbettlaken 200 x 200 cm - 100% Baumwolle Bettlaken, bis 20cm Matratzenhِhe, Tiefsee-Blau	B084KZDGBN	B084KZDGBN	EAN : 4260658690633	Neu	--	--	--	1	1	1		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed	1	Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed		Not Needed
Example file filled (1)

 

[alansidman]

I have played with your workbook and cannot get the code to skip every other column. I can get it to skip every other row but not the columns as you desire. This is obviously beyond my capabilities. Good luck finding a solution.