Rabu, 31 Agustus 2011

]] XL-mania [[ Digest Number 2239

Messages In This Digest (5 Messages)

Messages

1.

Fungsi Macro Penjumlah

Posted by: "Loheng Stone" lohengstone@yahoo.com   lohengstone

Tue Aug 30, 2011 9:55 pm (PDT)



Mohon bantuan para pakar XL ...
Apa fungsi macro yang dipakai untuk menjumlahkan Qty
berdasarkan part.id  
Contoh terlampir
Terima kasih..
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
2a.

Re: insert beberapa row dalam data

Posted by: "Haps" hapsari.stlizbeth@gmail.com   liz_hap

Tue Aug 30, 2011 9:56 pm (PDT)



Hai Mr o'Seno,

Kalau tidak heboh & lucu, bukan mbak siti namanya;
Jaman di asrama dulu kalau dia pulang, asramanya sepppiiiii !!

berikut ini modifikasi makronya; maaf kalau masih ada kekurangan
(misal warna header masih dibiarkan menular ke sisipan paling aas..)

Sub ctv_InsertRowsBeruntun()
' coded by siti Vi / 28 Agu 2011
'-------------------------------
Dim Rng As Range, N As Integer, R As Long
On Err*or* GoTo Ngis*orr*
Set Rng = Application.InputBox("Select Range yg akan diproses.", _
"Input Range Selection", Selection.Address, , , , , 8)
N = CInt(InputBox("Jumlah Baris Per-sekali Insert: ", _
"JumlahRow yg Di-Insertkan", 1))
Set Rng = Rng.CurrentRegion '<<-- modifikasi /Haps
For R = Rng.Rows.Count To 2 Step -1
'--- modifikasi /Haps 29 aug 2011 ---
Rng(R, 1).Resize(N, Rng.Columns.Count).Insert Shift:=xlDown
'--- akhir modifikasi -------------
Next R
Ngisorr:
End Sub

menjalankan makro masih dipermudah dengan *KlikKanan Cell A1* (lihat PopUp
Menu nya)

2011/8/28 OntoSeno <ontoseno84@ymail.com>

> **
>
>
> :D.. :D.. :D.., mbak siti... mbak siti.
> orang nulis macro biasanya kan 'seriosa'...
> tapi di tangan-letik mbak siti bahasa VBA malah bisa dibuat dagelan.
> baru kali ini aku melihat macro bisa super lucu...
>
> saya sudah coba-coba, & hasilnya "nyiip" (sipp) mbak, tetapi
> keperluanku agak lain.
> data: ada 7 kolom (mulai kolom A) dengan Header ada di baris 3.
> Di sebelah kanan tabel selang beberapa kolom ada tabel lagi.
>
> Bgmana modifikasinya agar penyisipan baris baru di kolom A:G
> tidak menyisipi baris baru di kolom setelah AG.
>
> Mbak LadyMacro, jawabannya tidak tergesa-gesa, nanti habis lebaran
> juga "nyip" lah..
>
> matur nuwun,
> selamat idul fitri, mohon maaf lahir batin
>
> o'Seno
> maaf belum dapat melampirkan workbook, karena masih ikut milis
> via web... segera disusulkan.
>
>
> > Sub ctv_InsertRowsBeruntun()
> > ' coded by siti Vi / 28 Agu 2011
> > '-------------------------------
> > ' Dim Jamal As Decimal, Yulian As Boolean
> > ' Dim King As String, Kong as Long
> > ' Dim Jomblo as Single, Jomblowati As Single
> > ' Dim Pasutri As Double, Trouble As Double
> > ' Dim Tali As String
> > ' Dim LampuDepan
> > On *Error* GoTo *Ngisorr*
> >---------------------------------------------------
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3.

rekap data karyawan

Posted by: "rizal" rizalazhar@ymail.com   rizalazhar@ymail.com

Tue Aug 30, 2011 9:56 pm (PDT)



saya orang baru dalam dunia excel, dan harus merekap data..
ada 28 file excel, disetiap file ada 2500 row berisikan data pegawai.
di masing-masing file terdiri dari data yang sama tetapi, di file 1 dan 2 isinya tidak sama
contoh :
file 1 di colom acc number ada isinya
lalu di
file 2 di colom acc number tidak ada isinya,,,

karena proses pendataan sebelumnya dilakukan oleh 4 orang,,,,

nah saya bingung untuk merekap dan menjadikan 1 data itu semua..

apakah bisa dengan vlookup ? contoh nya ?

terimakasih
Rizal

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
4.

Memindahkan karakter tertentu dari bbrp txt file ke excel format

Posted by: "Natalia Irma" inong2108@yahoo.com   inong2108

Tue Aug 30, 2011 9:57 pm (PDT)



Salam kenal,

Mohon bantuan para suhu untuk case di bawah ini:

Saya
punya 3 file txt (data terlampir). Mohon pencerahan bagaimana agar data
di txt file bisa diconvert menjadi data yang terdapat pada file excel. 

Data sebenarnya bisa ada 90 txt file per hari.

terima kasih atas bantuannya

regards
irma
----------


Data pembayaran Juni 2010


1 Ref 123 Ita Mustafa 300,000
2 Ref 236 Handina 2,345,000
3 Ref 456 Mariah 125,000
4 Ref 789 Kiki 1,567,000

----------


Data pembayaran July 2010


1 Ref 777 Mila 300,000
2 Ref 238 Sita 7,333,560

----------


Data pembayaran Aug 2010


1 Ref 877 Mila 500,000
2 Ref 338 Sita 7,333,500
3 Ref 777 Tina 5,666,000
4 Ref 999 Mimi 3,000,000
5 Ref 777 Munah 2,555,800
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
5.

Insert row diantara data tanggal & secara otomatis menambah data tan

Posted by: "Iwan Kesuma" iwan.kesuma@yahoo.com   iwan.kesuma

Tue Aug 30, 2011 10:42 pm (PDT)



Dear Para Master XL,

Mohon bantuannya. Bagaimanakah caranya menyisipkan baris diantara 2 tanggal dan otomatis mengisi baris yg kosong dengan tanggal selanjutnya?

Contoh terlampir.

Regards,
Iwan
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Cat Groups

on Yahoo! Groups

Share pictures &

stories about cats.

Yahoo! Groups

Parenting Zone

Tips for family,

kids and living

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
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| selamat idul fitri, mohon maaf lahir dan batin...                 |
| www.linkedin.com/company/xl-mania                                 |
| ayo pesan buku "mengapa boss benci chart anda"  :D :D :D          |
+-------------------------------------------------------------------+
| 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.friendster.com/xlmania atau...  |
| 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              |
+-------------------------------------------------------------------+
MARKETPLACE
A bad score is 579. A good idea is checking yours at freecreditscore.com.
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.49 0 komentar

[smf_addin] Digest Number 1939

Messages In This Digest (9 Messages)

Messages

1a.

Goggle Docs

Posted by: "wu_ming_sg" nghongchong@hotmail.com   wu_ming_sg

Tue Aug 30, 2011 10:14 am (PDT)



Hi,

Do you think there is a way to integrate this plugin with Google Docs?

Regards,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: Goggle Docs

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Aug 30, 2011 10:43 am (PDT)



Absolutely no way. Google docs doesn't use VBA.

You can do a few of the same things with their APIs though:

http://docs.google.com/support/bin/answer.py?answer=155178

On Tue, Aug 30, 2011 at 10:14 AM, wu_ming_sg <nghongchong@hotmail.com>wrote:

>
> Do you think there is a way to integrate this plugin with Google Docs?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Re: Trouble installing in Excel 2007

Posted by: "yourchef51" yourchef51@hotmail.com   yourchef51

Tue Aug 30, 2011 10:37 am (PDT)



I am by no means an expert but I had issues with Excel 2007 too. Make sure all the spelling and punctuation is as exact as it shows, I capitalized the I in Add-In. Also I had to do some settings adjustment with Internet Explorer. And I tried to add a macro and that blocked it too. I don't know if this is what you are experiencing but this is what I went through. Good Luck.

DJ

--- In smf_addin@yahoogroups.com, "Tony Paterra" <apaterra@...> wrote:
>
> Folks,
> Sorry to be that guy who posts for help on the first install, but I've hit the wall for what I can do myself. This looks like a fantastic tool to do custom data gathering.
>
> I have followed the detailed instructions here:
> http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/
>
> However when I go to type in any of the "RCH" functions I don't see them appearing the way the function list normally would. The little green Excel ball at the top has SMF as "checked" in the Add-ins menu. I've tried opening a new workbook, re-opening Excel, even re-booting Windows. It all shows up the same way - Add-ins shows SMF as enabled, but not of the functions are being loaded when I try to enter in a function. I've also tried fully typing out the function name, but I get an invalid function error from Excel.
>
> Any help would be much appreciated. I'm happy to provide screenshots as well.
>
> I'm running Windows 7 and Excel 2007.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

Re: Is there an smfPricesByDates equivalent for Barchart?

Posted by: "gz_cp" gz_cp@yahoo.com   gz_cp

Tue Aug 30, 2011 10:46 am (PDT)





I downloaded 2.1.2011.04.03 from Work in Progress but the smfWord is giving me #NAME...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I don't see myself doing a function specifically for barchart.com. Partially
> because the format of the data being extracted can be different depending on
> what is being retrieved (e.g. futures vs stocks) or displayed on the chart.
>
> However, you can extract your own data by date with something like:
>
> =0+smfWord(RCHGetWebData("
> http://charts.barchart.com/chart.asp?sym=CLV11&data=A&den=HIGH&vol=Y",
> "value='08/29/11 "),7," ")
>
> ...gives me the close for 08/29/11 for CLV11. However, I believe the
> smfWord() function is only in the beta release of the add-in (in the "Works
> in Progress" folder of the files area).
>
> On Mon, Aug 29, 2011 at 10:42 PM, gz_cp <gz_cp@...> wrote:
>
> >
> > Yahoo doesn't support commodities and currencies. When I put CLV11.NYM
> > into smfPricesByDates it returns NA.
> >
> > The current Barchart template, while accepts commodity futures and
> > currencies, can only take one ticker at a time and is not very easy to
> > process a large number of tickers like the smfPricesByDates.
> >
> > Is there an smfPricesByDates equivalent for Barchart?
> > (Or simply a =Function(Ticker, Date), without taking arrays, which is
> > actually even more flexible)
> >
> > If there is then it would be wonderful and pretty much solve all our
> > problems! (Even there isn't, I still want to say THANK YOU for your
> > fantastic add-ons)
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.

Re: Is there an smfPricesByDates equivalent for Barchart?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Aug 30, 2011 11:02 am (PDT)



Did you exit and restart EXCEL? The SMF add-ins gets loaded when you start
up EXCEL. So just replacing the files alone and trying the new function
would still get you the #NAME! error because the old version of the add-in
would still be loaded.

You can always check to see which version of the add-in is loaded:

=RCHGetElementNumber("Version")

On Tue, Aug 30, 2011 at 10:46 AM, gz_cp <gz_cp@yahoo.com> wrote:

>
> I downloaded 2.1.2011.04.03 from Work in Progress but the smfWord is giving
> me #NAME...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3c.

Re: Is there an smfPricesByDates equivalent for Barchart?

Posted by: "gz_cp" gz_cp@yahoo.com   gz_cp

Tue Aug 30, 2011 11:49 am (PDT)



Fantastic!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Did you exit and restart EXCEL? The SMF add-ins gets loaded when you start
> up EXCEL. So just replacing the files alone and trying the new function
> would still get you the #NAME! error because the old version of the add-in
> would still be loaded.
>
> You can always check to see which version of the add-in is loaded:
>
> =RCHGetElementNumber("Version")
>
> On Tue, Aug 30, 2011 at 10:46 AM, gz_cp <gz_cp@...> wrote:
>
> >
> > I downloaded 2.1.2011.04.03 from Work in Progress but the smfWord is giving
> > me #NAME...
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4a.

Re: Use the plug-in for Commitments of Traders data on futures from

Posted by: "paul messerschmidt" financepaul@gmail.com   fuelspotpaul

Tue Aug 30, 2011 12:55 pm (PDT)



while the link below is not exactly what you are looking for, it does let
you select 'futures only' or 'options and futures'.

as you can see from this chart

http://www.cftc.gov/OCE/WEB/index.htm

<http://www.cftc.gov/OCE/WEB/index.htm>when you add options, you can add 50%
to 100% to the open interest of 'futures only' -- which can paint a very
different market picture.

let the group know what you find

cheers

On Mon, Aug 29, 2011 at 2:22 AM, gz_cp <gz_cp@yahoo.com> wrote:

> **
>
>
> Hi,
>
> Has anyone found a resource where we can use the plug-in to download the
> historical data series of Commitments of Traders (COT) data on futures from
> CFTC?
>
> We have been looking for it for a while and couldn't find it. The Excel
> file downloaded from the CFTC website is not easy to extract into time
> series.
>
> Thanks.
>
>
>

--
-----------------------------------------
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
4b.

Re: Use the plug-in for Commitments of Traders data on futures from

Posted by: "gz_cp" gz_cp@yahoo.com   gz_cp

Tue Aug 30, 2011 2:04 pm (PDT)




This is good but it doesn't seem to provide historical time series.

I have found that on Bigchart you can actually plot CFTC data in the technical section which I think can then be loaded into Excel with the plug-in.

--- In smf_addin@yahoogroups.com, paul messerschmidt <financepaul@...> wrote:
>
> while the link below is not exactly what you are looking for, it does let
> you select 'futures only' or 'options and futures'.
>
> as you can see from this chart
>
> http://www.cftc.gov/OCE/WEB/index.htm
>
> <http://www.cftc.gov/OCE/WEB/index.htm>when you add options, you can add 50%
> to 100% to the open interest of 'futures only' -- which can paint a very
> different market picture.
>
> let the group know what you find
>
> cheers
>
> On Mon, Aug 29, 2011 at 2:22 AM, gz_cp <gz_cp@...> wrote:
>
> > **
> >
> >
> > Hi,
> >
> > Has anyone found a resource where we can use the plug-in to download the
> > historical data series of Commitments of Traders (COT) data on futures from
> > CFTC?
> >
> > We have been looking for it for a while and couldn't find it. The Excel
> > file downloaded from the CFTC website is not easy to extract into time
> > series.
> >
> > Thanks.
> >
> >
> >
>
>
>
> --
> -----------------------------------------
> Paul Messerschmidt
> paul.messerschmidt (skype)
> +1-813-334-8682 (mobile)
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5.

Recent Interview

Posted by: "Gennady Kupershteyn" gennady17@yahoo.com   gennady17

Tue Aug 30, 2011 6:42 pm (PDT)



I did a recent interview for the moneyshow.com. You can read or listen to
it here,
http://www.moneyshow.com/investing/article/44/DailyGuru-24268/3-Recent-IPOs-Worth-Tracking&scode=024328/.
Don't forget to vote a 10 ;o). Feel free to pass on the link.

--
Gennady Kupershteyn

Follow me on Twitter or Capitalist Bull
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

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
MARKETPLACE
A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 03.43 0 komentar

[belajar-excel] Digest Number 1309

Messages In This Digest (4 Messages)

Messages

1a.

Re: append list secara dynamic

Posted by: "STDEV(i)" setiyowati.devi@gmail.com   siti_vi

Tue Aug 30, 2011 3:36 am (PDT)



Jika kita sudah BERANI mengatakan *otomatis *dan *dynamis* tentunya ada
beberapa
syarat yg harus dipenuhi (*diketahui *bahwa ada syarat-syarat-nya)

misalnya
kolom dan baris* List SUmber/Rujukan* akan secara liar bertambah ke kanan
maupun
ke bawah, dengan jumlah Kolom &/ jumlah Baris *yg tidak kita ketahui
sebelumnya*

Syarat 1: paling tidak : di bawah atau di kanan List harus kosong (tidak
dibatasi
oleh HASIL FORMULA atau tabel / daa lain) seperti yg dicontohkan.

FORMULA harus ditulis di range (KOLOM) *yg tidak terbatas jumlah barisnya*
(karena diharapkan akan OTOMATIS menampilkan hasil, kapan saja (yaitu
ketika
List Sumber ditambah (Barisnya mapun Kolomnya)

Yang OTOMATIS itu HASIL FORMULANYA; sedangkan FORMULANYA sendiri *harus *
*sengaja DITULIS*. (=tidak tertulis secara otomatis)
Jika tidak pernah ditulis, tidak akan ada hasilnya.

Jadi* dengan FORMULA*; keinginan penggabung beberapa kolom LIST agar
hasinya
otomatis dan dinamis berkurang/ bertambah dtanya (tapi tetap 1 kolom)
sepertinya
kurang cocok; karena rupanya anda tiak membicarakan / menyadari adanya 2
syarat tsb.

Lebih cocok jika dikerjakan dengan Bukan Formula, misalnya dengan memencet
Tombol
dan hasila tertulis otomatis & dinamis (berupa data konstanta / bukan
formula)
CMIIW.

Mohon dilihat FORMULA di lampiran ( kolom K dan N ) dimana Formula dibantu
oleh
UDF.

~siti

2011/8/30 WIRAnata Kemala Deng <kwiranata@gmail.com>
> dear all para pakar excel,
> mohon bantuannya utk input/advise memecahkan 'trick' untuk menggabungkan
(append)
> list of accounts secara dynamic (tergantung dengan seberapa panjang list
sebelumnya).
>
> Untuk lebih jelas nya mohon refer ke attachment berikut.
> Terima kasih banyak , dan juga Selamat Hari Lebaran :)
> regards, Wira
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Re: membuat ex-cel lebih rapi

Posted by: "Mr. Kid" mr.nmkid@gmail.com   nmkid.family@ymail.com

Tue Aug 30, 2011 8:38 am (PDT)



Coba susun data menjadi lebih normal, kemudian coba fitur pivot table
sebagai tool reporting. Refresh pivot table untuk update data.
Mungkin penampilannya agak berbeda, siapa tahu ada sebagian keinginan yang
bisa tercapai.

Kid.

2011/8/30 <tjahyahartono@yahoo.co.id>

> Kalo ga statis,ga bisa ya
>
>
>
> ==========
> mod: ? ^o^
> ==========
>
>
> -----Original Message-----
> From: "Mr. Kid" <mr.nmkid@gmail.com>
> Date: Tue, 30 Aug 2011 08:20:34
> Subject: Re: [belajar-excel] membuat ex-cel lebih rapi
>
> Apakah jumlah baris data relatif statis ?
>
> Kid.
>
>
>
> 2011/8/30 Tjahya Hartono <tjahyahartono@yahoo.co.id>
> > Dear master ex-cel,
> > Sebelumnya saya ucapkan hari raya Idul fitri bagi yang merayakan,
> > Saya mau tanya membuat ex-cel supaya rapi seperti ini bagaimana caranya
> ya?
> >
> > Terima kasih
> > Tjahya
>
>
> ------------------------------------
>
> ----------------------------------------------------------
> 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
> ----------------------------------------------------------Yahoo!
> Groups Links
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3a.

Penomoran otomatis dan cara mempercepat loading User Form

Posted by: "Harry" hariansyahptk@yahoo.com   hariansyahptk

Tue Aug 30, 2011 12:17 pm (PDT)



Kepada Moderator Belajar-Excel@yahoogroup.com

Mohon pencerahan dan informasi akan pertanyaan saya sebagaimana 2 contoh terlampir mengenai "Penomoran otomatis dan cara mempercepat loading User Form".

Contoh terlampir adalah Worksheet / Workbook akan pertanyaan saya sebelumnya saya telah dijawab oleh moderator (Saya mengucapkan terima kasih akan jawaban tersebut).

Terima kasih,

Harry

N/B:
Untuk teman-2 yang merayakan Idul Fitri 1432 H, "Minal A'idin Wal Faidzin, Mohon Maaf Lahir dan Bathin".
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: Penomoran otomatis dan cara mempercepat loading User Form

Posted by: "hendrik karnadi" hendrikkarnadi@yahoo.com   hendrikkarnadi

Tue Aug 30, 2011 10:35 pm (PDT)



Untuk Contoh 1 pertama, formula =IF(LEN(B2),COUNTA(B$2:B2),"")diganti menjadi =IF(LEN(B2),COUNTA(B$2:B2)+99,"").

Untuk Contoh 2, di komputer saya (specnya terbatas) masih cukup cepat loadingnya.

Salam,
Hendrik Karnadi

________________________________
From: Harry <hariansyahptk@yahoo.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Wednesday, August 31, 2011 2:17 AM
Subject: [belajar-excel] Penomoran otomatis dan cara mempercepat loading User Form

 
Kepada Moderator Belajar-Excel@yahoogroup.com

Mohon pencerahan dan informasi akan pertanyaan saya sebagaimana 2 contoh terlampir mengenai "Penomoran otomatis dan cara mempercepat loading User Form".

Contoh terlampir adalah Worksheet / Workbook akan pertanyaan saya sebelumnya saya telah dijawab oleh moderator (Saya mengucapkan terima kasih akan jawaban tersebut).

Terima kasih,

Harry

N/B:
Untuk teman-2 yang merayakan Idul Fitri 1432 H, "Minal A'idin Wal Faidzin, Mohon Maaf Lahir dan Bathin".
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Y! Groups blog

the best source

for the latest

scoop on Groups.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! Groups

Dog Zone

Connect w/others

who love dogs.

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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
MARKETPLACE
A bad score is 596. A good idea is checking yours at freecreditscore.com.
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 00.33 0 komentar
Langganan: Postingan (Atom)