]] XL-mania [[ Digest Number 2367

Microsoft Excel Community

Messages In This Digest (3 Messages)

1.

Data Rekap terisi otomatis dari beberapa sheet From: Agus Helarus

2.

Membuat data rekap secara berurutan tanpa terlewati dengan bbrp kete From: Beni Haryanto

3a.

Error Message From: SISWO

View All Topics | Create New Topic

Messages

1.

Data Rekap terisi otomatis dari beberapa sheet

Posted by: "Agus Helarus" agus_helarus-luvin@hotmail.com   helarus_17

Tue Apr 10, 2012 1:56 pm (PDT)

Para Pakar Excel yg Terhormat,
Saya memiliki data rekap yg merupakan gabungan dari beberapa sheet. Selama ini saya rekap manual dgn mencopy dari masing2 sheet tersebut. Namun dengn bertambahnya jumlah sheet dan kriteria data yg harus di rekap sangat sangat menyulitkan dan sering terjadi salah copy.
Mohon bantuannya agar Data Rekap bisa terisi secara otomatis dari beberapa data di sheet yg berbeda. Contoh data nya terlampir.
Terima kasih
SalamHelarus

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

2.

Membuat data rekap secara berurutan tanpa terlewati dengan bbrp kete

Posted by: "Beni Haryanto" acc_beni_bfi@yahoo.com   acc_beni_bfi

Tue Apr 10, 2012 1:57 pm (PDT)

Dear Para Master Xl-Mania

Mohon bantuannya untuk memcahkan kasus excel (terlampir)

Bagaimana caranya membuat data rekap secara berurutan atas penghasilan yang dibayarkan saja.

Sebelumnya saya ucapkan banyak terima kasih...

Best Regards
Beni. Haryanto

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

3a.

Error Message

Posted by: "SISWO" siswo71@yahoo.com   siswo71

Tue Apr 10, 2012 1:59 pm (PDT)

Pesan kesalahan ini muncul tiba-tiba ketika saya tekan tombol save, sehingga lembar kerja saya tidak mau disimpan.
Adakah saudara-saudara yang bersedia membagi ilmunya disini, tolonggggggg

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error054400_01.xml</logFileName><summary>Errors were detected in file 'G:\SEMESTANIAGASEJAHTERA\2 KKP PPh.xlsx'</summary>-<additionalInfo><info>Damage to the file was so extensive that repairs were not possible. Excel attempted to save your formulas and values, but some data may have been lost or corrupted.</info></additionalInfo></recoveryLog>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Recent Activity

•  41
  New Members

Visit Your Group

Yahoo! Groups

Parenting Zone

Tips for family,

kids and living

Yahoo! Groups

Cat Owners Group

Connect and share with

others who love their cats

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Delay pada posting disebabkan sibuknya momods dan leletnya        |
| koneksi dengan ind***t. bwakakakaka....
+-------------------------------------------------------------------+
| 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              |
+-------------------------------------------------------------------+

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe