true power of MS excel. update: PowerBI

[berylx]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Good Morning po mga ka SB!

ask ko lang po sana kung possible mangyari yung gusto kong output sa scroll graph
http://d-h.st/rocz ito po yung link nung file

medyo may mali pa po and gusto ko po sanang ihingi ng tulong kung paano magiging possible ito

yung scroll po nya sa ang nangyayari po is Day1 vs. Day2 then next scroll po is Day2 vs. Day3 then, Day3 vs. Day4

ask ko lang po sana if possible na maging Day1 vs. Day2 then next scroll po sana is Day1 vs. Day2 vs. Day3 then Day1 vs. Day2 vs. Day3 vs. Day4

hangang day 6 po

maraming salamat po

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

So bale magiging 6 columns po ang mangyayari, from day 1 to day 6?

if that so, baka gumamit tayu ng VBA

- - - Updated - - -

View attachment 246144

To set up VBA

Open your workbook (Microsoft Excel File)

Enable your Developer Tab (see here how to Show your Developer Tab on the ribbon)

You have to allow or enable the settings for macro to run the code

(File --> Option --> Trust Center -->Trust Center Settings --> Macro Settings --> Check "Enable all macros")

You can see this tutorial in my blog
http://account-it.blogspot.com/

As you can see the "simplified if" and "nested if" click view code mo lang para mkta mo yung code

Please see this file VBA
https://drive.google.com/open?id=0B_gWAZ4O0Nh8TzVodDkzUTl0aXM

 

[nash0260]

Re: MS excel formula, programming, analysis, presentation and tutorials.

So bale magiging 6 columns po ang mangyayari, from day 1 to day 6?

if that so, baka gumamit tayu ng VBA

- - - Updated - - -

View attachment 1084759

To set up VBA

Open your workbook (Microsoft Excel File)

Enable your Developer Tab (see here how to Show your Developer Tab on the ribbon)

You have to allow or enable the settings for macro to run the code

(File --> Option --> Trust Center -->Trust Center Settings --> Macro Settings --> Check "Enable all macros")

You can see this tutorial in my blog
http://account-it.blogspot.com/

As you can see the "simplified if" and "nested if" click view code mo lang para mkta mo yung code

Please see this file VBA
https://drive.google.com/open?id=0B_gWAZ4O0Nh8TzVodDkzUTl0aXM

Nice Blogs

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Nice Blogs

hehe thanks

 

[4Tap]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Hello TS,

na-try q po ung Graphs with Controls and ang ganda

ito po question q po:

Ung gnwa po na Graphs with Controls na excel, pde q po b syang mailagay sa Power Point Presentation?

Gsto q po sana is ung working ung buttons.

I google for the problem and I thought gagana ung kung as Object q sya lalagay sa PPS pero prang copy paste lng dn knlbsan.

Salamat po

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Hello TS,

na-try q po ung Graphs with Controls and ang ganda

ito po question q po:

Ung gnwa po na Graphs with Controls na excel, pde q po b syang mailagay sa Power Point Presentation?

Gsto q po sana is ung working ung buttons.

I google for the problem and I thought gagana ung kung as Object q sya lalagay sa PPS pero prang copy paste lng dn knlbsan.

Salamat po

Pero natry mo na po yung sa object sa power point? tapos create from file tapos nakalink?

or gusto mo yung real time tlga? yung tipong kaht nakaslideshow na pede kang magchange ng data thru power point?

View attachment 246208

 

[kirby21]

Re: MS excel formula, programming, analysis, presentation and tutorials.

thanks mga madalas na tumambay dito. big help po kayo sakin. busy mode po kasi eh.

hehehehe

 

[tilawiko]

Re: MS excel formula, programming, analysis, presentation and tutorials.

you mean sa "system" nakaprogram as vba pero ms access?, bale ano po ba exactly ang problem? thanks

yon poh..bale, ang problema q poh..paano ko eto madeploy? ung bale nasa labas na gud ang system..nakashort cut na..

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

thanks mga madalas na tumambay dito. big help po kayo sakin. busy mode po kasi eh.

hehehehe

That's ok TS, thanks dto sa thread

- - - Updated - - -

yon poh..bale, ang problema q poh..paano ko eto madeploy? ung bale nasa labas na gud ang system..nakashort cut na..

sorry sir, pero may screenshot ka po ba para magets ko lalo , thanks

 

[berylx]

Re: MS excel formula, programming, analysis, presentation and tutorials.

So bale magiging 6 columns po ang mangyayari, from day 1 to day 6?

if that so, baka gumamit tayu ng VBA

- - - Updated - - -

View attachment 1084759

To set up VBA

Open your workbook (Microsoft Excel File)

Enable your Developer Tab (see here how to Show your Developer Tab on the ribbon)

You have to allow or enable the settings for macro to run the code

(File --> Option --> Trust Center -->Trust Center Settings --> Macro Settings --> Check "Enable all macros")

You can see this tutorial in my blog
http://account-it.blogspot.com/

As you can see the "simplified if" and "nested if" click view code mo lang para mkta mo yung code

Please see this file VBA



https://drive.google.com/open?id=0B_gWAZ4O0Nh8TzVodDkzUTl0aXM

paano po ako magkakaron ng access sa Gdrive

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

paano po ako magkakaron ng access sa Gdrive

try mo na po ulit sir

or try mo po nagaatach ako dito

 

[berylx]

Re: MS excel formula, programming, analysis, presentation and tutorials.

try mo na po ulit sir

or try mo po nagaatach ako dito

thank you po! pwede po ba ako mag link ng question katulad po ng question ni 4tap kung paano po mkakapag scroll kpag inattach sa Ppoint maraming salamat po sa tulong nyo medyo hindi po ako familiar sa VBA at yung simpleng indexing lang po pero sobrang laking tulong po

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

thank you po! pwede po ba ako mag link ng question katulad po ng question ni 4tap kung paano po mkakapag scroll kpag inattach sa Ppoint maraming salamat po sa tulong nyo medyo hindi po ako familiar sa VBA at yung simpleng indexing lang po pero sobrang laking tulong po

You're welcome pero ok na yung file na inatach ko? magtanong ka na lang po about sa programming ng vba, lagi naman po akong online, or kung gusto mong ibang topic, visit my blogsite

http://account-it.blogspot.com/

haha medyo konti palang articles ko rto, bago pa lang kasi, pero dadamihan ko pa haha

yung kay 4tap, medyo hindi ko nagets eh,

pero ang pagkakaintindi ko rto, is parang real time? magsccroll ka mismo sa powerpoiint, ?

 

[berylx]

Re: MS excel formula, programming, analysis, presentation and tutorials.

You're welcome pero ok na yung file na inatach ko? magtanong ka na lang po about sa programming ng vba, lagi naman po akong online, or kung gusto mong ibang topic, visit my blogsite

http://account-it.blogspot.com/

haha medyo konti palang articles ko rto, bago pa lang kasi, pero dadamihan ko pa haha

yung kay 4tap, medyo hindi ko nagets eh,

pero ang pagkakaintindi ko rto, is parang real time? magsccroll ka mismo sa powerpoiint, ?

opo na solve po at maraming salamat po ulit

opo yun din po sana ang gusto kong malaman if possible po na kpag nag attach ako ng cell ng excel sa powerpoint including yung scroll.. mag fufunction po sya katulad nung test-00 na file na magaadjust po ng graph from day to day basis na data

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

opo na solve po at maraming salamat po ulit

opo yun din po sana ang gusto kong malaman if possible po na kpag nag attach ako ng cell ng excel sa powerpoint including yung scroll.. mag fufunction po sya katulad nung test-00 na file na magaadjust po ng graph from day to day basis na data

alright let's see about that, haha try ko muna sir kung pwede.

 

[berylx]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Sige po.. Malaking tulong na po yung sa graph

nagkaron lang din po ako ng idea lalo na po sa pagprepresent ng data medyo maganda po sana yung sa scroll ng graph

 

[lovely14]

Re: MS excel formula, programming, analysis, presentation and tutorials.

Sige po.. Malaking tulong na po yung sa graph

nagkaron lang din po ako ng idea lalo na po sa pagprepresent ng data medyo maganda po sana yung sa scroll ng graph

pero tanong ko lang po ulit, natry nyu na ba ung maginsert ng object sa powerpoint?
tapos ililink na lng?

- - - Updated - - -

opo na solve po at maraming salamat po ulit

opo yun din po sana ang gusto kong malaman if possible po na kpag nag attach ako ng cell ng excel sa powerpoint including yung scroll.. mag fufunction po sya katulad nung test-00 na file na magaadjust po ng graph from day to day basis na data

Activate mo muna ung VBA mo sir para magrun ung code (Powerpoint tapos yung sa Excel)

Download mo yung nakaatach na file

buksan mo itong dalwang file
* vba ppp (powerpoint)
* Test Excel VBA (excel)

Bale ang pagbubukas , paki-una munang buksan yung vba ppp (powerpoint)
tapos right click mo yung picture dyn
hanapin mo yung "Linked-Macro Enabled Worksheet Object" tapos click open



tapos punta ka run sa powerpoint, magslide show ka na, tapos click mo lang yung scroll bar.

Pakitry muna sir, kasi gamit ko ay office 2013 eh, ano po ba gamit mo sir?

Medyo mabagal lang to kasi need magupdate every time when you change your scrollbar

 

[Jhon Jhit]

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

very informative

 

[markjosefff]

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

Good evening!
Need help po, eto po:
Yung gusto ko mangyare, diba po sa P4 pati P5 meron values? Ngayon, pag mag iinput ako ng new value sa P4 at P5, gusto ko ma-move yung old value sa L4 at L5.
Pwede po ba yung ganun? Thanks!

 

[Shaider19]

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

It's an interesting thread...