REKLAMA

generator kodów szpa.xls

[EXCEL] Jak stworzyć generator kodów w Excelu z automatyczną numeracją?

Jakoś sobie poradziłem łopatologicznie z generatorem.


Pobierz plik - link do postu

" 0101 " , " 0202 " , " 001 " , " / " ,,, " 0101/0202/001 " , " 001 " , " 001 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 001 " , " / " , " _1 " ,, " 0101/0202/001_1 " ,, " 001 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 001 " , " / " , " _2 " ,, " 0101/0202/001_2 " ,, " 001 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 001 " , " / " , " _3 " ,, " 0101/0202/001_3 " ,, " 001 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 001 " , " / " , " _4 " ,, " 0101/0202/001_4 " ,, " 001 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 002 " , " / " ,,, " 0101/0202/002 " , " 002 " , " 002 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 002 " , " / " , " _1 " ,, " 0101/0202/002_1 " ,, " 002 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 002 " , " / " , " _2 " ,, " 0101/0202/002_2 " ,, " 002 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 002 " , " / " , " _3 " ,, " 0101/0202/002_3 " ,, " 002 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 002 " , " / " , " _4 " ,, " 0101/0202/002_4 " ,, " 002 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 003 " , " / " ,,, " 0101/0202/003 " , " 003 " , " 003 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 003 " , " / " , " _1 " ,, " 0101/0202/003_1 " ,, " 003 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 003 " , " / " , " _2 " ,, " 0101/0202/003_2 " ,, " 003 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 003 " , " / " , " _3 " ,, " 0101/0202/003_3 " ,, " 003 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 003 " , " / " , " _4 " ,, " 0101/0202/003_4 " ,, " 003 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 004 " , " / " ,,, " 0101/0202/004 " , " 004 " , " 004 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 004 " , " / " , " _1 " ,, " 0101/0202/004_1 " ,, " 004 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 004 " , " / " , " _2 " ,, " 0101/0202/004_2 " ,, " 004 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 004 " , " / " , " _3 " ,, " 0101/0202/004_3 " ,, " 004 " ,,,,,,,,,,
" 0101 " , " 0202 " , " 004 " , " / " , " _4 " ,, " 0101/0202/004_4 " ,, " 004 " ,,,,,,,,,,
,, " 005 " ,,,,, " 005 " , " 005 " ,,,,,,,,,,
,, " 005 " ,,,,,, " 005 " ,,,,,,,,,,
,, " 005 " ,,,,,, " 005 " ,,,,,,,,,,
,, " 005 " ,,,,,, " 005 " ,,,,,,,,,,
,, " 005 " ,,,,,, " 005 " ,,,,,,,,,,
,, " 006 " ,,,,, " 006 " , " 006 " ,,,,,,,,,,
,, " 006 " ,,,,,, " 006 " ,,,,,,,,,,
,, " 006 " ,,,,,, " 006 " ,,,,,,,,,,
,, " 006 " ,,,,,, " 006 " ,,,,,,,,,,
,, " 006 " ,,,,,, " 006 " ,,,,,,,,,,
,, " 007 " ,,,,, " 007 " , " 007 " ,,,,,,,,,,
,, " 007 " ,,,,,, " 007 " ,,,,,,,,,,
,, " 007 " ,,,,,, " 007 " ,,,,,,,,,,
,, " 007 " ,,,,,, " 007 " ,,,,,,,,,,
,, " 007 " ,,,,,, " 007 " ,,,,,,,,,,
,, " 008 " ,,,,, " 008 " , " 008 " ,,,,,,,,,,
,, " 008 " ,,,,,, " 008 " ,,,,,,,,,,
,, " 008 " ,,,,,, " 008 " ,,,,,,,,,,
,, " 008 " ,,,,,, " 008 " ,,,,,,,,,,
,, " 008 " ,,,,,, " 008 " ,,,,,,,,,,
,, " 009 " ,,,,, " 009 " , " 009 " ,,,,,,,,,,
,, " 009 " ,,,,,, " 009 " ,,,,,,,,,,
,, " 009 " ,,,,,, " 009 " ,,,,,,,,,,
,, " 009 " ,,,,,, " 009 " ,,,,,,,,,,
,, " 009 " ,,,,,, " 009 " ,,,,,,,,,,
,, " 010 " ,,,,, " 010 " , " 010 " ,,,,,,,,,,
,, " 010 " ,,,,,, " 010 "
,, " 010 " ,,,,,, " 010 "
,, " 010 " ,,,,,, " 010 "
,, " 010 " ,,,,,, " 010 "
,, " 011 " ,,,,, " 011 " , " 011 "
,, " 011 " ,,,,,, " 011 "
,, " 011 " ,,,,,, " 011 "
,, " 011 " ,,,,,, " 011 "
,, " 011 " ,,,,,, " 011 "
,, " 012 " ,,,,, " 012 " , " 012 "
,, " 012 " ,,,,,, " 012 "
,, " 012 " ,,,,,, " 012 "
,, " 012 " ,,,,,, " 012 "
,, " 012 " ,,,,,, " 012 "
,, " 013 " ,,,,, " 013 " , " 013 "
,, " 013 " ,,,,,, " 013 "
,, " 013 " ,,,,,, " 013 "
,, " 013 " ,,,,,, " 013 "
,, " 013 " ,,,,,, " 013 "
,, " 014 " ,,,,, " 014 " , " 014 "
,, " 014 " ,,,,,, " 014 "
,, " 014 " ,,,,,, " 014 "
,, " 014 " ,,,,,, " 014 "
,, " 014 " ,,,,,, " 014 "
,, " 015 " ,,,,, " 015 " , " 015 "
,, " 015 " ,,,,,, " 015 "
,, " 015 " ,,,,,, " 015 "
,, " 015 " ,,,,,, " 015 "
,, " 015 " ,,,,,, " 015 "
,, " 016 " ,,,,, " 016 " , " 016 "
,, " 016 " ,,,,,, " 016 "
,, " 016 " ,,,,,, " 016 "
,, " 016 " ,,,,,, " 016 "
,, " 016 " ,,,,,, " 016 "
,, " 017 " ,,,,, " 017 " , " 017 "
,, " 017 " ,,,,,, " 017 "
,, " 017 " ,,,,,, " 017 "
,, " 017 " ,,,,,, " 017 "
,, " 017 " ,,,,,, " 017 "
,, " 018 " ,,,,, " 018 " , " 018 "
,, " 018 " ,,,,,, " 018 "
,, " 018 " ,,,,,, " 018 "
,, " 018 " ,,,,,, " 018 "
,, " 018 " ,,,,,, " 018 "
,, " 019 " ,,,,, " 019 " , " 019 "
,, " 019 " ,,,,,, " 019 "
,, " 019 " ,,,,,, " 019 "
,, " 019 " ,,,,,, " 019 "
,, " 019 " ,,,,,, " 019 "
,, " 020 " ,,,,, " 020 " , " 020 "
,, " 020 " ,,,,,, " 020 "
,, " 020 " ,,,,,, " 020 "
,, " 020 " ,,,,,, " 020 "
,, " 020 " ,,,,,, " 020 "
,, " 021 " ,,,,, " 021 " , " 021 "
,, " 021 " ,,,,,, " 021 "
,, " 021 " ,,,,,, " 021 "
,, " 021 " ,,,,,, " 021 "
,, " 021 " ,,,,,, " 021 "
,, " 022 " ,,,,, " 022 " , " 022 "
,, " 022 " ,,,,,, " 022 "
,, " 022 " ,,,,,, " 022 "
,, " 022 " ,,,,,, " 022 "
,, " 022 " ,,,,,, " 022 "
,, " 023 " ,,,,, " 023 " , " 023 "
,, " 023 " ,,,,,, " 023 "
,, " 023 " ,,,,,, " 023 "
,, " 023 " ,,,,,, " 023 "
,, " 023 " ,,,,,, " 023 "
,, " 024 " ,,,,, " 024 " , " 024 "
,, " 024 " ,,,,,, " 024 "
,, " 024 " ,,,,,, " 024 "
,, " 024 " ,,,,,, " 024 "
,, " 024 " ,,,,,, " 024 "
,, " 025 " ,,,,, " 025 " , " 025 "
,, " 025 " ,,,,,, " 025 "
,, " 025 " ,,,,,, " 025 "
,, " 025 " ,,,,,, " 025 "
,, " 025 " ,,,,,, " 025 "
,, " 026 " ,,,,, " 026 " , " 026 "
,, " 026 " ,,,,,, " 026 "
,, " 026 " ,,,,,, " 026 "
,, " 026 " ,,,,,, " 026 "
,, " 026 " ,,,,,, " 026 "
,, " 027 " ,,,,, " 027 " , " 027 "
,, " 027 " ,,,,,, " 027 "
,, " 027 " ,,,,,, " 027 "
,, " 027 " ,,,,,, " 027 "
,, " 027 " ,,,,,, " 027 "
,, " 028 " ,,,,, " 028 " , " 028 "
,, " 028 " ,,,,,, " 028 "
,, " 028 " ,,,,,, " 028 "
,, " 028 " ,,,,,, " 028 "
,, " 028 " ,,,,,, " 028 "
,,,,,,, " 029 " , " 029 "
,,,,,,,, " 029 "
,,,,,,,, " 029 "
,,,,,,,, " 029 "
,,,,,,,, " 029 "
,,,,,,, " 030 " , " 030 "
,,,,,,,, " 030 "
,,,,,,,, " 030 "
,,,,,,,, " 030 "
,,,,,,,, " 030 "
,,,,,,, " 031 " , " 031 "
,,,,,,,, " 031 "
,,,,,,,, " 031 "
,,,,,,,, " 031 "
,,,,,,,, " 031 "
,,,,,,, " 032 " , " 032 "
,,,,,,,, " 032 "
,,,,,,,, " 032 "
,,,,,,,, " 032 "
,,,,,,,, " 032 "
,,,,,,, " 033 " , " 033 "
,,,,,,,, " 033 "
,,,,,,,, " 033 "
,,,,,,,, " 033 "
,,,,,,,, " 033 "
,,,,,,, " 034 " , " 034 "
,,,,,,,, " 034 "
,,,,,,,, " 034 "
,,,,,,,, " 034 "
,,,,,,,, " 034 "
,,,,,,, " 035 " , " 035 "
,,,,,,,, " 035 "
,,,,,,,, " 035 "
,,,,,,,, " 035 "
,,,,,,,, " 035 "
,,,,,,, " 036 " , " 036 "
,,,,,,,, " 036 "
,,,,,,,, " 036 "
,,,,,,,, " 036 "
,,,,,,,, " 036 "
,,,,,,, " 037 " , " 037 "
,,,,,,,, " 037 "
,,,,,,,, " 037 "
,,,,,,,, " 037 "
,,,,,,,, " 037 "
,,,,,,, " 038 " , " 038 "
,,,,,,,, " 038 "
,,,,,,,, " 038 "
,,,,,,,, " 038 "
,,,,,,,, " 038 "
,,,,,,, " 039 " , " 039 "
,,,,,,,, " 039 "
,,,,,,,, " 039 "
,,,,,,,, " 039 "
,,,,,,,, " 039 "
,,,,,,, " 040 " , " 040 "
,,,,,,,, " 040 "
,,,,,,,, " 040 "
,,,,,,,, " 040 "
,,,,,,,, " 040 "
,,,,,,, " 041 " , " 041 "
,,,,,,,, " 041 "
,,,,,,,, " 041 "
,,,,,,,, " 041 "
,,,,,,,, " 041 "
,,,,,,, " 042 " , " 042 "
,,,,,,,, " 042 "
,,,,,,,, " 042 "
,,,,,,,, " 042 "
,,,,,,,, " 042 "
,,,,,,, " 043 " , " 043 "
,,,,,,,, " 043 "
,,,,,,,, " 043 "
,,,,,,,, " 043 "
,,,,,,,, " 043 "
,,,,,,, " 044 " , " 044 "
,,,,,,,, " 044 "
,,,,,,,, " 044 "
,,,,,,,, " 044 "
,,,,,,,, " 044 "
,,,,,,, " 045 " , " 045 "
,,,,,,,, " 045 "
,,,,,,,, " 045 "
,,,,,,,, " 045 "
,,,,,,,, " 045 "
,,,,,,, " 046 " , " 046 "
,,,,,,,, " 046 "
,,,,,,,, " 046 "
,,,,,,,, " 046 "
,,,,,,,, " 046 "
,,,,,,, " 047 " , " 047 "
,,,,,,,, " 047 "
,,,,,,,, " 047 "
,,,,,,,, " 047 "
,,,,,,,, " 047 "
,,,,,,, " 048 " , " 048 "
,,,,,,,, " 048 "
,,,,,,,, " 048 "
,,,,,,,, " 048 "
,,,,,,,, " 048 "
,,,,,,, " 049 " , " 049 "
" =A1 & " " " " & B1 & " " " " & C1 & " " "