[belajar-excel] Digest Number 3402

Milis Belajar Microsoft Excel Group

9 Messages

Digest #3402

1a

Re: Rubah Angka by "Dede"

1b

Hyperlink by "Dede"

2

Sabtu,Mingg dan Hari Libur by "Subroto, Matzen"

3a

Re: Fwd: [belajar-excel] Hyperlink [1 Attachment] by "Heru Safrudin" superheruu

3b

Re: Fwd: [belajar-excel] Hyperlink by "Dede"

3c

Re: Fwd: [belajar-excel] Hyperlink by "Heru Safrudin" superheruu

3d

Re: Fwd: [belajar-excel] Hyperlink [1 Attachment] by "Dede"

4a

UDF 4 multiple Cell by "Nang Agus"

4b

Re: UDF 4 multiple Cell by "zainul_ulum[at]yahoo[dot]com" zainul_ulum

Messages

1a

Re: Rubah Angka

Sun Apr 26, 2015 6:10 pm (PDT) . Posted by:

"Dede"

Dear Mr andrie,

Terima kasih feedbacknya, sangat membantu.

Salam,

DD

From: Andrie - sioean2@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 24 April 2015 19:10
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Rubah Angka

Dear DD,

Dicoba rumus berikut :

Kepuluhan : =ROUNDUP(B3,-1)

Keratusan : =ROUNDUP(B3,-2)

Regards,

Andrie

_____

From: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, April 24, 2015 4:33 PM
Subject: [belajar-excel] Rubah Angka [1 Attachment]

Dear BeExceler,

Apa rumus yg tepat untuk kolom warna kuning yah?

Salam

DD

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1b

Hyperlink

Sun Apr 26, 2015 7:46 pm (PDT) . Posted by:

"Dede"

Dear Master Excel,
Mohon pencerahannya pada file terlampir.
Yang diharapkan adalah, pada saat saya klik cell B2 pada sheet "List Kirim GT", kode pada cell D3 sheet "View" berubah menjadi kode yang saya klik di sheet "List Kirim GT".
Begitu selanjutnya....
Saya klik 1000578 di sheet "List Kirim GT", muncul 1000578 di sheet "View".
Saya klik 1000528 di sheet "List Kirim GT", muncul 1000528 di sheet "View".
Demikian penjelasannya, semoga ada kemudahan dibalik kesukaran.
Salam,
DD

________________________________
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

2

Sabtu,Mingg dan Hari Libur

Sun Apr 26, 2015 10:05 pm (PDT) . Posted by:

"Subroto, Matzen"

Assalamu alaikum,

Dear Master Exceller yang semoga Allah melimpahkan Hidayah dan Keberkahan NYA,

Beginih ceritanya, saya punya banyak Customer dan masing2 Customer berbeda jumlah hari jatuh temponya, gimana cara agar jatuh temponya tanpa di tambah hari Sabtu,Minggu, dan hari libur
Contoh soal,
Saya cetak DO, hari rabu 8/4/15, dan baru sampai di tempat hari jumat 17/4/15
Sedangkan jatuh tempo nya adalah 7hari, kalau saya hanya hitung tanggal 18/4/15 di kurang tanggal 8/4/15, adalah 9 hari karena di tambah dengan hari Saatu dan Minggu, serta 1 hari libur

Mohon pencerahannya agar saya bisa menghitung hari jumlah jatuh tempo sebenarnya di awali dengan hari tanggal/hari cetak DO tersebut tanpa di tambah hari libur tersebut

Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan

Wassalamu alaikum
Terima Kasih

Matzen

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

3a

Re: Fwd: [belajar-excel] Hyperlink [1 Attachment]

Sun Apr 26, 2015 10:06 pm (PDT) . Posted by:

"Heru Safrudin" superheruu

Dear DD,

Bagaimana kalau cell D3 di sheets View diisi formula berikut :
=cell("contents")
Kemudian sebelum klik hyperlink arahkan ke cell yg berisi nomor yg
diinginkan kemudian tekan F2{edit} kemudian tekan Enter. Setelah itu baru
klik hyperlinknya

Wassalam,

Heru Safrudin
PT. BISI International, Tbk.

> > Dari: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <
belajar-excel@yahoogroups.com>
> > Tanggal: 2015 4 27 09:54
> > Subjek: [belajar-excel] Hyperlink [1 Attachment]
> > Kepada: <belajar-excel@yahoogroups.com>
> >
> >
> >
> >
> > Dear Master Excel,
> >
> > Mohon pencerahannya pada file terlampir.
> >
> > Yang diharapkan adalah, pada saat saya klik cell B2 pada sheet "List
Kirim GT", kode pada cell D3 sheet "View" berubah menjadi kode yang saya
klik di sheet "List Kirim GT".
> >
> > Begitu selanjutnya....
> >
> > Saya klik 1000578 di sheet "List Kirim GT", muncul 1000578 di sheet
"View".
> >
> > Saya klik 1000528 di sheet "List Kirim GT", muncul 1000528 di sheet
"View".
> >
> > Demikian penjelasannya, semoga ada kemudahan dibalik kesukaran.
> >
> > Salam,
> >
> > DD
> >
> >
> >
> >
> > ________________________________
> > This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual to whom it is addressed. If
you have received this email in error please send it back to the person
that sent it to you. Any views or opinions presented are solely those of
its author and do not necessarily represent those of NABATI or any of its
subsidiary companies. Unauthorized publication, use, dissemination,
forwarding, printing or copying of this email and its associated
attachments is strictly prohibited.
> >
> >

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3b

Re: Fwd: [belajar-excel] Hyperlink

Sun Apr 26, 2015 11:20 pm (PDT) . Posted by:

"Dede"

Dear Mr Heru,

Terima kasih atas masukannya, tapi koq ga bisa yah?. Bisa kirim lampirannya... atau mungkin ada cara lain?

Karena report ini mau saya kirimkan ke Bos saya sehingga menghindari hal-hal yang sifatnya ribet.

Salam,

DD

From: Heru Safrudin superheruu@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 27 April 2015 11:37
To: belajar-excel@yahoogroups.com
Subject: Re: Fwd: [belajar-excel] Hyperlink

Dear DD,

Bagaimana kalau cell D3 di sheets View diisi formula berikut :
=cell("contents")
Kemudian sebelum klik hyperlink arahkan ke cell yg berisi nomor yg diinginkan kemudian tekan F2{edit} kemudian tekan Enter. Setelah itu baru klik hyperlinknya

Wassalam,

Heru Safrudin
PT. BISI International, Tbk.

> > Dari: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
> > Tanggal: 2015 4 27 09:54
> > Subjek: [belajar-excel] Hyperlink [1 Attachment]
> > Kepada: <belajar-excel@yahoogroups.com>
> >
> >
> >
> >
> > Dear Master Excel,
> >
> > Mohon pencerahannya pada file terlampir.
> >
> > Yang diharapkan adalah, pada saat saya klik cell B2 pada sheet "List Kirim GT", kode pada cell D3 sheet "View" berubah menjadi kode yang saya klik di sheet "List Kirim GT".
> >
> > Begitu selanjutnya....
> >
> > Saya klik 1000578 di sheet "List Kirim GT", muncul 1000578 di sheet "View".
> >
> > Saya klik 1000528 di sheet "List Kirim GT", muncul 1000528 di sheet "View".
> >
> > Demikian penjelasannya, semoga ada kemudahan dibalik kesukaran.
> >
> > Salam,
> >
> > DD
> >
> >
> >
> >
> > ________________________________
> > This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
> >
> >

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3c

Re: Fwd: [belajar-excel] Hyperlink

Mon Apr 27, 2015 12:15 am (PDT) . Posted by:

"Heru Safrudin" superheruu

Kalau cuma seperti terlampir yg dimaksud, itu uda jalan

Wassalam,

Heru Safrudin
PT. BISI International, Tbk.
Pada 2015 4 27 13:20, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <
belajar-excel@yahoogroups.com> menulis:

>
>
> Dear Mr Heru,
>
>
>
> Terima kasih atas masukannya, tapi koq ga bisa yah?. Bisa kirim
> lampirannya... atau mungkin ada cara lain?
>
> Karena report ini mau saya kirimkan ke Bos saya sehingga menghindari
> hal-hal yang sifatnya ribet.
>
>
>
> Salam,
>
> DD
>
>
>
> *From:* Heru Safrudin superheruu@gmail.com [belajar-excel] [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* 27 April 2015 11:37
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: Fwd: [belajar-excel] Hyperlink
>
>
>
>
>
>
>
> Dear DD,
>
> Bagaimana kalau cell D3 di sheets View diisi formula berikut :
> =cell("contents")
> Kemudian sebelum klik hyperlink arahkan ke cell yg berisi nomor yg
> diinginkan kemudian tekan F2{edit} kemudian tekan Enter. Setelah itu baru
> klik hyperlinknya
>
> Wassalam,
>
> Heru Safrudin
> PT. BISI International, Tbk.
>
> > > Dari: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> > > Tanggal: 2015 4 27 09:54
> > > Subjek: [belajar-excel] Hyperlink [1 Attachment]
> > > Kepada: <belajar-excel@yahoogroups.com>
> > >
> > >
> > >
> > >
> > > Dear Master Excel,
> > >
> > > Mohon pencerahannya pada file terlampir.
> > >
> > > Yang diharapkan adalah, pada saat saya klik cell B2 pada sheet "List
> Kirim GT", kode pada cell D3 sheet "View" berubah menjadi kode yang saya
> klik di sheet "List Kirim GT".
> > >
> > > Begitu selanjutnya....
> > >
> > > Saya klik 1000578 di sheet "List Kirim GT", muncul 1000578 di sheet
> "View".
> > >
> > > Saya klik 1000528 di sheet "List Kirim GT", muncul 1000528 di sheet
> "View".
> > >
> > > Demikian penjelasannya, semoga ada kemudahan dibalik kesukaran.
> > >
> > > Salam,
> > >
> > > DD
> > >
> > >
> > >
> > >
> > > ________________________________
> > > This e-mail and any files transmitted with it are confidential and
> intended solely for the use of the individual to whom it is addressed. If
> you have received this email in error please send it back to the person
> that sent it to you. Any views or opinions presented are solely those of
> its author and do not necessarily represent those of NABATI or any of its
> subsidiary companies. Unauthorized publication, use, dissemination,
> forwarding, printing or copying of this email and its associated
> attachments is strictly prohibited.
> > >
> > >
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3d

Re: Fwd: [belajar-excel] Hyperlink [1 Attachment]

Mon Apr 27, 2015 12:49 am (PDT) . Posted by:

"Dede"

Dear Mr Heru,

Ternyata jalan formulanya, tapi klo tanpa tekan F2 bisa gak yah...(dengan VBA mungkin)

Mungkin ada masukan dari Master yang lain, plis...

Salam,

DD

From: Heru Safrudin superheruu@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 27 April 2015 14:00
To: belajar-excel@yahoogroups.com
Subject: RE: Fwd: [belajar-excel] Hyperlink [1 Attachment]

Kalau cuma seperti terlampir yg dimaksud, itu uda jalan

Wassalam,

Heru Safrudin
PT. BISI International, Tbk.

Pada 2015 4 27 13:20, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Mr Heru,

Terima kasih atas masukannya, tapi koq ga bisa yah?. Bisa kirim lampirannya... atau mungkin ada cara lain?

Karena report ini mau saya kirimkan ke Bos saya sehingga menghindari hal-hal yang sifatnya ribet.

Salam,

DD

From: Heru Safrudin superheruu@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 27 April 2015 11:37
To: belajar-excel@yahoogroups.com
Subject: Re: Fwd: [belajar-excel] Hyperlink

Dear DD,

Bagaimana kalau cell D3 di sheets View diisi formula berikut :
=cell("contents")
Kemudian sebelum klik hyperlink arahkan ke cell yg berisi nomor yg diinginkan kemudian tekan F2{edit} kemudian tekan Enter. Setelah itu baru klik hyperlinknya

Wassalam,

Heru Safrudin
PT. BISI International, Tbk.

> > Dari: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
> > Tanggal: 2015 4 27 09:54
> > Subjek: [belajar-excel] Hyperlink [1 Attachment]
> > Kepada: <belajar-excel@yahoogroups.com>
> >
> >
> >
> >
> > Dear Master Excel,
> >
> > Mohon pencerahannya pada file terlampir.
> >
> > Yang diharapkan adalah, pada saat saya klik cell B2 pada sheet "List Kirim GT", kode pada cell D3 sheet "View" berubah menjadi kode yang saya klik di sheet "List Kirim GT".
> >
> > Begitu selanjutnya....
> >
> > Saya klik 1000578 di sheet "List Kirim GT", muncul 1000578 di sheet "View".
> >
> > Saya klik 1000528 di sheet "List Kirim GT", muncul 1000528 di sheet "View".
> >
> > Demikian penjelasannya, semoga ada kemudahan dibalik kesukaran.
> >
> > Salam,
> >
> > DD
> >
> >
> >
> >
> > ________________________________
> > This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
> >
> >

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4a

UDF 4 multiple Cell

Sun Apr 26, 2015 10:49 pm (PDT) . Posted by:

"Nang Agus"

Asalamualaikum warahmatullah.

Dear member B-Excel.

mohon bantuannya.
Dapatkah dibuat sebuah UDF yang hasilnya dapat diletakkan pada 4 cell?

misalnya saya pasang Rumus UDF di cell C1, nanti hasilnya ada di cell D1,
E1, F1.

Public Function rumus(a as long, b as long) as long
dim rumusb as long
dim rumusc as long
dim rumusd as long
rumus = a + b
rumusb = a - b
rumusc = a*b
rumusd = a/b
end function

bagaimana caranya agar rumusb diletakkan di D1, rumusc di E1 dan rumusd di
F1

terima kasih
wasalamualaikum warahmatullah

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4b

Re: UDF 4 multiple Cell

Sun Apr 26, 2015 11:39 pm (PDT) . Posted by:

"zainul_ulum[at]yahoo[dot]com" zainul_ulum

Wa'alaikum salam warhmatullaahi wa barakaatuh…

aku rubah sedikit fungsi nya menjadi

Public Function rumus_abc(a As Long, b As Long) As Double()

Dim rumusb As Double

Dim rumusc As Double

Dim rumusd As Double

rumus = a + b

rumusb = a - b

rumusc = a * b

If b = 0 Then

rumusd = 0

Else

rumusd = a / b

End If

Dim Hasil(4) As Double

Hasil(0) = rumus

Hasil(1) = rumusb

Hasil(2) = rumusc

Hasil(3) = rumusd

rumus_abc = Hasil

End Function

Jika input ada di cell A1 dan B1

di cell C1 =rumus_abc(A1,B1)

kemudian block C1:F1, tekan F2 lalu control+shift+enter.

semoga membantu

#Nang Agus, bulan mei aku mau mudik ke kudus, kopi darat di opor sunggingan yukkkk

Wassalam

=zainul

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, April 27, 2015 12:42 PM
To: BExcel
Subject: [belajar-excel] UDF 4 multiple Cell

Asalamualaikum warahmatullah.

Dear member B-Excel.

mohon bantuannya.

Dapatkah dibuat sebuah UDF yang hasilnya dapat diletakkan pada 4 cell?

misalnya saya pasang Rumus UDF di cell C1, nanti hasilnya ada di cell D1, E1, F1.

Public Function rumus(a as long, b as long) as long

dim rumusb as long
dim rumusc as long
dim rumusd as long
rumus = a + b

rumusb = a - b

rumusc = a*b

rumusd = a/b

end function

bagaimana caranya agar rumusb diletakkan di D1, rumusc di E1 dan rumusd di F1

terima kasih

wasalamualaikum warahmatullah

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use