Finished Goods333.xls

Excel - tworzenie makra

Proszę o pomoc w stworzeniu makra w Excelu. W załączniku plik który ma pomóc w kontrolowaniu magazynu. Założenie, że po naciśnięciu makra w arkuszu "Dispatch" w komórce A33, dane w arkuszu "Klient1" w kolumnie "G" zostaną odjęte od danych w kolumnie "A" i uaktualnione dane najlepiej wyświetlone w tej samej kolumnie "A", następnie dane w arkuszu "Dispatch" z zakresu komórek A5 do B30 zostaną skasowane. Z góry dzięki za pomoc. Zaznaczam jednak, że z Excelem mam zaledwie kilka tygodni do czynienia.


" Klient1 GOODS IN " ,,,
,,,
" PALLETS IN " , " Klient1 code " ,,
" 2 " , " 714050 " ,, " MAKRO2 "
,,,
" Stock " , " Customer ID " , " Product description " , " FIRMA ID " , " Box quantity " , " Boxes/pallet " , " allocated " , " 39906 " , " 39878 " , " 39884 " ,, " Stock - Lor 1 " , " Stock - Lor 2 " , " Stock - lory3 "
" 20 " , " 710250 " ,, " MM806375H " , " 1440 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 2 " , " 712801 " ,, " MM112300B " , " 408 " , " 20 " , " 2 " , " 2 " , " 0 " , " 0 " ,, " 2 " , " ERROR " , " ERROR "
" 4 " , " 712803 " ,, " MM387600B " , " 300 " , " 20 " , " 8 " , " 8 " , " 0 " , " 0 " ,, " 8 " , " ERROR " , " ERROR "
" 6 " , " 713050 " ,, " MM84525B " , " 600 " , " 20 " , " 6 " , " 6 " , " 0 " , " 0 " ,, " 6 " , " ERROR " , " ERROR "
" 34 " , " 714050 " ,, " MM111350B " , " 1008 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 5 " , " 715600 " ,, " MM164300B " , " 1008 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 0 " , " 716351 " ,, " MM165300B " , " 1008 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 1 " , " 716652 " ,, " MM306700H " , " 500 " , " 15 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 54 " , " 722715 " ,, " MM613350H " , " 400 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 3 " , " 722716 " ,, " MM620350B " , " 400 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 8 " , " 722717 " ,, " MM658650B " , " 360 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 9 " , " 722718 " ,, " MM614350H " , " 400 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
, " 722719 " ,, " MM614350B " , " 400 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
, " 722720 " ,, " MM112350H " , " 528 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
, " 722726 " ,, " MM727500H " , " 448 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
, " 722728 " ,, " MM198500B " , " 408 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
, " 722743 " ,, " MM928600B " , " 960 " , " 20 " , " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
,,,,,, " 0 " , " 0 " , " 0 " , " 0 " ,, " ERROR " , " ERROR " , " ERROR "
" 146 " ,,,,,, " 16 " , " 16 " , " 0 " , " 0 "
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
,,,,,,,
" 292 " ,,,,,,
" Klient1 " ,,,,,,,,,,,
" Lorry 2 " , " 39906 " ,,, " Lorry 2 " , " 39878 " ,,, " Lorry 3 " , " 39884 " ,,
" Customer code " , " Pallets amount " ,,, " Customer code " , " Pallets amount " ,,, " Customer code " , " Pallets amount " ,
" 712803 " , " 8 " , " 1 " ,,,, " 1 " ,,,, " 1 "
,, " 2 " ,,,, " 2 " ,,,, " 2 "
,, " 3 " ,,,, " 3 " ,,,, " 3 "
" 713050 " , " 6 " , " 4 " ,,,, " 4 " ,,,, " 4 "
,, " 5 " ,,,, " 5 " ,,,, " 5 "
" 712801 " , " 2 " , " 6 " ,,,, " 6 " ,,,, " 6 "
,, " 7 " ,,,, " 7 " ,,,, " 7 "
,, " 8 " ,,,, " 8 " ,,,, " 8 "
,, " 9 " ,,,, " 9 " ,,,, " 9 "
,, " 10 " ,,,, " 10 " ,,,, " 10 "
,, " 11 " ,,,, " 11 " ,,,, " 11 "
,, " 12 " ,,,, " 12 " ,,,, " 12 "
,, " 13 " ,,,, " 13 " ,,,, " 13 "
,, " 14 " ,,,, " 14 " ,,,, " 14 "
,, " 15 " ,,,, " 15 " ,,,, " 15 "
,, " 16 " ,,,, " 16 " ,,,, " 16 "
,, " 17 " ,,,, " 17 " ,,,, " 17 "
,, " 18 " ,,,, " 18 " ,,,, " 18 "
,, " 19 " ,,,, " 19 " ,,,, " 19 "
,, " 20 " ,,,, " 20 " ,,,, " 20 "
,, " 21 " ,,,, " 21 " ,,,, " 21 "
,, " 22 " ,,,, " 22 " ,,,, " 22 "
,, " 23 " ,,,, " 23 " ,,,, " 23 "
,, " 24 " ,,,, " 24 " ,,,, " 24 "
,, " 25 " ,,,, " 25 " ,,,, " 25 "
,, " 26 " ,,,, " 26 " ,,,, " 26 "
" Pallets in Totall " , " 16 " ,,, " Pallets in Totall " , " 0 " ,,, " Pallets in Totall " , " 0 " ,
" MAKRO 1 " ,,,,,,,,,,


Pobierz plik - link do postu