Gunakan fitur Get External Data (xl2007) atau Import Data (xl2003). Bila perlu susun sebuah query, bila tidak, pilih kolom yang akan ditampilkan, termasuk atur sort dan filternya. Tampilkan sebagai Tabel.
Sebar file hasil koneksi keseluruh client. Regards. Kid. On Mon, Jul 5, 2010 at 1:45 PM, Contract Mining Assistant, Asam-Asam < [email protected]> wrote: > > > Dear teman2 pecinta excel, > Minta bantuan nih, untuk kasus seperti pada file terlampir. > > > > Terima kasih > > > Salam, Rasyid > Disclaimer - This message including any attachments and information > contained > herein ("Message" ) may contain privileged information or otherwise is > protected > from disclosure. Any unauthorized use of this Message by any person may > lead to > legal consequences. If you receive this Message in error, or if the > recipient > of this Message is not the intended recipient or the employee or agent > authorized > for delivering this Message to the intended recipient you are hereby > notified that > any disclosure, dissemination, distribution or copying of this Message > or let or > cause this Message to be disclosed,disseminated, distributed, or copied is > strictly > prohibited, and please notify the sender by return message and > immediately delete > this Message from your system. Incoming and outgoing communications > using this > electronic mail may be monitored by PT Arutmin Indonesia,as permitted by > applicable > law and regulations. Unless it is made by the authorized person,any views > expressed > in this Message are those of the individual sender and may not necessarily > reflect > the views of PT Arutmin Indonesia. > You should check attachments for viruses and defects before opening or > using them. > We are not liable to recover any injuries caused by virused or defected > attachments. > >

