contoh aplikasi sederhana olah laporan dengan macro ms excel

64
1 asda 2 asfd 3 dfg 4 5 6 sdg 7 dgs 8 Aksf$ 9 10 11 sdg 12 dgs 13 Aksf$ 14 gk 15 kuk 16 ukyu 17 18 asfd 19 dfg 20 $sadfas 21 AKshgfa4Hasf$asfas 22 23 24 25 26 27 sdg 28 dgs 29 sdgsdg 30 gk 31 asfd 32 dfg 33 grgr 34 hthtr 35 36 37 38 39 40 sdg 41 dgs 42 sdgsdg 43 gk 44 Jon$Man dsfs@dsfsd sdgsgr@ dsfs@dsfsd sdgsgr@ gk@bfna rgs@ sdgsgr@ sdgsgr@ dsfs@dsfsd sdgsgr@ rgs@ sdgsgr@ sdgsgr@ dsfs@dsfsd sdgsgr@

Upload: jonedwnky

Post on 01-Nov-2014

393 views

Category:

Documents


18 download

DESCRIPTION

File ini berisi contoh contoh script yang sederhana dan berguna dalam mengolah data untuk pembuatan laporan.

TRANSCRIPT

Page 1: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

1 asda2 asfd3 dfg456 sdg7 dgs8 Aksf$9

1011 sdg12 dgs13 Aksf$14 gk15 kuk16 ukyu1718 asfd19 dfg20 $sadfas21 AKshgfa4Hasf$asfas222324252627 sdg28 dgs29 sdgsdg30 gk31 asfd32 dfg33 grgr34 hthtr353637383940 sdg41 dgs42 sdgsdg43 gk44 Jon$Man

dsfs@dsfsdsdgsgr@

dsfs@dsfsdsdgsgr@

gk@bfna

rgs@sdgsgr@sdgsgr@dsfs@dsfsdsdgsgr@

rgs@sdgsgr@sdgsgr@dsfs@dsfsdsdgsgr@

Page 2: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel
Page 3: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total0 0 0 0 0 01 KKS 1-Aug-11 23.00 991.09 22,795.16 2 Cut Up 1-Aug-11 22.00 953.04 20,966.97 1 K Utuh 1-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 1-Aug-11 5.54 1,011.39 5,607.17 3 Parting 1-Aug-11 2.60 985.39 2,565.96 2 Sampingan 1-Aug-11 0.50 985.38 496.63 1 KKS 1-Aug-11 3.16 916.25 2,895.85 1 Cut Up 1-Aug-11 2.40 835.19 2,007.71 3 K Utuh 1-Aug-11 0.66 1,171.10 775.50 2 Debonning 1-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 1-Aug-11 55.99 1,091.59 61,120.97 2 KKS 1-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 1-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 1-Aug-11 141.92 870.97 123,604.79 1 Debonning 1-Aug-11 255.73 968.65 247,716.96 3 Parting 1-Aug-11 4.06 849.89 3,454.45 3 Cut Up 1-Aug-11 17.71 940.00 16,644.77 2 K Utuh 1-Aug-11 4.04 877.61 3,547.30 1 Debonning 1-Aug-11 4.04 877.61 3,547.29 1 Debonning 1-Aug-11 4.04 877.61 3,547.29 3 Debonning 1-Aug-11 0.39 953.03 371.96 3 Parting 1-Aug-11 1.03 953.05 984.69 2 Sampingan 1-Aug-11 1.03 953.05 984.69 1 KKS 1-Aug-11 1.16 953.04 1,106.95 1 Cut Up 1-Aug-11 1.16 953.04 1,106.95 3 Debonning 1-Aug-11 8.83 859.13 7,586.48 3 Parting 1-Aug-11 10.09 859.13 8,672.86 2 Parting 1-Aug-11 10.09 859.13 8,672.87 1 Sampingan 1-Aug-11 67.70 889.67 60,228.55 3 KKS 1-Aug-11 4.04 877.61 3,547.29 3 Cut Up 1-Aug-11 0.39 953.03 371.96 2 K Utuh 1-Aug-11 1.03 953.05 984.69 3 K Utuh 1-Aug-11 10.09 859.13 8,672.86 2 Cut Up 1-Aug-11 15.56 872.52 13,576.80 1 K Utuh 1-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 1-Aug-11 0.38 1,177.88 444.90 3 Parting 1-Aug-11 0.38 1,177.88 444.90 2 Sampingan 1-Aug-11 1.13 1,177.87 1,334.69 1 KKS 1-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 1-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 1-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 1-Aug-11 2.90 1,158.29 3,362.56 1 KKS 1-Aug-11 1.66 961.05 1,594.27

Page 4: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 1-Aug-11 3.73 980.48 3,659.61 3 K Utuh 1-Aug-11 2.10 981.77 2,057.16 2 Debonning 1-Aug-11 1.57 981.77 1,542.87 1 Debonning 1-Aug-11 0.52 955.39 500.47 1 Parting 1-Aug-11 1.57 955.39 1,501.42 1 Sampingan 1-Aug-11 1.05 955.39 1,000.94 3 KKS 1-Aug-11 2.10 955.39 2,001.89 3 Cut Up 1-Aug-11 4.19 962.88 4,035.17 2 K Utuh 1-Aug-11 1.05 964.38 1,010.36 1 Cut Up 1-Aug-11 1.05 913.52 957.08 3 K Utuh 1-Aug-11 0.61 913.52 558.38 3 Debonning 1-Aug-11 0.61 988.95 604.49 2 Debonning 1-Aug-11 4.28 988.95 4,231.41 1 Parting 1-Aug-11 1.83 988.95 1,813.45 3 Parting 1-Aug-11 0.52 991.06 519.16 3 Sampingan 1-Aug-11 0.55 991.07 545.21 2 KKS 1-Aug-11 1.65 991.09 1,635.65 1 Cut Up 1-Aug-11 1.10 991.09 1,090.43 1 K Utuh 1-Aug-11 1.10 991.03 1,090.37 1 Debonning 1-Aug-11 1.22 984.02 1,202.95 3 Debonning 1-Aug-11 0.61 991.09 605.80 3 Parting 1-Aug-11 8.56 991.09 8,481.15 2 Sampingan 1-Aug-11 11.00 961.09 10,574.27 3 Cut Up 1-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 1-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 1-Aug-11 2.90 1,158.29 3,362.56 1 KKS 1-Aug-11 1.66 961.05 1,594.27 3 Cut Up 1-Aug-11 3.73 980.48 3,659.61 3 K Utuh 1-Aug-11 2.10 981.77 2,057.16 2 Debonning 1-Aug-11 1.57 981.77 1,542.87 1 Debonning 1-Aug-11 0.52 955.39 500.47 1 Parting 1-Aug-11 1.57 955.39 1,501.42 1 Sampingan 1-Aug-11 1.05 955.39 1,000.94 3 KKS 1-Aug-11 2.10 955.39 2,001.89 3 Cut Up 1-Aug-11 4.19 962.88 4,035.17 2 K Utuh 1-Aug-11 1.05 964.38 1,010.36 1 Cut Up 1-Aug-11 1.05 913.52 957.08 3 Debonning 1-Aug-11 0.38 1,177.88 444.90 3 Parting 1-Aug-11 0.38 1,177.88 444.90 2 Sampingan 1-Aug-11 1.13 1,177.87 1,334.69 1 KKS 1-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 1-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 1-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 1-Aug-11 2.90 1,158.29 3,362.56 1 KKS 1-Aug-11 1.66 961.05 1,594.27 3 Cut Up 1-Aug-11 3.73 980.48 3,659.61 3 K Utuh 1-Aug-11 2.10 981.77 2,057.16 2 Debonning 1-Aug-11 1.57 981.77 1,542.87

Page 5: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

1 Debonning 1-Aug-11 0.52 955.39 500.47 1 Parting 1-Aug-11 1.57 955.39 1,501.42 1 Sampingan 1-Aug-11 1.05 955.39 1,000.94 3 KKS 1-Aug-11 2.10 955.39 2,001.89 3 Cut Up 1-Aug-11 4.19 962.88 4,035.17 2 K Utuh 1-Aug-11 1.05 964.38 1,010.36 1 Cut Up 1-Aug-11 1.05 913.52 957.08 3 K Utuh 1-Aug-11 0.61 913.52 558.38 3 Debonning 1-Aug-11 0.61 988.95 604.49 2 Debonning 1-Aug-11 4.28 988.95 4,231.41 1 Parting 1-Aug-11 1.83 988.95 1,813.45 3 Parting 1-Aug-11 0.52 991.06 519.16 3 Sampingan 1-Aug-11 0.55 991.07 545.21 2 KKS 1-Aug-11 1.65 991.09 1,635.65 1 Cut Up 1-Aug-11 1.10 991.09 1,090.43 1 K Utuh 1-Aug-11 1.10 991.03 1,090.37 1 Debonning 1-Aug-11 1.22 984.02 1,202.95 3 Debonning 1-Aug-11 0.61 991.09 605.80 3 Parting 1-Aug-11 8.56 991.09 8,481.15 2 Sampingan 1-Aug-11 11.00 961.09 10,574.27 3 Cut Up 1-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 1-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 1-Aug-11 2.90 1,158.29 3,362.56 1 KKS 1-Aug-11 1.66 961.05 1,594.27 3 Cut Up 1-Aug-11 3.73 980.48 3,659.61 3 K Utuh 1-Aug-11 2.10 981.77 2,057.16 2 Debonning 1-Aug-11 1.57 981.77 1,542.87 1 Debonning 1-Aug-11 0.52 955.39 500.47 1 Parting 1-Aug-11 1.57 955.39 1,501.42 1 Sampingan 1-Aug-11 1.05 955.39 1,000.94 3 KKS 1-Aug-11 2.10 955.39 2,001.89 3 Cut Up 1-Aug-11 4.19 962.88 4,035.17 2 K Utuh 1-Aug-11 1.05 964.38 1,010.36 1 Cut Up 1-Aug-11 1.05 913.52 957.08

Page 6: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 7: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1KFC Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3

SEDERHANA Pakis Port ,Pakistan Pakistan Region2MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1KFC Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1KFC KL Port ,Malaysia Malaysia Region1

Page 8: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1KFC Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3

Page 9: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 2-Aug-11 1.00 991.09 991.09 2 Cut Up 2-Aug-11 2.00 953.04 1,906.09 1 K Utuh 2-Aug-11 3.00 1,011.39 3,034.18 3 Debonning 2-Aug-11 4.00 1,011.39 4,045.58 3 Parting 2-Aug-11 5.00 985.39 4,926.96 2 Sampingan 2-Aug-11 6.00 985.38 5,912.26 1 KKS 2-Aug-11 7.00 916.25 6,413.72 1 Cut Up 2-Aug-11 8.00 835.19 6,681.51 3 K Utuh 2-Aug-11 9.00 1,171.10 10,539.87 2 Debonning 2-Aug-11 10.00 1,091.59 10,915.95 3 Sampingan 2-Aug-11 11.00 1,091.59 12,007.54 2 KKS 2-Aug-11 12.00 1,680.52 20,166.25 1 Cut Up 2-Aug-11 13.00 1,680.52 21,846.81 1 K Utuh 2-Aug-11 14.00 870.97 12,193.64 1 Debonning 2-Aug-11 15.00 968.65 14,529.78 3 Parting 2-Aug-11 16.00 849.89 13,598.26 3 Cut Up 2-Aug-11 17.00 940.00 15,980.00 2 K Utuh 2-Aug-11 18.00 877.61 15,796.99 1 Debonning 2-Aug-11 19.00 877.61 16,674.55 1 Debonning 2-Aug-11 20.00 877.61 17,552.16 3 Debonning 2-Aug-11 21.00 953.03 20,013.73 3 Parting 2-Aug-11 22.00 953.05 20,967.07 2 Sampingan 2-Aug-11 23.00 953.05 21,920.12 1 KKS 2-Aug-11 24.00 953.04 22,873.05 1 Cut Up 2-Aug-11 25.00 953.04 23,826.10 3 Debonning 2-Aug-11 26.00 859.13 22,337.37 3 Parting 2-Aug-11 27.00 859.13 23,196.53 2 Parting 2-Aug-11 28.00 859.13 24,055.69 1 Sampingan 2-Aug-11 29.00 889.67 25,800.40 3 KKS 2-Aug-11 30.00 877.61 26,328.24 3 Cut Up 2-Aug-11 31.00 953.03 29,544.08 2 K Utuh 2-Aug-11 32.00 953.05 30,497.56 3 K Utuh 2-Aug-11 33.00 859.13 28,351.31 2 Cut Up 2-Aug-11 34.00 872.52 29,665.74 1 K Utuh 2-Aug-11 35.00 1,177.87 41,225.55 3 Debonning 2-Aug-11 36.00 1,177.88 42,403.74 3 Parting 2-Aug-11 37.00 1,177.88 43,581.62 2 Sampingan 2-Aug-11 38.00 1,177.87 44,759.16 1 KKS 2-Aug-11 39.00 1,158.30 45,173.68 3 Cut Up 2-Aug-11 40.00 1,158.29 46,331.77 3 K Utuh 2-Aug-11 41.00 1,158.29 47,489.95 2 Cut Up 2-Aug-11 42.00 1,158.29 48,648.15 1 KKS 2-Aug-11 43.00 961.05 41,325.12

Page 10: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 2-Aug-11 44.00 980.48 43,140.97 3 K Utuh 2-Aug-11 45.00 981.77 44,179.62 2 Debonning 2-Aug-11 46.00 981.77 45,161.38 1 Debonning 2-Aug-11 47.00 955.39 44,903.35 1 Parting 2-Aug-11 48.00 955.39 45,858.74 1 Sampingan 2-Aug-11 49.00 955.39 46,813.91 3 KKS 2-Aug-11 50.00 955.39 47,769.54 3 Cut Up 2-Aug-11 51.00 962.88 49,107.00 2 K Utuh 2-Aug-11 52.00 964.38 50,147.66 1 Cut Up 2-Aug-11 53.00 913.52 48,416.81 3 K Utuh 2-Aug-11 54.00 913.52 49,330.35 3 Debonning 2-Aug-11 55.00 988.95 54,392.38 2 Debonning 2-Aug-11 56.00 988.95 55,381.33 1 Parting 2-Aug-11 57.00 988.95 56,369.98 3 Parting 2-Aug-11 58.00 991.06 57,481.75 3 Sampingan 2-Aug-11 59.00 991.07 58,473.31 2 KKS 2-Aug-11 60.00 991.09 59,465.64 1 Cut Up 2-Aug-11 61.00 991.09 60,456.53 1 K Utuh 2-Aug-11 62.00 991.03 61,443.99 1 Debonning 2-Aug-11 63.00 984.02 61,993.29 3 Debonning 2-Aug-11 64.00 991.09 63,430.06 3 Parting 2-Aug-11 65.00 991.09 64,421.12 2 Sampingan 2-Aug-11 66.00 961.09 63,432.23

Page 11: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 12: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 13: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 3-Aug-11 3.53 991.09 3,496.58 2 Cut Up 3-Aug-11 1.16 953.04 1,106.95 1 K Utuh 3-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 3-Aug-11 5.54 1,011.39 5,607.17 3 Parting 3-Aug-11 2.60 985.39 2,565.96 2 Sampingan 3-Aug-11 0.50 985.38 496.63 1 KKS 3-Aug-11 3.16 916.25 2,895.85 1 Cut Up 3-Aug-11 2.40 835.19 2,007.71 3 K Utuh 3-Aug-11 0.66 1,171.10 775.50 2 Debonning 3-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 3-Aug-11 55.99 1,091.59 61,120.97 2 KKS 3-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 3-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 3-Aug-11 141.92 870.97 123,604.79 1 Debonning 3-Aug-11 255.73 968.65 247,716.96 3 Parting 3-Aug-11 4.06 849.89 3,454.45 3 Cut Up 3-Aug-11 17.71 940.00 16,644.77 2 K Utuh 3-Aug-11 4.04 877.61 3,547.30 1 Debonning 3-Aug-11 4.04 877.61 3,547.29 1 Debonning 3-Aug-11 4.04 877.61 3,547.29 3 Debonning 3-Aug-11 0.39 953.03 371.96 3 Parting 3-Aug-11 1.03 953.05 984.69 2 Sampingan 3-Aug-11 1.03 953.05 984.69 1 KKS 3-Aug-11 1.16 953.04 1,106.95 1 Cut Up 3-Aug-11 1.16 953.04 1,106.95 3 Debonning 3-Aug-11 8.83 859.13 7,586.48 3 Parting 3-Aug-11 10.09 859.13 8,672.86 2 Parting 3-Aug-11 10.09 859.13 8,672.87 1 Sampingan 3-Aug-11 67.70 889.67 60,228.55 3 KKS 3-Aug-11 4.04 877.61 3,547.29 3 Cut Up 3-Aug-11 0.39 953.03 371.96 2 K Utuh 3-Aug-11 1.03 953.05 984.69 3 K Utuh 3-Aug-11 10.09 859.13 8,672.86 2 Cut Up 3-Aug-11 15.56 872.52 13,576.80 1 K Utuh 3-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 3-Aug-11 0.38 1,177.88 444.90 3 Parting 3-Aug-11 0.38 1,177.88 444.90 2 Sampingan 3-Aug-11 1.13 1,177.87 1,334.69 1 KKS 3-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 3-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 3-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 3-Aug-11 2.90 1,158.29 3,362.56 1 KKS 3-Aug-11 1.66 961.05 1,594.27

Page 14: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 3-Aug-11 3.73 980.48 3,659.61 3 K Utuh 3-Aug-11 2.10 981.77 2,057.16 2 Debonning 3-Aug-11 1.57 981.77 1,542.87 1 Debonning 3-Aug-11 0.52 955.39 500.47 1 Parting 3-Aug-11 1.57 955.39 1,501.42 1 Sampingan 3-Aug-11 1.05 955.39 1,000.94 3 KKS 3-Aug-11 2.10 955.39 2,001.89 3 Cut Up 3-Aug-11 4.19 962.88 4,035.17 2 K Utuh 3-Aug-11 1.05 964.38 1,010.36 1 Cut Up 3-Aug-11 1.05 913.52 957.08 3 K Utuh 3-Aug-11 0.61 913.52 558.38 3 Debonning 3-Aug-11 0.61 988.95 604.49 2 Debonning 3-Aug-11 4.28 988.95 4,231.41 1 Parting 3-Aug-11 1.83 988.95 1,813.45 3 Parting 3-Aug-11 0.52 991.06 519.16 3 Sampingan 3-Aug-11 0.55 991.07 545.21 2 KKS 3-Aug-11 1.65 991.09 1,635.65 1 Cut Up 3-Aug-11 1.10 991.09 1,090.43 1 K Utuh 3-Aug-11 1.10 991.03 1,090.37 1 Debonning 3-Aug-11 1.22 984.02 1,202.95 3 Debonning 3-Aug-11 0.61 991.09 605.80 3 Parting 3-Aug-11 8.56 991.09 8,481.15 2 Sampingan 3-Aug-11 11.00 961.09 10,574.27

Page 15: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 16: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 17: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 4-Aug-11 3.53 991.09 3,496.58 2 Cut Up 4-Aug-11 1.16 953.04 1,106.95 1 K Utuh 4-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 4-Aug-11 5.54 1,011.39 5,607.17 3 Parting 4-Aug-11 2.60 985.39 2,565.96 2 Sampingan 4-Aug-11 0.50 985.38 496.63 1 KKS 4-Aug-11 3.16 916.25 2,895.85 1 Cut Up 4-Aug-11 2.40 835.19 2,007.71 3 K Utuh 4-Aug-11 0.66 1,171.10 775.50 2 Debonning 4-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 4-Aug-11 55.99 1,091.59 61,120.97 2 KKS 4-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 4-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 4-Aug-11 141.92 870.97 123,604.79 1 Debonning 4-Aug-11 255.73 968.65 247,716.96 3 Parting 4-Aug-11 4.06 849.89 3,454.45 3 Cut Up 4-Aug-11 17.71 940.00 16,644.77 2 K Utuh 4-Aug-11 4.04 877.61 3,547.30 1 Debonning 4-Aug-11 4.04 877.61 3,547.29 1 Debonning 4-Aug-11 4.04 877.61 3,547.29 3 Debonning 4-Aug-11 0.39 953.03 371.96 3 Parting 4-Aug-11 1.03 953.05 984.69 2 Sampingan 4-Aug-11 1.03 953.05 984.69 1 KKS 4-Aug-11 1.16 953.04 1,106.95 1 Cut Up 4-Aug-11 1.16 953.04 1,106.95 3 Debonning 4-Aug-11 8.83 859.13 7,586.48 3 Parting 4-Aug-11 10.09 859.13 8,672.86 2 Parting 4-Aug-11 10.09 859.13 8,672.87 1 Sampingan 4-Aug-11 67.70 889.67 60,228.55 3 KKS 4-Aug-11 4.04 877.61 3,547.29 3 Cut Up 4-Aug-11 0.39 953.03 371.96 2 K Utuh 4-Aug-11 1.03 953.05 984.69 3 K Utuh 4-Aug-11 10.09 859.13 8,672.86 2 Cut Up 4-Aug-11 15.56 872.52 13,576.80 1 K Utuh 4-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 4-Aug-11 0.38 1,177.88 444.90 3 Parting 4-Aug-11 0.38 1,177.88 444.90 2 Sampingan 4-Aug-11 1.13 1,177.87 1,334.69 1 KKS 4-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 4-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 4-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 4-Aug-11 2.90 1,158.29 3,362.56 1 KKS 4-Aug-11 1.66 961.05 1,594.27

Page 18: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 4-Aug-11 3.73 980.48 3,659.61 3 K Utuh 4-Aug-11 2.10 981.77 2,057.16 2 Debonning 4-Aug-11 1.57 981.77 1,542.87 1 Debonning 4-Aug-11 0.52 955.39 500.47 1 Parting 4-Aug-11 1.57 955.39 1,501.42 1 Sampingan 4-Aug-11 1.05 955.39 1,000.94 3 KKS 4-Aug-11 2.10 955.39 2,001.89 3 Cut Up 4-Aug-11 4.19 962.88 4,035.17 2 K Utuh 4-Aug-11 1.05 964.38 1,010.36 1 Cut Up 4-Aug-11 1.05 913.52 957.08 3 K Utuh 4-Aug-11 0.61 913.52 558.38 3 Debonning 4-Aug-11 0.61 988.95 604.49 2 Debonning 4-Aug-11 4.28 988.95 4,231.41 1 Parting 4-Aug-11 1.83 988.95 1,813.45 3 Parting 4-Aug-11 0.52 991.06 519.16 3 Sampingan 4-Aug-11 0.55 991.07 545.21 2 KKS 4-Aug-11 1.65 991.09 1,635.65 1 Cut Up 4-Aug-11 1.10 991.09 1,090.43 1 K Utuh 4-Aug-11 1.10 991.03 1,090.37 1 Debonning 4-Aug-11 1.22 984.02 1,202.95 3 Debonning 4-Aug-11 0.61 991.09 605.80 3 Parting 4-Aug-11 8.56 991.09 8,481.15 2 Sampingan 4-Aug-11 11.00 961.09 10,574.27

Page 19: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 20: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 21: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 5-Aug-11 3.53 991.09 3,496.58 2 Cut Up 5-Aug-11 1.16 953.04 1,106.95 1 K Utuh 5-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 5-Aug-11 5.54 1,011.39 5,607.17 3 Parting 5-Aug-11 2.60 985.39 2,565.96 2 Sampingan 5-Aug-11 0.50 985.38 496.63 1 KKS 5-Aug-11 3.16 916.25 2,895.85 1 Cut Up 5-Aug-11 2.40 835.19 2,007.71 3 K Utuh 5-Aug-11 0.66 1,171.10 775.50 2 Debonning 5-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 5-Aug-11 55.99 1,091.59 61,120.97 2 KKS 5-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 5-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 5-Aug-11 141.92 870.97 123,604.79 1 Debonning 5-Aug-11 255.73 968.65 247,716.96 3 Parting 5-Aug-11 4.06 849.89 3,454.45 3 Cut Up 5-Aug-11 17.71 940.00 16,644.77 2 K Utuh 5-Aug-11 4.04 877.61 3,547.30 1 Debonning 5-Aug-11 4.04 877.61 3,547.29 1 Debonning 5-Aug-11 4.04 877.61 3,547.29 3 Debonning 5-Aug-11 0.39 953.03 371.96 3 Parting 5-Aug-11 1.03 953.05 984.69 2 Sampingan 5-Aug-11 1.03 953.05 984.69 1 KKS 5-Aug-11 1.16 953.04 1,106.95 1 Cut Up 5-Aug-11 1.16 953.04 1,106.95 3 Debonning 5-Aug-11 8.83 859.13 7,586.48 3 Parting 5-Aug-11 10.09 859.13 8,672.86 2 Parting 5-Aug-11 10.09 859.13 8,672.87 1 Sampingan 5-Aug-11 67.70 889.67 60,228.55 3 KKS 5-Aug-11 4.04 877.61 3,547.29 3 Cut Up 5-Aug-11 0.39 953.03 371.96 2 K Utuh 5-Aug-11 1.03 953.05 984.69 3 K Utuh 5-Aug-11 10.09 859.13 8,672.86 2 Cut Up 5-Aug-11 15.56 872.52 13,576.80 1 K Utuh 5-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 5-Aug-11 0.38 1,177.88 444.90 3 Parting 5-Aug-11 0.38 1,177.88 444.90 2 Sampingan 5-Aug-11 1.13 1,177.87 1,334.69 1 KKS 5-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 5-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 5-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 5-Aug-11 2.90 1,158.29 3,362.56 1 KKS 5-Aug-11 1.66 961.05 1,594.27

Page 22: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 5-Aug-11 3.73 980.48 3,659.61 3 K Utuh 5-Aug-11 2.10 981.77 2,057.16 2 Debonning 5-Aug-11 1.57 981.77 1,542.87 1 Debonning 5-Aug-11 0.52 955.39 500.47 1 Parting 5-Aug-11 1.57 955.39 1,501.42 1 Sampingan 5-Aug-11 1.05 955.39 1,000.94 3 KKS 5-Aug-11 2.10 955.39 2,001.89 3 Cut Up 5-Aug-11 4.19 962.88 4,035.17 2 K Utuh 5-Aug-11 1.05 964.38 1,010.36 1 Cut Up 5-Aug-11 1.05 913.52 957.08 3 K Utuh 5-Aug-11 0.61 913.52 558.38 3 Debonning 5-Aug-11 0.61 988.95 604.49 2 Debonning 5-Aug-11 4.28 988.95 4,231.41 1 Parting 5-Aug-11 1.83 988.95 1,813.45 3 Parting 5-Aug-11 0.52 991.06 519.16 3 Sampingan 5-Aug-11 0.55 991.07 545.21 2 KKS 5-Aug-11 1.65 991.09 1,635.65 1 Cut Up 5-Aug-11 1.10 991.09 1,090.43 1 K Utuh 5-Aug-11 1.10 991.03 1,090.37 1 Debonning 5-Aug-11 1.22 984.02 1,202.95 3 Debonning 5-Aug-11 0.61 991.09 605.80 3 Parting 5-Aug-11 8.56 991.09 8,481.15 2 Sampingan 5-Aug-11 11.00 961.09 10,574.27

Page 23: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 24: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 25: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 6-Aug-11 3.53 991.09 3,496.58 2 Cut Up 6-Aug-11 1.16 953.04 1,106.95 1 K Utuh 6-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 6-Aug-11 5.54 1,011.39 5,607.17 3 Parting 6-Aug-11 2.60 985.39 2,565.96 2 Sampingan 6-Aug-11 0.50 985.38 496.63 1 KKS 6-Aug-11 3.16 916.25 2,895.85 1 Cut Up 6-Aug-11 2.40 835.19 2,007.71 3 K Utuh 6-Aug-11 0.66 1,171.10 775.50 2 Debonning 6-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 6-Aug-11 55.99 1,091.59 61,120.97 2 KKS 6-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 6-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 6-Aug-11 141.92 870.97 123,604.79 1 Debonning 6-Aug-11 255.73 968.65 247,716.96 3 Parting 6-Aug-11 4.06 849.89 3,454.45 3 Cut Up 6-Aug-11 17.71 940.00 16,644.77 2 K Utuh 6-Aug-11 4.04 877.61 3,547.30 1 Debonning 6-Aug-11 4.04 877.61 3,547.29 1 Debonning 6-Aug-11 4.04 877.61 3,547.29 3 Debonning 6-Aug-11 0.39 953.03 371.96 3 Parting 6-Aug-11 1.03 953.05 984.69 2 Sampingan 6-Aug-11 1.03 953.05 984.69 1 KKS 6-Aug-11 1.16 953.04 1,106.95 1 Cut Up 6-Aug-11 1.16 953.04 1,106.95 3 Debonning 6-Aug-11 8.83 859.13 7,586.48 3 Parting 6-Aug-11 10.09 859.13 8,672.86 2 Parting 6-Aug-11 10.09 859.13 8,672.87 1 Sampingan 6-Aug-11 67.70 889.67 60,228.55 3 KKS 6-Aug-11 4.04 877.61 3,547.29 3 Cut Up 6-Aug-11 0.39 953.03 371.96 2 K Utuh 6-Aug-11 1.03 953.05 984.69 3 K Utuh 6-Aug-11 10.09 859.13 8,672.86 2 Cut Up 6-Aug-11 15.56 872.52 13,576.80 1 K Utuh 6-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 6-Aug-11 0.38 1,177.88 444.90 3 Parting 6-Aug-11 0.38 1,177.88 444.90 2 Sampingan 6-Aug-11 1.13 1,177.87 1,334.69 1 KKS 6-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 6-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 6-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 6-Aug-11 2.90 1,158.29 3,362.56 1 KKS 6-Aug-11 1.66 961.05 1,594.27

Page 26: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 6-Aug-11 3.73 980.48 3,659.61 3 K Utuh 6-Aug-11 2.10 981.77 2,057.16 2 Debonning 6-Aug-11 1.57 981.77 1,542.87 1 Debonning 6-Aug-11 0.52 955.39 500.47 1 Parting 6-Aug-11 1.57 955.39 1,501.42 1 Sampingan 6-Aug-11 1.05 955.39 1,000.94 3 KKS 6-Aug-11 2.10 955.39 2,001.89 3 Cut Up 6-Aug-11 4.19 962.88 4,035.17 2 K Utuh 6-Aug-11 1.05 964.38 1,010.36 1 Cut Up 6-Aug-11 1.05 913.52 957.08 3 K Utuh 6-Aug-11 0.61 913.52 558.38 3 Debonning 6-Aug-11 0.61 988.95 604.49 2 Debonning 6-Aug-11 4.28 988.95 4,231.41 1 Parting 6-Aug-11 1.83 988.95 1,813.45 3 Parting 6-Aug-11 0.52 991.06 519.16 3 Sampingan 6-Aug-11 0.55 991.07 545.21 2 KKS 6-Aug-11 1.65 991.09 1,635.65 1 Cut Up 6-Aug-11 1.10 991.09 1,090.43 1 K Utuh 6-Aug-11 1.10 991.03 1,090.37 1 Debonning 6-Aug-11 1.22 984.02 1,202.95 3 Debonning 6-Aug-11 0.61 991.09 605.80 3 Parting 6-Aug-11 8.56 991.09 8,481.15 2 Sampingan 6-Aug-11 11.00 961.09 10,574.27

Page 27: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 28: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 29: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 7-Aug-11 3.53 991.09 3,496.58 2 Cut Up 7-Aug-11 1.16 953.04 1,106.95 1 K Utuh 7-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 7-Aug-11 5.54 1,011.39 5,607.17 3 Parting 7-Aug-11 2.60 985.39 2,565.96 2 Sampingan 7-Aug-11 0.50 985.38 496.63 1 KKS 7-Aug-11 3.16 916.25 2,895.85 1 Cut Up 7-Aug-11 2.40 835.19 2,007.71 3 K Utuh 7-Aug-11 0.66 1,171.10 775.50 2 Debonning 7-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 7-Aug-11 55.99 1,091.59 61,120.97 2 KKS 7-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 7-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 7-Aug-11 141.92 870.97 123,604.79 1 Debonning 7-Aug-11 255.73 968.65 247,716.96 3 Parting 7-Aug-11 4.06 849.89 3,454.45 3 Cut Up 7-Aug-11 17.71 940.00 16,644.77 2 K Utuh 7-Aug-11 4.04 877.61 3,547.30 1 Debonning 7-Aug-11 4.04 877.61 3,547.29 1 Debonning 7-Aug-11 4.04 877.61 3,547.29 3 Debonning 7-Aug-11 0.39 953.03 371.96 3 Parting 7-Aug-11 1.03 953.05 984.69 2 Sampingan 7-Aug-11 1.03 953.05 984.69 1 KKS 7-Aug-11 1.16 953.04 1,106.95 1 Cut Up 7-Aug-11 1.16 953.04 1,106.95 3 Debonning 7-Aug-11 8.83 859.13 7,586.48 3 Parting 7-Aug-11 10.09 859.13 8,672.86 2 Parting 7-Aug-11 10.09 859.13 8,672.87 1 Sampingan 7-Aug-11 67.70 889.67 60,228.55 3 KKS 7-Aug-11 4.04 877.61 3,547.29 3 Cut Up 7-Aug-11 0.39 953.03 371.96 2 K Utuh 7-Aug-11 1.03 953.05 984.69 3 K Utuh 7-Aug-11 10.09 859.13 8,672.86 2 Cut Up 7-Aug-11 15.56 872.52 13,576.80 1 K Utuh 7-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 7-Aug-11 0.38 1,177.88 444.90 3 Parting 7-Aug-11 0.38 1,177.88 444.90 2 Sampingan 7-Aug-11 1.13 1,177.87 1,334.69 1 KKS 7-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 7-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 7-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 7-Aug-11 2.90 1,158.29 3,362.56 1 KKS 7-Aug-11 1.66 961.05 1,594.27

Page 30: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 7-Aug-11 3.73 980.48 3,659.61 3 K Utuh 7-Aug-11 2.10 981.77 2,057.16 2 Debonning 7-Aug-11 1.57 981.77 1,542.87 1 Debonning 7-Aug-11 0.52 955.39 500.47 1 Parting 7-Aug-11 1.57 955.39 1,501.42 1 Sampingan 7-Aug-11 1.05 955.39 1,000.94 3 KKS 7-Aug-11 2.10 955.39 2,001.89 3 Cut Up 7-Aug-11 4.19 962.88 4,035.17 2 K Utuh 7-Aug-11 1.05 964.38 1,010.36 1 Cut Up 7-Aug-11 1.05 913.52 957.08 3 K Utuh 7-Aug-11 0.61 913.52 558.38 3 Debonning 7-Aug-11 0.61 988.95 604.49 2 Debonning 7-Aug-11 4.28 988.95 4,231.41 1 Parting 7-Aug-11 1.83 988.95 1,813.45 3 Parting 7-Aug-11 0.52 991.06 519.16 3 Sampingan 7-Aug-11 0.55 991.07 545.21 2 KKS 7-Aug-11 1.65 991.09 1,635.65 1 Cut Up 7-Aug-11 1.10 991.09 1,090.43 1 K Utuh 7-Aug-11 1.10 991.03 1,090.37 1 Debonning 7-Aug-11 1.22 984.02 1,202.95 3 Debonning 7-Aug-11 0.61 991.09 605.80 3 Parting 7-Aug-11 8.56 991.09 8,481.15 2 Sampingan 7-Aug-11 11.00 961.09 10,574.27

Page 31: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 32: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 33: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 8-Aug-11 3.53 991.09 3,496.58 2 Cut Up 8-Aug-11 1.16 953.04 1,106.95 1 K Utuh 8-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 8-Aug-11 5.54 1,011.39 5,607.17 3 Parting 8-Aug-11 2.60 985.39 2,565.96 2 Sampingan 8-Aug-11 0.50 985.38 496.63 1 KKS 8-Aug-11 3.16 916.25 2,895.85 1 Cut Up 8-Aug-11 2.40 835.19 2,007.71 3 K Utuh 8-Aug-11 0.66 1,171.10 775.50 2 Debonning 8-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 8-Aug-11 55.99 1,091.59 61,120.97 2 KKS 8-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 8-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 8-Aug-11 141.92 870.97 123,604.79 1 Debonning 8-Aug-11 255.73 968.65 247,716.96 3 Parting 8-Aug-11 4.06 849.89 3,454.45 3 Cut Up 8-Aug-11 17.71 940.00 16,644.77 2 K Utuh 8-Aug-11 4.04 877.61 3,547.30 1 Debonning 8-Aug-11 4.04 877.61 3,547.29 1 Debonning 8-Aug-11 4.04 877.61 3,547.29 3 Debonning 8-Aug-11 0.39 953.03 371.96 3 Parting 8-Aug-11 1.03 953.05 984.69 2 Sampingan 8-Aug-11 1.03 953.05 984.69 1 KKS 8-Aug-11 1.16 953.04 1,106.95 1 Cut Up 8-Aug-11 1.16 953.04 1,106.95 3 Debonning 8-Aug-11 8.83 859.13 7,586.48 3 Parting 8-Aug-11 10.09 859.13 8,672.86 2 Parting 8-Aug-11 10.09 859.13 8,672.87 1 Sampingan 8-Aug-11 67.70 889.67 60,228.55 3 KKS 8-Aug-11 4.04 877.61 3,547.29 3 Cut Up 8-Aug-11 0.39 953.03 371.96 2 K Utuh 8-Aug-11 1.03 953.05 984.69 3 K Utuh 8-Aug-11 10.09 859.13 8,672.86 2 Cut Up 8-Aug-11 15.56 872.52 13,576.80 1 K Utuh 8-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 8-Aug-11 0.38 1,177.88 444.90 3 Parting 8-Aug-11 0.38 1,177.88 444.90 2 Sampingan 8-Aug-11 1.13 1,177.87 1,334.69 1 KKS 8-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 8-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 8-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 8-Aug-11 2.90 1,158.29 3,362.56 1 KKS 8-Aug-11 1.66 961.05 1,594.27

Page 34: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 8-Aug-11 3.73 980.48 3,659.61 3 K Utuh 8-Aug-11 2.10 981.77 2,057.16 2 Debonning 8-Aug-11 1.57 981.77 1,542.87 1 Debonning 8-Aug-11 0.52 955.39 500.47 1 Parting 8-Aug-11 1.57 955.39 1,501.42 1 Sampingan 8-Aug-11 1.05 955.39 1,000.94 3 KKS 8-Aug-11 2.10 955.39 2,001.89 3 Cut Up 8-Aug-11 4.19 962.88 4,035.17 2 K Utuh 8-Aug-11 1.05 964.38 1,010.36 1 Cut Up 8-Aug-11 1.05 913.52 957.08 3 K Utuh 8-Aug-11 0.61 913.52 558.38 3 Debonning 8-Aug-11 0.61 988.95 604.49 2 Debonning 8-Aug-11 4.28 988.95 4,231.41 1 Parting 8-Aug-11 1.83 988.95 1,813.45 3 Parting 8-Aug-11 0.52 991.06 519.16 3 Sampingan 8-Aug-11 0.55 991.07 545.21 2 KKS 8-Aug-11 1.65 991.09 1,635.65 1 Cut Up 8-Aug-11 1.10 991.09 1,090.43 1 K Utuh 8-Aug-11 1.10 991.03 1,090.37 1 Debonning 8-Aug-11 1.22 984.02 1,202.95 3 Debonning 8-Aug-11 0.61 991.09 605.80 3 Parting 8-Aug-11 8.56 991.09 8,481.15 2 Sampingan 8-Aug-11 11.00 961.09 10,574.27

Page 35: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 36: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 37: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Laporan Penjualan HarianPT Maju Terus Pantang Mundur

Kode Shift NamaBrg Tgl Transaksi Qty (Kg) Harga (@Rp) Total (Rp)0 0 0 0 0 01 KKS 9-Aug-11 3.53 991.09 3,496.58 2 Cut Up 9-Aug-11 1.16 953.04 1,106.95 1 K Utuh 9-Aug-11 12.60 1,011.39 12,743.56 3 Debonning 9-Aug-11 5.54 1,011.39 5,607.17 3 Parting 9-Aug-11 2.60 985.39 2,565.96 2 Sampingan 9-Aug-11 0.50 985.38 496.63 1 KKS 9-Aug-11 3.16 916.25 2,895.85 1 Cut Up 9-Aug-11 2.40 835.19 2,007.71 3 K Utuh 9-Aug-11 0.66 1,171.10 775.50 2 Debonning 9-Aug-11 20.08 1,091.59 21,913.94 3 Sampingan 9-Aug-11 55.99 1,091.59 61,120.97 2 KKS 9-Aug-11 1.74 1,680.52 2,916.04 1 Cut Up 9-Aug-11 3.85 1,680.52 6,465.31 1 K Utuh 9-Aug-11 141.92 870.97 123,604.79 1 Debonning 9-Aug-11 255.73 968.65 247,716.96 3 Parting 9-Aug-11 4.06 849.89 3,454.45 3 Cut Up 9-Aug-11 17.71 940.00 16,644.77 2 K Utuh 9-Aug-11 4.04 877.61 3,547.30 1 Debonning 9-Aug-11 4.04 877.61 3,547.29 1 Debonning 9-Aug-11 4.04 877.61 3,547.29 3 Debonning 9-Aug-11 0.39 953.03 371.96 3 Parting 9-Aug-11 1.03 953.05 984.69 2 Sampingan 9-Aug-11 1.03 953.05 984.69 1 KKS 9-Aug-11 1.16 953.04 1,106.95 1 Cut Up 9-Aug-11 1.16 953.04 1,106.95 3 Debonning 9-Aug-11 8.83 859.13 7,586.48 3 Parting 9-Aug-11 10.09 859.13 8,672.86 2 Parting 9-Aug-11 10.09 859.13 8,672.87 1 Sampingan 9-Aug-11 67.70 889.67 60,228.55 3 KKS 9-Aug-11 4.04 877.61 3,547.29 3 Cut Up 9-Aug-11 0.39 953.03 371.96 2 K Utuh 9-Aug-11 1.03 953.05 984.69 3 K Utuh 9-Aug-11 10.09 859.13 8,672.86 2 Cut Up 9-Aug-11 15.56 872.52 13,576.80 1 K Utuh 9-Aug-11 1.13 1,177.87 1,334.69 3 Debonning 9-Aug-11 0.38 1,177.88 444.90 3 Parting 9-Aug-11 0.38 1,177.88 444.90 2 Sampingan 9-Aug-11 1.13 1,177.87 1,334.69 1 KKS 9-Aug-11 2.07 1,158.30 2,401.85 3 Cut Up 9-Aug-11 3.73 1,158.29 4,323.31 3 K Utuh 9-Aug-11 2.49 1,158.29 2,882.20 2 Cut Up 9-Aug-11 2.90 1,158.29 3,362.56 1 KKS 9-Aug-11 1.66 961.05 1,594.27

Page 38: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

3 Cut Up 9-Aug-11 3.73 980.48 3,659.61 3 K Utuh 9-Aug-11 2.10 981.77 2,057.16 2 Debonning 9-Aug-11 1.57 981.77 1,542.87 1 Debonning 9-Aug-11 0.52 955.39 500.47 1 Parting 9-Aug-11 1.57 955.39 1,501.42 1 Sampingan 9-Aug-11 1.05 955.39 1,000.94 3 KKS 9-Aug-11 2.10 955.39 2,001.89 3 Cut Up 9-Aug-11 4.19 962.88 4,035.17 2 K Utuh 9-Aug-11 1.05 964.38 1,010.36 1 Cut Up 9-Aug-11 1.05 913.52 957.08 3 K Utuh 9-Aug-11 0.61 913.52 558.38 3 Debonning 9-Aug-11 0.61 988.95 604.49 2 Debonning 9-Aug-11 4.28 988.95 4,231.41 1 Parting 9-Aug-11 1.83 988.95 1,813.45 3 Parting 9-Aug-11 0.52 991.06 519.16 3 Sampingan 9-Aug-11 0.55 991.07 545.21 2 KKS 9-Aug-11 1.65 991.09 1,635.65 1 Cut Up 9-Aug-11 1.10 991.09 1,090.43 1 K Utuh 9-Aug-11 1.10 991.03 1,090.37 1 Debonning 9-Aug-11 1.22 984.02 1,202.95 3 Debonning 9-Aug-11 0.61 991.09 605.80 3 Parting 9-Aug-11 8.56 991.09 8,481.15 2 Sampingan 9-Aug-11 11.00 961.09 10,574.27

Page 39: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Nama Pelanggan Tujuan text_tujuan region0 0 0 0 0 0

KFC Penang Port ,Malaysia Malaysia Region1KFC Texas Port ,United States United States Region3

MCD Okla Port ,United States United States Region3MCD Texas Port ,United States United States Region3KFC NY Port ,United States United States Region3KFC LA Port ,United States United States Region3

SEDERHANA LA Port ,United States United States Region3SEDERHANA LA Port ,United States United States Region3SEDERHANA Okla Port ,United States United States Region3SEDERHANA Sao Port ,Brazil Brazil Region3SEDERHANA Paolo Port ,Brazil Brazil Region3

KFC Sao Port ,Brazil Brazil Region3KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Penang Port ,Malaysia Malaysia Region1MCD Penang Port ,Malaysia Malaysia Region1

SEDERHANA KL Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Pakis Port ,Pakistan Pakistan Region2KFC Desho Port ,Bangladesh Bangladesh Region2

MCD Guang Port ,China China Region2MCD Hana Port ,Ghana Ghana Region2LAPO Hana Port ,Ghana Ghana Region2MCD Yun Port ,Greece Greece Region1MCD Yun Port ,Greece Greece Region1LAPO Yun Port ,Greece Greece Region1LAPO Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2

SEDERHANA Mogad Port ,Nigeria Nigeria Region2MCD Pakis Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Lama Port ,Pakistan Pakistan Region2LAPO Pakis Port ,Pakistan Pakistan Region2

SEDERHANA Lama Port ,Pakistan Pakistan Region2SEDERHANA Pakis Port ,Pakistan Pakistan Region2

MCD Pakis Port ,Pakistan Pakistan Region2MCD Lebay Port ,Lebanon Lebanon Region2LAPO Lebay Port ,Lebanon Lebanon Region2MCD Lebay Port ,Lebanon Lebanon Region2KFC Lebay Port ,Lebanon Lebanon Region2KFC Neng Sri Port ,Sri Lanka Sri Lanka Region2

MCD Penang Port ,Malaysia Malaysia Region1

Page 40: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

KFC Penang Port ,Malaysia Malaysia Region1SEDERHANA KL Port ,Malaysia Malaysia Region1

KFC KL Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1KFC Kelang Port ,Malaysia Malaysia Region1

MCD Mogad Port ,Nigeria Nigeria Region2KFC Prude Port ,Peru Peru Region2KFC Prude Port ,Peru Peru Region2

MCD Texas Port ,United States United States Region3MCD Okla Port ,United States United States Region3LAPO Texas Port ,United States United States Region3MCD NY Port ,United States United States Region3MCD LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3LAPO LA Port ,United States United States Region3

SEDERHANA Texas Port ,United States United States Region3KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1KFC Pnom Port ,Vietnam Vietnam Region1

MCD Saudi Port ,UAE UAE Region2MCD Mogad Port ,Nigeria Nigeria Region2LAPO Mogad Port ,Nigeria Nigeria Region2MCD Perth Port ,Australia Australia Region1

Page 41: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Australia Region1Bangladesh Region2Brazil Region3China Region2Ghana Region2Greece Region1Lebanon Region2Malaysia Region1Nigeria Region2Pakistan Region2Peru Region2Sri Lanka Region2UAE Region2United States Region3Vietnam Region1

Page 42: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Total Date1 2

Product Region Qty Price Qty Price QtyKKS Total - - -

Region1 - Region2 - Region3 -

Cut Up Total - - - Region1 - Region2 - Region3 -

Debonning Total - - - Region1 - Region2 - Region3 -

K Utuh Total - - - Region1 - Region2 - Region3 -

Parting Total - - - Region1 - Region2 - Region3 -

Sampingan Total - - - Region1 - Region2 - Region3 -

Total Total - - - Region1 - - - Region2 - - - Region3 - - -

Page 43: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Date2 3 4 5 6

Price Qty Price Qty Price Qty Price Qty - - - -

- - - -

- - - -

- - - -

- - - -

- - - -

- - - - - - - - - - - - - - - -

Page 44: Contoh Aplikasi Sederhana olah laporan dengan Macro MS Excel

Date6 7 8 9

Price Qty Price Qty Price Qty Price - - -

- - -

- - -

- - -

- - -

- - -

- - - - - - - - - - - -