Zadanie zgodnie z załącznikiem: Do 4 pracowników (a,b,c,d) przekazano wykaz prowadzonych przez nich spraw. Każdy ma dać komentarz do swojej. Jest zakładka zbiorcze, w których mają być przeniesione dane od każdego z pracowników, które znajdują się w arkuszach z ich danymi (a,b,c,d) jakie funkcje najłatwiej zastosować aby uniknąć makra?
" Oddzia? " , " Pracownik " , " Nr sprawy " , " Komentarz "
" Katowice " , " d " , " 124/13 " ,
" Katowice " , " a " , " 453/13 " ,
" Katowice " , " d " , " 4564/13 " ,
" Katowice " , " b " , " 36/13 " ,
" Katowice " , " b " , " 45645/13 " ,
" Katowice " , " d " , " 345/13 " ,
" Katowice " , " b " , " 795/13 " ,
" Katowice " , " c " , " 4465/13 " ,
" Katowice " , " b " , " 55/13 " ,
" Katowice " , " a " , " 67876/13 " ,
" Katowice " , " c " , " 3465/13 " ,
" Katowice " , " b " , " 789/13 " ,
" Katowice " , " b " , " 900/13 " ,
" Katowice " , " a " , " 222/13 " ,
" Katowice " , " c " , " 5467/13 " ,
" Katowice " , " c " , " 4689/13 " ,
" Katowice " , " b " , " 4678/13 " ,
" Katowice " , " a " , " 99943/13 " ,
" Katowice " , " d " , " 36/13 " ,
" Katowice " , " b " , " 1114/13 " ,
" Katowice " , " d " , " 970567/13 " ,
" Katowice " , " d " , " 35645/11 " ,
" Katowice " , " c " , " 687/11 " ,
" Katowice " , " a " , " 4575/13 " ,
" Oddzia? " , " Pracownik " , " Nr sprawy " , " Komentarz "
" Katowice " , " d " , " 124/13 " ,
" Katowice " , " a " , " 453/13 " , " a "
" Katowice " , " d " , " 4564/13 " ,
" Katowice " , " b " , " 36/13 " ,
" Katowice " , " b " , " 45645/13 " ,
" Katowice " , " d " , " 345/13 " ,
" Katowice " , " b " , " 795/13 " ,
" Katowice " , " c " , " 4465/13 " ,
" Katowice " , " b " , " 55/13 " ,
" Katowice " , " a " , " 67876/13 " , " a "
" Katowice " , " c " , " 3465/13 " ,
" Katowice " , " b " , " 789/13 " ,
" Katowice " , " b " , " 900/13 " ,
" Katowice " , " a " , " 222/13 " , " a "
" Katowice " , " c " , " 5467/13 " ,
" Katowice " , " c " , " 4689/13 " ,
" Katowice " , " b " , " 4678/13 " ,
" Katowice " , " a " , " 99943/13 " , " a "
" Katowice " , " d " , " 36/13 " ,
" Katowice " , " b " , " 1114/13 " ,
" Katowice " , " d " , " 970567/13 " ,
" Katowice " , " d " , " 35645/11 " ,
" Katowice " , " c " , " 687/11 " ,
" Katowice " , " a " , " 4575/13 " , " a "
" Oddzia? " , " Pracownik " , " Nr sprawy " , " Komentarz "
" Katowice " , " d " , " 124/13 " ,
" Katowice " , " a " , " 453/13 " ,
" Katowice " , " d " , " 4564/13 " ,
" Katowice " , " b " , " 36/13 " , " b "
" Katowice " , " b " , " 45645/13 " , " b "
" Katowice " , " d " , " 345/13 " ,
" Katowice " , " b " , " 795/13 " , " b "
" Katowice " , " c " , " 4465/13 " ,
" Katowice " , " b " , " 55/13 " , " b "
" Katowice " , " a " , " 67876/13 " ,
" Katowice " , " c " , " 3465/13 " ,
" Katowice " , " b " , " 789/13 " , " b "
" Katowice " , " b " , " 900/13 " , " b "
" Katowice " , " a " , " 222/13 " ,
" Katowice " , " c " , " 5467/13 " ,
" Katowice " , " c " , " 4689/13 " ,
" Katowice " , " b " , " 4678/13 " , " b "
" Katowice " , " a " , " 99943/13 " ,
" Katowice " , " d " , " 36/13 " ,
" Katowice " , " b " , " 1114/13 " , " b "
" Katowice " , " d " , " 970567/13 " ,
" Katowice " , " d " , " 35645/11 " ,
" Katowice " , " c " , " 687/11 " ,
" Katowice " , " a " , " 4575/13 " ,
" Oddzia? " , " Pracownik " , " Nr sprawy " , " Komentarz "
" Katowice " , " d " , " 124/13 " ,
" Katowice " , " a " , " 453/13 " ,
" Katowice " , " d " , " 4564/13 " ,
" Katowice " , " b " , " 36/13 " ,
" Katowice " , " b " , " 45645/13 " ,
" Katowice " , " d " , " 345/13 " ,
" Katowice " , " b " , " 795/13 " ,
" Katowice " , " c " , " 4465/13 " , " c "
" Katowice " , " b " , " 55/13 " ,
" Katowice " , " a " , " 67876/13 " ,
" Katowice " , " c " , " 3465/13 " , " c "
" Katowice " , " b " , " 789/13 " ,
" Katowice " , " b " , " 900/13 " ,
" Katowice " , " a " , " 222/13 " ,
" Katowice " , " c " , " 5467/13 " , " c "
" Katowice " , " c " , " 4689/13 " , " c "
" Katowice " , " b " , " 4678/13 " ,
" Katowice " , " a " , " 99943/13 " ,
" Katowice " , " d " , " 36/13 " ,
" Katowice " , " b " , " 1114/13 " ,
" Katowice " , " d " , " 970567/13 " ,
" Katowice " , " d " , " 35645/11 " ,
" Katowice " , " c " , " 687/11 " , " c "
" Katowice " , " a " , " 4575/13 " ,
" Oddzia? " , " Pracownik " , " Nr sprawy " , " Komentarz "
" Katowice " , " d " , " 124/13 " , " d "
" Katowice " , " a " , " 453/13 " ,
" Katowice " , " d " , " 4564/13 " , " d "
" Katowice " , " b " , " 36/13 " ,
" Katowice " , " b " , " 45645/13 " ,
" Katowice " , " d " , " 345/13 " , " d "
" Katowice " , " b " , " 795/13 " ,
" Katowice " , " c " , " 4465/13 " ,
" Katowice " , " b " , " 55/13 " ,
" Katowice " , " a " , " 67876/13 " ,
" Katowice " , " c " , " 3465/13 " ,
" Katowice " , " b " , " 789/13 " ,
" Katowice " , " b " , " 900/13 " ,
" Katowice " , " a " , " 222/13 " ,
" Katowice " , " c " , " 5467/13 " ,
" Katowice " , " c " , " 4689/13 " ,
" Katowice " , " b " , " 4678/13 " ,
" Katowice " , " a " , " 99943/13 " ,
" Katowice " , " d " , " 36/13 " , " d "
" Katowice " , " b " , " 1114/13 " ,
" Katowice " , " d " , " 970567/13 " , " d "
" Katowice " , " d " , " 35645/11 " , " d "
" Katowice " , " c " , " 687/11 " ,
" Katowice " , " a " , " 4575/13 " ,