Hello mas agung….
Yang sekarang sy lakukan,,,
Data-data client dan rangkuman di jadikan satu workbook saja, dan terbagi beberapa sheet
-sheet rangkuman
-sheet input data client
Workbook di shared mode dan save di sever.
Beberapa user bisa input data dalam waktu yg bersamaan,
Note:
Kelemahan : jika data besar ( > 10 Mb ) dan user >10 , excel akan sering hang..
Solusi: mungkin bisa di coba alternative lain, seperti ms.access.
wassalam
From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Agung Kurniawan
Sent: Monday, November 11, 2013 9:54 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Update Data Lewat Jaringan [3 Attachments]
Dear Para master XL ..
Numpang Tanya nieh J, saya ada kasus selama ini sy mengerjakan rangkuman excel dimana data excel yang sy pegang adalah sebagai data master sedangkan data client dipegang sendiri2 oleh user (Dalam bentuk Excel Format).
Selama ini update data sy kerjakan secara manual dengan mengkopi data Excel client2 (Tomat dan Wortel) ke dalam HDD saya kemudian secara manual saya pindahkan ke Rangkuman Data excel yang saya kerjakan.
Ada nga sih cara cepet update otomatis begitu user client update data di excel mereka (Data Tomat dan Wortel) langsung update ke master rangkuman data yang saya maintenance (Data client ada di jaringan LAN)
Mohon bantuannya buat para master karena datanya sendiri ratusan dan saya tidak mengetahui data jenis sayuran apa saja yg telah diupdate client perharinya. Terima kasih buat pencerahannya
Privileged/confidential information may be contained in this message. If you are not the named recipient or addressee, you are hereby notified that any use review, disclosure or copying of the contents herein is strictly prohibited. In such a case, kindly discard all its contents and notify sender accordingly regarding such unauthorized disclosure or transmission by email. Opinions, conclusions, statements and other information in this message that do not relate to the official business of CIMB Group shall be understood as neither given or endorsed by it. The contents herein are meant strictly for the use of the named recipient or addressee of CIMB Group. No assumption of responsibility or liability whatsoever is undertaken by CIMB Group in respect of prohibited and unauthorised use by any other person.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
| Maaf moderasi terlambat karena yahoogroups sering error |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário