[milis-belajar-excel] Gabung multiple workbook dalam 1 worksheet

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Gabung multiple workbook dalam 1 worksheet

henri.hutagalung
Hello para suhu sekalian,

Mohon bantuannya untuk solusi untuk menggabungkan data dari beberapa workbook ke dalam 1 worksheet baru.

Saya sering bekerja dengan puluhan workbook dengan format dan jumlah kolom yang sama tetapi jumlah raw ber variasi.

Contoh file MFR-A.xlsx, MFR-B.xlsx, MFR-C.xlsx datanya di gabung jadi satu di HASIL GABUNGAN.xlsx
Terima kasih untuk bantuannya suhu

Gabung multiple workbook.jpg

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/dc1cad61-f026-4205-b511-a213bbcf8f19n%40googlegroups.com.

HASIL GABUNGAN.xlsx (12K) Download Attachment
MFR-A.xlsx (11K) Download Attachment
MFR-B.xlsx (11K) Download Attachment
MFR-C.xlsx (11K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Gabung multiple workbook dalam 1 worksheet

hendrik karnadi
Hai Henri,

Terlampir adalah file yang telah saya isi Macro hasil modifikasi dari Internet.

Sebelum menjalankan, macronya harus diaktifkan dulu dan file2 yang akan digabung dimasukkan ke dalam satu folder, mis. "Gabung"

Jalankan Macronya, kemudian pilih folder "Gabung" tersebut dan klik OK.

Salam,
HK



On Wednesday, 24 March 2021, 03:24:33 pm GMT+7, henri.hutagalung <[hidden email]> wrote:


Hello para suhu sekalian,

Mohon bantuannya untuk solusi untuk menggabungkan data dari beberapa workbook ke dalam 1 worksheet baru.

Saya sering bekerja dengan puluhan workbook dengan format dan jumlah kolom yang sama tetapi jumlah raw ber variasi.

Contoh file MFR-A.xlsx, MFR-B.xlsx, MFR-C.xlsx datanya di gabung jadi satu di HASIL GABUNGAN.xlsx
Terima kasih untuk bantuannya suhu

Gabung multiple workbook.jpg

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/dc1cad61-f026-4205-b511-a213bbcf8f19n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/280274976.149169.1616654441678%40mail.yahoo.com.

re_HASIL GABUNGAN.xlsm (25K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Fw: [milis-belajar-excel] Gabung multiple workbook dalam 1 worksheet

hendrik karnadi
Jika Workbooks yang mau digabung terdiri dari satu atau bbrp Worksheets, maka tambahkan Code berwarna merah pada bagian ini:

       For Each wks In src.Worksheets
        wks.Select
        Set Tble = wks.Range("A1", Range("A1").SpecialCells(xlCellTypeLastCell))
        Tble.Copy
        dst.ActiveSheet.Cells(mynextrow, 1).PasteSpecial Paste:=xlPasteAllUsingSourceTheme
        mynextrow = dst.ActiveSheet.UsedRange.Rows.Count + 1
    Next wks

Semoga bermanfaat.

Salam,
HK


----- Forwarded message -----
From: 'hendrik karnadi' via milis Belajar-Excel <[hidden email]>
To: Milis Belajar-Excel <[hidden email]>; Mr. Kid <[hidden email]>
Sent: Thursday, 25 March 2021, 01:40:49 pm GMT+7
Subject: Re: [milis-belajar-excel] Gabung multiple workbook dalam 1 worksheet

Hai Henri,

Terlampir adalah file yang telah saya isi Macro hasil modifikasi dari Internet.

Sebelum menjalankan, macronya harus diaktifkan dulu dan file2 yang akan digabung dimasukkan ke dalam satu folder, mis. "Gabung"

Jalankan Macronya, kemudian pilih folder "Gabung" tersebut dan klik OK.

Salam,
HK



On Wednesday, 24 March 2021, 03:24:33 pm GMT+7, henri.hutagalung <[hidden email]> wrote:


Hello para suhu sekalian,

Mohon bantuannya untuk solusi untuk menggabungkan data dari beberapa workbook ke dalam 1 worksheet baru.

Saya sering bekerja dengan puluhan workbook dengan format dan jumlah kolom yang sama tetapi jumlah raw ber variasi.

Contoh file MFR-A.xlsx, MFR-B.xlsx, MFR-C.xlsx datanya di gabung jadi satu di HASIL GABUNGAN.xlsx
Terima kasih untuk bantuannya suhu

Gabung multiple workbook.jpg

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/dc1cad61-f026-4205-b511-a213bbcf8f19n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/280274976.149169.1616654441678%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1475379449.620699.1616742447078%40mail.yahoo.com.

re_HASIL GABUNGAN.xlsm (25K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Gabung multiple workbook dalam 1 worksheet

Kid
Administrator
In reply to this post by henri.hutagalung
Hai Henri,

Kalau pakai Power Query, bisa seperti yang ada disini.

On Wed, Mar 24, 2021 at 2:56 PM henri.hutagalung <[hidden email]> wrote:
Hello para suhu sekalian,

Mohon bantuannya untuk solusi untuk menggabungkan data dari beberapa workbook ke dalam 1 worksheet baru.

Saya sering bekerja dengan puluhan workbook dengan format dan jumlah kolom yang sama tetapi jumlah raw ber variasi.

Contoh file MFR-A.xlsx, MFR-B.xlsx, MFR-C.xlsx datanya di gabung jadi satu di HASIL GABUNGAN.xlsx
Terima kasih untuk bantuannya suhu

Gabung multiple workbook.jpg

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/dc1cad61-f026-4205-b511-a213bbcf8f19n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPt5ssZJJXt__QN%2BMyWKLiV_zTkSSKS4sNy2cmYBwhFnyQ%40mail.gmail.com.