true power of MS excel. update: PowerBI

[shownoemotions]

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

Pa Bm po ts.. laking tulong po ito skin.. wla po akung background sa excel.. basic usage lng alam ko..
Pag aaralan ko po yung sample nyui., gumagawa po kz ako ngaun ng excel sheet na magagamit ko for monitoring sa stock market..
May nagawa na po ako kso ang haba ng formula ko..pinag combine combine ko mga formula pra lng lumabas ang result na gusto o..
FB po later pag npag aralan ko na tutei nyu.. thanks po ng marami mga lka SB..

 

[dannyps2]

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

na busy siguro si sir kirby21, di na nya na visit ang thread...

 

[dannyps2]

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

Good Day po sa mga contributor nitong thread.

Meron po akong tanong.

meron akong ginawa naka pag browse na ako at na pa display ko na po sa Image1 yong picture na selected ko, gusto ko sana e copy yong picture nasa Image1 doon sa excel sheet1 cell "b2", wala ako idea sa code kung pano. sana po maka help kayo dito..

salamat!

 

[kirby21]

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

Good Day po sa mga contributor nitong thread.

Meron po akong tanong.

meron akong ginawa naka pag browse na ako at na pa display ko na po sa Image1 yong picture na selected ko, gusto ko sana e copy yong picture nasa Image1 doon sa excel sheet1 cell "b2", wala ako idea sa code kung pano. sana po maka help kayo dito..

salamat!

mga guys sorry sobra talaga ko busy ngayon eh.

bro check mo to.
kaw nalang bahala magresize.

gamitan mo nalang ng

with object
.etc
.etc
.etc
.etc
end with

 

[rexelens]

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

patatak muna sir... need ko din eto..thanks

 

[dannyps2]

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

salamat po ulit dito sir kirby21..

 

[kirby21]

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

salamat po ulit dito sir kirby21..

welcome bro and sensya na din di ko pa magawa yung isang project mo. madugo kasi yun. nabusy talaga ko eh.

 

[puuts]

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

Sir,

alam nyo po kung paano magchange ng window? prang Alt-tab i mean, from excel to internet explorer?

 

[dannyps2]

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

ok lang sir, di rin ako titigil hanap ng solution sa project ko, alam ko madugo ito pero di parin ako ma walan ng pag asa. buti nalang andito itong thread mo.

 

[jgzzz]

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

Hi mga sirs,

I am having a trouble lang po kasi sa pag gawa ng report. I have two workbooks po kasi yung 1st is datasource and yung 2nd is yung nag gegenerate ng reports. Ang problem ko lang po kasi is, whenever nag uupdate ako sa 1st sheet and closed yung workbook hindi nag uupdate yung 2nd sheet. Papano po kaya ang gagawin para everytime na may iuupdate yung datasource na sheet ay mauupdate din yung 2nd worksheet ko. Pag inupdate kasi yung 2nd sheet hindi nya kukunin yung values pag naka close yung sheet need pa i open bago ma update. Possible po ba na kahit naka close yung datasource na sheet eh mag uupdate pa din?. Sensya medyo mahaba haha. Thanks po!

 

[cocok1218]

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

TS meron ka bang ASAP utlities installer for excel? Thanks po in advance.

 

[kirby21]

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

Hi mga sirs,

I am having a trouble lang po kasi sa pag gawa ng report. I have two workbooks po kasi yung 1st is datasource and yung 2nd is yung nag gegenerate ng reports. Ang problem ko lang po kasi is, whenever nag uupdate ako sa 1st sheet and closed yung workbook hindi nag uupdate yung 2nd sheet. Papano po kaya ang gagawin para everytime na may iuupdate yung datasource na sheet ay mauupdate din yung 2nd worksheet ko. Pag inupdate kasi yung 2nd sheet hindi nya kukunin yung values pag naka close yung sheet need pa i open bago ma update. Possible po ba na kahit naka close yung datasource na sheet eh mag uupdate pa din?. Sensya medyo mahaba haha. Thanks po!

kailangan mo ng relative formulas. such as vlookup etc etc etc.
pwede mo ba attached?

- - - Updated - - -

TS meron ka bang ASAP utlities installer for excel? Thanks po in advance.

hindi pa ata ako gumamit nun bro. addins ba?

 

[jgzzz]

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

kailangan mo ng relative formulas. such as vlookup etc etc etc.
pwede mo ba attached?

- - - Updated - - -



hindi pa ata ako gumamit nun bro. addins ba?

Hi sir Kirby,

Ang prob nya po kasi kahit gumamit ng mga lookups is basta closed yung datasource na sheet , hindi nag uupdate yung data dun sa next na sheet. This is more on automation na po kasi eh. Kaya ko kasi sya ginawa, para hindi na nag oopen open pa ng iba't ibang excel sheets

 

[dime0420]

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

pabookmark muna po... mukhang maganda dito...

 

[kirby21]

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

Hi sir Kirby,

Ang prob nya po kasi kahit gumamit ng mga lookups is basta closed yung datasource na sheet , hindi nag uupdate yung data dun sa next na sheet. This is more on automation na po kasi eh. Kaya ko kasi sya ginawa, para hindi na nag oopen open pa ng iba't ibang excel sheets

palagay ko need mo ng macro.

 

[dannyps2]

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

sir tanong na naman ako. pano po ba gawin ang special format sa textbox? Example: gusto ko pag open ng userform yong textbox1 naka display na agad yong ganitong format: "DR-###" so papalitan nalang ng user yong number sign ng numbers at di nya pwde palitan yong first "DR-".

 

[kirby21]

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

sir tanong na naman ako. pano po ba gawin ang special format sa textbox? Example: gusto ko pag open ng userform yong textbox1 naka display na agad yong ganitong format: "DR-###" so papalitan nalang ng user yong number sign ng numbers at di nya pwde palitan yong first "DR-".

hehehe lagyan mo nalang ng label sa tabi yung text box. parang ganito
View attachment 160553

 

[St Sinned]

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

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

Master, paturo naman po nito....

 

[aubrey03]

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

hehehe lagyan mo nalang ng label sa tabi yung text box. parang ganito
View attachment 898982

Hi sir kirby Nice thread

Pasali ako ha..

My suggestion for dannyps2:

First set the property "Text" of his textbox to "DR-XXXX", para pag load nung form nandun na yug text format

View attachment 160729

Then double click the textbox to add a vb code na magva validate s entry ng user

Ung code could be something like this:

Private Sub TextBox1_AfterUpdate()

If Left(TextBox1.Text, 3) <> "DR-" Then

MsgBox "Previous entry should start with DR-", vbOKOnly

TextBox1.Value = "DR-" & TextBox1.Value


End If


End Sub


Yun lang po, hope nakatulong ako

 

[kirby21]

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

Master, paturo naman po nito....

ganto lang yun bro oh. hehehe

View attachment 160948

- - - Updated - - -

Hi sir kirby Nice thread

Pasali ako ha..

My suggestion for dannyps2:

First set the property "Text" of his textbox to "DR-XXXX", para pag load nung form nandun na yug text format

View attachment 899507

Then double click the textbox to add a vb code na magva validate s entry ng user

Ung code could be something like this:

Private Sub TextBox1_AfterUpdate()

If Left(TextBox1.Text, 3) <> "DR-" Then

MsgBox "Previous entry should start with DR-", vbOKOnly

TextBox1.Value = "DR-" & TextBox1.Value


End If


End Sub


Yun lang po, hope nakatulong ako

galing gumamit ka ng left. di ko agad sya naisip. hehehe