]] XL-mania [[ copy data dari file lainnnya

Dear Pakar

 

Mohon bantuannya utk problem seperti attach:

Saya mau copy data dari sheet 1, 2 dan 3 ke file baru seperti di sheet 4. Kalau dgn cara = klik kolom sih bisa, tapi karna datanya banyak dan selalu update, adakah cara yg simple dan manjur?

 

Saya sudah utak-atik di data base belum ketemu nih.

 

Best Regards,
 
Antoni Ginting

Jr. Inspection Spt.

Plant/Head Office:

Mailing Address :

Wisma KPI

Jl. Pupuk Raya Km.2

Bontang -75314

Kalimantan Timur

Phone : +62-548-41091 ext.6211
Fax     : +62-548-41417
HP      : +628125521121
email: antoni.ginting@kpi.co.id

 

______________________________________________________________________________________________________________

Disclaimer :
______________________________________________________________________________________________________________

This message is intended for the lawful recipient(s) explicitly stated in above only.
It may contain confidential information prohibited for any Unauthorized use by any party
other than the lawful addressee. The message, information and statement expressed herein
should also be legally privileged for the lawful recipient(s).

If you are not the intended recipient(s) or person responsible for delivering it to the intended recipient(s),
you must therefore be notified not to copy, print, distribute or take any action in
reliance on it, directly or indirectly.
______________________________________________________________________________________________________________
Please consider ENVIRONTMENT before PRINTING this email .