true power of MS excel. update: PowerBI

[ratmysterio]

Re: MS excel reportings, presentations, and vba helping thre

for sharing TS

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

for sharing TS

Thanks. more tutorials to come. sana magshare din kayo.

 

[dhok_si]

Re: MS excel reportings, presentations, and vba helping thre

hi mga tol share ko lng nala2man ko sa excel 2010..ngaun araw na to tu2ro ko sa inyo kung paano gumawa ng digital clock sa excel 2010
e2 un code sa vba
Dim running As Boolean

Sub test()

Const QRT As Integer = 4, Year As Integer = 12

Cells(1, 1) = 12 / QRT
Cells(1, 2) = 12 / Year

End Sub

Sub test2()

Dim rng As Range
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
Set rng = Range(Cells(1, 1), Cells(lr, 1))
rng.Font.ColorIndex = 4

End Sub

Sub Clock()

running = Not (running)
Do While running = True
DoEvents
Range("A1") = Now
Loop
End Sub

- - - Updated - - -

kopyahin nyo lng yan..tapos sundin nyo un video na ginawa ko
e2 un link http://www.youtube.com/watch?v=csXhTkHVp08

- - - Updated - - -

e2 pa isang ginawa ko hijri to gregorian calendar
http://www.youtube.com/watch?v=8uUrpmDtLow

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

hi mga tol share ko lng nala2man ko sa excel 2010..ngaun araw na to tu2ro ko sa inyo kung paano gumawa ng digital clock sa excel 2010
e2 un code sa vba
Dim running As Boolean

Sub test()

Const QRT As Integer = 4, Year As Integer = 12

Cells(1, 1) = 12 / QRT
Cells(1, 2) = 12 / Year

End Sub

Sub test2()

Dim rng As Range
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
Set rng = Range(Cells(1, 1), Cells(lr, 1))
rng.Font.ColorIndex = 4

End Sub

Sub Clock()

running = Not (running)
Do While running = True
DoEvents
Range("A1") = Now
Loop
End Sub

- - - Updated - - -

kopyahin nyo lng yan..tapos sundin nyo un video na ginawa ko
e2 un link http://www.youtube.com/watch?v=csXhTkHVp08

- - - Updated - - -

e2 pa isang ginawa ko hijri to gregorian calendar
http://www.youtube.com/watch?v=8uUrpmDtLow

nilagay ko na sa unahan bro yung post mo thanks sa tuts.

 

[rmslive]

Re: MS excel reportings, presentations, and vba helping thre

im back again. ehehe with another question po.

pano ko po ba magagawa ito ng mabilis.

meron po akong old supplier list, with fields id, name.

then meron po ako now new supplier list, na consolidated na ung wala sa new supplier list copy ko from old, pero ung id nung old is bago na sa new.

then meron po kasi ako sheet for Purchased Order, na ang supplier id na kinukuha is old supplier list.

pano ko po mapapalitan ng new supplier list id ung old.

so parang ganito gusto kong gawin

Supplier List Old Supplier List New Purchase order
id name id Name supplier list id old supplier list id new
1 sup1 1 sup2 1 3
2 sup3 2 sup3 2 2
3 sup2 3 sup1 2 2
4 sup11 3 1


so dapat po sa supplier list id new madisplay si 1 = sup1 sa old to new na 3=sup1
nasa isang sheet lang po yan, ang gawin ko nalang po pag nakuha ko po ung output then copy ko nalang ung value sa purchase order sheet talaga. many thanks po.

eto nalang pala ung file, para mas maintindihan. hehe

- - - Updated - - -

https://app.box.com/s/csrr5dke8xo2yvzttgwn

di po ako makapag attach ng file so eto nalang po DL link nung file.

 

[hbert001]

Re: MS excel reportings, presentations, and vba helping thre

pa subscribe..

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

im back again. ehehe with another question po.

pano ko po ba magagawa ito ng mabilis.

meron po akong old supplier list, with fields id, name.

then meron po ako now new supplier list, na consolidated na ung wala sa new supplier list copy ko from old, pero ung id nung old is bago na sa new.

then meron po kasi ako sheet for Purchased Order, na ang supplier id na kinukuha is old supplier list.

pano ko po mapapalitan ng new supplier list id ung old.

so parang ganito gusto kong gawin

Supplier List Old Supplier List New Purchase order
id name id Name supplier list id old supplier list id new
1 sup1 1 sup2 1 3
2 sup3 2 sup3 2 2
3 sup2 3 sup1 2 2
4 sup11 3 1


so dapat po sa supplier list id new madisplay si 1 = sup1 sa old to new na 3=sup1
nasa isang sheet lang po yan, ang gawin ko nalang po pag nakuha ko po ung output then copy ko nalang ung value sa purchase order sheet talaga. many thanks po.

eto nalang pala ung file, para mas maintindihan. hehe

- - - Updated - - -

https://app.box.com/s/csrr5dke8xo2yvzttgwn

di po ako makapag attach ng file so eto nalang po DL link nung file.

hehehe sorry. pero pwede isa pa? di ko magets.

 

[dannyps2]

Re: MS excel reportings, presentations, and vba helping thre

Good day po sa inyo sir kirby21 at sa mga contributor nitong thread na ito...

Tanong po ako ulit..

gusto ko po sana ang user mag send ng report tru FTP program. Example: tapos na sya nag encode, e click nya ngayon yong "SENT REPORT" Button, para yong sheet1 ma send lahat ng data gamit ang FTP program automatically.

salamat po ulit sir..

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

Good day po sa inyo sir kirby21 at sa mga contributor nitong thread na ito...

Tanong po ako ulit..

gusto ko po sana ang user mag send ng report tru FTP program. Example: tapos na sya nag encode, e click nya ngayon yong "SENT REPORT" Button, para yong sheet1 ma send lahat ng data gamit ang FTP program automatically.

salamat po ulit sir..

pano ba ginagawa nyo sa ftp? file sharing ba or? upload and download?

 

[dannyps2]

Re: MS excel reportings, presentations, and vba helping thre

Good morning po sir kirby21, Upload lang po yong sheet1 ng excel.

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

Good morning po sir kirby21, Upload lang po yong sheet1 ng excel.

pano ba? browser ang gamit?

 

[dannyps2]

Re: MS excel reportings, presentations, and vba helping thre

ano po suggestion nyo? kung browser ok din siguro kasi free.

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

ano po suggestion nyo? kung browser ok din siguro kasi free.

file sharing i think. parang within network lang yun kasi ginawa ko dito sa office namin eh.

 

[dannyps2]

Re: MS excel reportings, presentations, and vba helping thre

tru internet po. kasi ganito gusto kung gawin. pag na tapos na sya encode ng report sa sheet1. click nya ngayon yong ''SEND REPORT'' button. para padala nya na dito sa main office yong report ng sheet1.

salamat po!

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

tru internet po. kasi ganito gusto kung gawin. pag na tapos na sya encode ng report sa sheet1. click nya ngayon yong ''SEND REPORT'' button. para padala nya na dito sa main office yong report ng sheet1.

salamat po!

eh di kung ganun. eh di outlook ang the best dyan.

 

[dannyps2]

Re: MS excel reportings, presentations, and vba helping thre

nko! pwede sample sir? wala ako idea kahit kunti sa outlook eh.

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

nko! pwede sample sir? wala ako idea kahit kunti sa outlook eh.

email handler lang naman yun. balak ko pag hit ng button ng send report. automatically attached agad yung sheet 1 sa email and send sa recipient.

sorry di kita mareplyan agad ha. dami ko reports eh. hahaha

 

[dannyps2]

Re: MS excel reportings, presentations, and vba helping thre

Ah ok, wala prob sir d naman madalian yan eh at walang dead line. hehehe.

 

[kirby21]

Re: MS excel reportings, presentations, and vba helping thre

sige try ko gumawa. wait lang ha.

 

[rcpardinas_75]

Re: MS excel reportings, presentations, and vba helping thre

Thanks for sharing. Big help