Appendix Thread. Diet Protokol Coding Adaptions

[DocAElstein]

_____ Workbook: ProAktuellex8600x2.xlsm ( Using Excel 2007 32 bit )

Row\Col	A	B
16672
16673
16674
16675
16676
16677
16678
16679
16680
16681
16682
16683
16684
16685
16686
16687
16688
16689
16690
16691	NesClas2Suc.75g 2malZuSuß	5.4g
16692	NesCals2.54NesMild20gSuc.6 2malZuSuß	11g
16693	NesClas1.21nesMild1.53Suc.6g	6.5g
16694	NesClas2.96Suc.4g 2malZuSuß	7.4g
16695	NesMild3.01Suc.8g Made 10_03_2019 2malZuSuß	10.8g
16696	3.06NesClassic .9gSuc Bisy zu suß Made 17_10_2018	2.8g
16697	3.07NesClassic .4gSuc OK suß Made 17_10_2018	4g
16698	1.95NesMild NesClassic1 Suc.6g Made 17_10_2018	5.8g
16699	2.2NesClassic .6gSuc Made 25_06_2018 Bisy suß	4.5g
16700	2G&G .5gSuc Made 25_06_2018 Bisy zu suß	5g
16701	2.21Nes.5gSuc ZuSuß Made 05_06_2018	6.7g
16702	2.18Nes.5gSuc OKSuß Made 05_06_2018	5.8g
16703	5.54Nes.35Suc OK Made 05_06_2018	11.8g
16704	2.02Nes2.5gSuc Made 15_04_2018	7,9g
16705	1.81Nes.3gSuc Made 15_04_2018	7,3g
16706	1.6NesMild1.1gSuc Made 15_04_2018	7,7g
16707	1.9NesMild1.6gSuc Made 15_04_2018	9,1g
16708	KakClasic210gSuc4.5g_02.01.2018	6.54g
16709	Nes58gSuc2.5gCacPur060gCebeCac256g_21_02_2018	18g
16710	Kaffe176gSuc2.5g Made 21_02_2018	7.7g
16711	Kaffee64g cacPuro138g Suc1g SkinnySchok175g Made 21_02_2018	14,5g
16712	Kaffee144g Cac Puro119g Suc2g Made 21_02_2018	9,8g
16713	Kaffee184g SkinnyShoko96g Suc 2g Made 21_02_2018	11,3g
16714
16715
16716
16717
16718
16719
16720
16721

Worksheet: Sheet1

Typically I have sections of 50 rows which “belong together”, ( 49grouped + 1 below ) , and things may be added. It is easier to add anywhere in the section and then do a sort on the entire group, or part thereof , as required..
49grouped+1.JPG : https://imgur.com/a8rflEn
49grouped+1.JPG
The group above is 16721 ; 16722 ; 16723 .... 16672 = (16672-16721)+1 = 50 rows