Sambil menunggu solusi dari para pakar, cara sederhana yang bisa dilakukan adalah menghilangkan [January.xls] pada file February dengan memanfaatkan find ([January.xls]) and replace ().
Salam,
Hendrik Karnadi
From: Limrot Silalahi <limrot@amtek.com.sg>
To: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com>
Sent: Tuesday, 19 February 2013, 11:45
Subject: ]] XL-mania [[ Copy formula Saja
Dear All,
Bagaimana cara copy formula dari satu worksheet ke worksheet yg lainnya tanpa mengikut link dari worksheet sebelumnya?
Terlampir contoh yg diinginkan di worksheet Februari
Rgds
Limrot
Please consider the environment before printing this email
The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. We are neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.
Nenhum comentário:
Postar um comentário