Gini pak, di cell aw2, Bapak susun formula supaya bisa keluar tulisan yang tampak berbunyi : (biru) (nilai data selalu menyesuaikan sesuai baris tersebut) <NMEXML EximID="2" BranchCode="9224758" ACCOUNTANTCOPYID=""><TRANSACTIONS OnError="CONTINUE"><DELIVERYORDER operation="Add" REQUESTID="1"> <TRANSACTIONID>648</TRANSACTIONID> *<ITEMLINE operation="Add"><KeyID>1</KeyID><ITEMNO>231128</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 231128 D300 RC/LT</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE>*<ITEMLINE operation="Add"><KeyID>2</KeyID><ITEMNO>241033</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 241033 RC/L-TOP</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE><INVOICENO>1001</INVOICENO><INVOICEDATE>2014-11-29</INVOICEDATE><INVOICEAMOUNT>0</INVOICEAMOUNT><PURCHASEORDERNO>1001</PURCHASEORDERNO><WAREHOUSEID>CENTRE</WAREHOUSEID><DESCRIPTION/><SHIPDATE>2014-11-29</SHIPDATE><DELIVERYORDER></DELIVERYORDER><CUSTOMERID>1001</CUSTOMERID><SHIPTO1>45</SHIPTO1><SHIPTO2>Jl. Kh Wahid Hasyim No. 09</SHIPTO2><SHIPTO3>Makassar</SHIPTO3><SHIPTO4>Sulawesi Selatan 0</SHIPTO4><SHIPTO5/><CURRENCYNAME>IDR</CURRENCYNAME></DELIVERYORDER></TRANSACTIONS></NMEXML>
di cell aw3, formula aw2 tadi di copy ke cell aw3 tapi hasil formula harus berbunyi seperti bagian yang di-merah : (nilai data selalu menyesuaikan sesuai baris tersebut) <NMEXML EximID="2" BranchCode="9224758" ACCOUNTANTCOPYID=""><TRANSACTIONS OnError="CONTINUE"><DELIVERYORDER operation="Add" REQUESTID="1"> <TRANSACTIONID>648</TRANSACTIONID><ITEMLINE operation="Add"> <KeyID>1</KeyID><ITEMNO>231128</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 231128 D300 RC/LT</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE>*<ITEMLINE operation="Add"><KeyID>2</KeyID><ITEMNO>241033</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 241033 RC/L-TOP</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE>*<INVOICENO>1001</INVOICENO><INVOICEDATE>2014-11-29</INVOICEDATE><INVOICEAMOUNT>0</INVOICEAMOUNT><PURCHASEORDERNO>1001</PURCHASEORDERNO><WAREHOUSEID>CENTRE</WAREHOUSEID><DESCRIPTION/><SHIPDATE>2014-11-29</SHIPDATE><DELIVERYORDER></DELIVERYORDER><CUSTOMERID>1001</CUSTOMERID><SHIPTO1>45</SHIPTO1><SHIPTO2>Jl. Kh Wahid Hasyim No. 09</SHIPTO2><SHIPTO3>Makassar</SHIPTO3><SHIPTO4>Sulawesi Selatan 0</SHIPTO4><SHIPTO5/><CURRENCYNAME>IDR</CURRENCYNAME></DELIVERYORDER></TRANSACTIONS></NMEXML> di ax2, buat formula supaya yang tampil seperti bagian biru kalau ada satu saja nilai dalam bagian biru yang berbeda. Jadi kalau data baris 2 dan baris 3 nanti menghasilkan bunyi bagian biru yang sama, maka cukup baris 2 yang berisi hasil formula, sedang baris 3 dikosongkan. (nilai data selalu menyesuaikan sesuai baris tersebut) *<NMEXML EximID="2" BranchCode="9224758" ACCOUNTANTCOPYID=""><TRANSACTIONS OnError="CONTINUE"><DELIVERYORDER operation="Add" REQUESTID="1"><TRANSACTIONID>648</TRANSACTIONID>*<ITEMLINE operation="Add"> <KeyID>1</KeyID><ITEMNO>231128</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 231128 D300 RC/LT</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE><ITEMLINE operation="Add"><KeyID>2</KeyID><ITEMNO>241033</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 241033 RC/L-TOP</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE><INVOICENO>1001</INVOICENO><INVOICEDATE>2014-11-29</INVOICEDATE><INVOICEAMOUNT>0</INVOICEAMOUNT><PURCHASEORDERNO>1001</PURCHASEORDERNO><WAREHOUSEID>CENTRE</WAREHOUSEID><DESCRIPTION/><SHIPDATE>2014-11-29</SHIPDATE><DELIVERYORDER></DELIVERYORDER><CUSTOMERID>1001</CUSTOMERID><SHIPTO1>45</SHIPTO1><SHIPTO2>Jl. Kh Wahid Hasyim No. 09</SHIPTO2><SHIPTO3>Makassar</SHIPTO3><SHIPTO4>Sulawesi Selatan 0</SHIPTO4><SHIPTO5/><CURRENCYNAME>IDR</CURRENCYNAME></DELIVERYORDER></TRANSACTIONS></NMEXML> Ingat, jika formula di-copy ke baris lain, maka nilainya harus sesuai untuk baris tersebut. Jadi formula di baris 2 (menghasilkan nilai hasil mengikuti baris 2) jika di copy ke baris 3 akan menghasilkan nilai hasil formula yang mengikuti nilai data di baris 3. di ay2 buat formula agar menampilkan bagian yang dimerah dengan ketentuan, jika nilai di kolom ax3 ada isinya, maka di ax2 menampilkan yang dimerah tersebut : (nilai data selalu menyesuaikan sesuai baris tersebut) <NMEXML EximID="2" BranchCode="9224758" ACCOUNTANTCOPYID=""><TRANSACTIONS OnError="CONTINUE"><DELIVERYORDER operation="Add" REQUESTID="1"> <TRANSACTIONID>648</TRANSACTIONID><ITEMLINE operation="Add"> <KeyID>1</KeyID><ITEMNO>231128</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 231128 D300 RC/LT</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE><ITEMLINE operation="Add"><KeyID>2</KeyID><ITEMNO>241033</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 241033 RC/L-TOP</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE><INVOICENO>1001</INVOICENO><INVOICEDATE>2014-11-29</INVOICEDATE><INVOICEAMOUNT>0</INVOICEAMOUNT><PURCHASEORDERNO>1001</PURCHASEORDERNO><WAREHOUSEID>CENTRE</WAREHOUSEID><DESCRIPTION/><SHIPDATE>2014-11-29</SHIPDATE><DELIVERYORDER></DELIVERYORDER><CUSTOMERID>1001</CUSTOMERID><SHIPTO1>45</SHIPTO1><SHIPTO2>Jl. Kh Wahid Hasyim No. 09</SHIPTO2><SHIPTO3>Makassar</SHIPTO3><SHIPTO4>Sulawesi Selatan 0</SHIPTO4><SHIPTO5/><CURRENCYNAME>IDR</CURRENCYNAME> *</DELIVERYORDER></TRANSACTIONS></NMEXML>* di az2, jika ada data di baris 2 yang dipakai sebagai penyusun bagian yang dibiru ada yang berbeda dengan data yang ada di baris 3, maka az2 menampilkan teks berbunyi seperti yang dibiru (nilai data selalu menyesuaikan sesuai baris tersebut) : <NMEXML EximID="2" BranchCode="9224758" ACCOUNTANTCOPYID=""><TRANSACTIONS OnError="CONTINUE"><DELIVERYORDER operation="Add" REQUESTID="1"> <TRANSACTIONID>648</TRANSACTIONID><ITEMLINE operation="Add"> <KeyID>1</KeyID><ITEMNO>231128</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 231128 D300 RC/LT</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE><ITEMLINE operation="Add"><KeyID>2</KeyID><ITEMNO>241033</ITEMNO><QUANTITY>1</QUANTITY><ITEMUNIT>Pcs</ITEMUNIT><UNITRATIO>1</UNITRATIO><ITEMRESERVED1/><ITEMRESERVED2/><ITEMRESERVED3/><ITEMRESERVED4/><ITEMRESERVED5/><ITEMRESERVED6/><ITEMRESERVED7/><ITEMRESERVED8/><ITEMRESERVED9/><ITEMRESERVED10/><ITEMOVDESC>TAMIKO R 241033 RC/L-TOP</ITEMOVDESC><UNITPRICE>0</UNITPRICE><ITEMDISCPC/><TAXCODES/><SOSEQ/><BRUTOUNITPRICE>0</BRUTOUNITPRICE><WAREHOUSEID>CENTRE</WAREHOUSEID><QTYCONTROL>0</QTYCONTROL><DOSEQ/><DOID/></ITEMLINE>*<INVOICENO>1001</INVOICENO><INVOICEDATE>2014-11-29</INVOICEDATE><INVOICEAMOUNT>0</INVOICEAMOUNT><PURCHASEORDERNO>1001</PURCHASEORDERNO><WAREHOUSEID>CENTRE</WAREHOUSEID><DESCRIPTION/><SHIPDATE>2014-11-29</SHIPDATE><DELIVERYORDER></DELIVERYORDER><CUSTOMERID>1001</CUSTOMERID><SHIPTO1>45</SHIPTO1><SHIPTO2>Jl. Kh Wahid Hasyim No. 09</SHIPTO2><SHIPTO3>Makassar</SHIPTO3><SHIPTO4>Sulawesi Selatan 0</SHIPTO4><SHIPTO5/><CURRENCYNAME>IDR</CURRENCYNAME>* </DELIVERYORDER></TRANSACTIONS></NMEXML> di ba2, gabungkan hasil formula di aw2 sampai az dengan urutan penggabungan : =ax2 & aw2 & az2 & ay2 Kalau filenya sudah jadi, maka sudah ada kolom bantu berformula penyusun teks xml. kolom bantu penyusun teks xml inilah nanti yang akan diotomasi proses penulisannya ke sebuah text file. -> proses belajar berikutnya Wassalam, Kid. 2014-12-09 16:43 GMT+11:00 [email protected] [belajar-excel] < [email protected]>: > > > Dear Bapak Kid > > Selamat Siang Pak Kid. > > > Dengan ini saya lampirkan file excel dan data xml. > > > Maaf saya belum mengerti bagaimana file excel tsb dapat di update dan > simpan menjadi data xml. > > > Mungkin dengan adanya contoh dari file terlampir saya yang di bantu oleh > bapak maka saya akan mengerti. > > > Maaf jika saya sudah merepotkan bapak. > > Mohon bantuannya. > > > Terima Kasih > > > Rgrds > > > Kana > >
