true power of MS excel. update: PowerBI

[Jason Gantala]

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

wow! very fruitful thread for me

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

yan sir sana naka attached po patulong ako mga sir pano ba lalagyan ng conditional formatting to
yung pag naka received ako ng amount highest than the req. eh mawawala yung blink nya

- - - Updated - - -

admin patulong po ako sna po makita nyo ito post ko.

pacheck attachment boss. if statement at yung conditional formatting.

thanks

 

[Arleth]

Re: MS excel we give solutions. formula, codes and tutorials.

hello po pahelp naman , kapag nagoopen ako ng excel eto po lumalabas: there was a problem sending the command to the program... paano po gagawin ko o solution for that problem, thanks po sa makakatulong .
View attachment 228585

nagunstall at reinstall na ako ganun parin po, sa excel lang naman ganun pero sa word o powerpoint hindi naman,

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

hello po pahelp naman , kapag nagoopen ako ng excel eto po lumalabas: there was a problem sending the command to the program... paano po gagawin ko o solution for that problem, thanks po sa makakatulong .
View attachment 1057328

nagunstall at reinstall na ako ganun parin po, sa excel lang naman ganun pero sa word o powerpoint hindi naman,

missing files po ata yan try nyo po mag bukas ng new excel or ibang excel file kung nagana po means sira ung file na inoopen mo po

 

[neil115]

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

patulong naman... nag iinsert kase aq ng "Shockwave Flash Object" sa excel.. in short flash games... pag na instert ko na xa ung flash games tapos na edit ung properties....pag nag na-isave ko na xa tapos inopen ko ulit... ung ScaleMode nya na dating 0 (ShowAll) nagiging "ScaleMode = 3 (NoScale)"..... nag try nq nabuguhin to sa dati pero everytime na reopen ko ung excel bumabalik sa ScaleMode=3... patulong naman po....

View attachment 1056556

pa tulong nmn po tong problem ko sa taas.... di ko kase mgwan ng paraan eh...

 

[99newbreed]

Re: MS excel we give solutions. formula, codes and tutorials.

pacheck attachment boss. if statement at yung conditional formatting.

thanks

sir nakita ko na po. maraming salamt sir kirby
hindi po ba talaga siya magiging blinking cells?
pero ok po yung condition sir naglagay lang po kasi ako ng blinking para maka add ng konti attraction.

 

[nash0260]

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

licecap bro.

paps pde ka mag provide ng link ng licecap ? ung direct link ty po

- - - Updated - - -

sir nakita ko na po. maraming salamt sir kirby
hindi po ba talaga siya magiging blinking cells?
pero ok po yung condition sir naglagay lang po kasi ako ng blinking para maka add ng konti attraction.

mern sa conditional format na may icon try mo din un

 

[muneyuki04]

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

pa bookmarked muna nito ts!!!!

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

hello po pahelp naman , kapag nagoopen ako ng excel eto po lumalabas: there was a problem sending the command to the program... paano po gagawin ko o solution for that problem, thanks po sa makakatulong .
View attachment 1057328

nagunstall at reinstall na ako ganun parin po, sa excel lang naman ganun pero sa word o powerpoint hindi naman,

anong bit ang excel mo? check mo vs sa OS mo.

- - - Updated - - -

sir nakita ko na po. maraming salamt sir kirby
hindi po ba talaga siya magiging blinking cells?
pero ok po yung condition sir naglagay lang po kasi ako ng blinking para maka add ng konti attraction.

di na yun. actually binura ko na nga yung buong macro eh. hahaha. napansin ko yung inaassign mo na magblink para sa certain na cells lang. babagal nga talaga yun. tapos isa isa pa.

- - - Updated - - -

paps pde ka mag provide ng link ng licecap ? ung direct link ty po

- - - Updated - - -



mern sa conditional format na may icon try mo din un

nagreformat ako ng pc. takte di ko naback up yun. hahaha.

 

[nash0260]

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

pwede naman siguro. deeper knowledge siguro. ibig sabihin di pa tayo magagaling. hehehe

para sa mga gusto magsimula mag programming.ito ang best book. i started with this book. while studying gumawa ng mga projects at tumambay dito. its much easier to digest the book that way.

http://filepi.com/i/brhLZjJ

nice book paps nakuha ko dito ung pano mag copy paste eeheheheh sheet1 to sheet 2 mano mano

sample ba ung table ko gusto ko lng eh ung first row un na copy sia hehehe thx thx

- - - Updated - - -

anong bit ang excel mo? check mo vs sa OS mo.

- - - Updated - - -






di na yun. actually binura ko na nga yung buong macro eh. hahaha. napansin ko yung inaassign mo na magblink para sa certain na cells lang. babagal nga talaga yun. tapos isa isa pa.

- - - Updated - - -




nagreformat ako ng pc. takte di ko naback up yun. hahaha.

pde po bang pa dl at palagay po dito pra ung iba dn maka dl sa may gusto ^^,

 

[99newbreed]

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

oo sir napansin ko nga nawala yung macro ko hehe.
pero maraming salamat pa din sir hindi ko na gagamitin yung blinking cells.
galing talaga ni sir kirby
thank you po.

 

[Arleth]

Re: MS excel we give solutions. formula, codes and tutorials.

missing files po ata yan try nyo po mag bukas ng new excel or ibang excel file kung nagana po means sira ung file na inoopen mo po

wala din po sir, ganun lahat ng files ng excel ko, tapos po ang gagawin ko na lang idadrag ko yung files sa nakaopen na excel umuokey naman,

 

[kirby21]

Re: MS excel we give solutions. formula, codes and tutorials.

wala din po sir, ganun lahat ng files ng excel ko, tapos po ang gagawin ko na lang idadrag ko yung files sa nakaopen na excel umuokey naman,

registry files i think. yung root .exe file ng excel mo. baguhin mo ayon sa compatiblity, from properties. tapos i set mo nalang sya ng ganun.

 

[ackidcat]

Re: MS excel we give solutions. formula, codes and tutorials.

good day mga sir .. gusto ko lang sana patulong..

may ginagawa kasi ako need ko lang ng macro or vba.


pag na click yung botton ganto mangyayare

if cell a1 is equal to ab202 and cell c3 contains "payment in future month"
then
color row green
else
color row red

2nd scenario

if cell a1 is equal to cd301 and cell c3 contains "member cancelled" and "still has credit"
or
cell a1 is equal to cd301 and cell c3 contains "member effective" and "still has credit"
then
color row green
else red

sana may makatulong maraming salamat.

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

good day mga sir .. gusto ko lang sana patulong..

may ginagawa kasi ako need ko lang ng macro or vba.


pag na click yung botton ganto mangyayare

if cell a1 is equal to ab202 and cell c3 contains "payment in future month"
then
color row green
else
color row red

2nd scenario

if cell a1 is equal to cd301 and cell c3 contains "member cancelled" and "still has credit"
or
cell a1 is equal to cd301 and cell c3 contains "member effective" and "still has credit"
then
color row green
else red

sana may makatulong maraming salamat.

eto paps sana makatulong sau kaso hindi siya macro or vb code ung sa 2nd scenario mo ganun dn lang gagawin mo sa gnawa ko sa 1 scenario mo

- - - Updated - - -

pde po bang makahingi ng code macro for changing the old hyperlink destination to new destination hyperlink thank you advance

 

[ackidcat]

Re: MS excel we give solutions. formula, codes and tutorials.

maraming salamat paps..

pero pepede ba na ilagay lahat ng formula na yun sa iisang cell lang ?

kaya sana gusto ko sa VBA..

 

[chale caster]

Re: MS excel we give solutions. formula, codes and tutorials.

thank you sir... maganda ito, mas lalong lalawak yung excel idea dito. thanks

 

[nash0260]

Re: MS excel we give solutions. formula, codes and tutorials.

maraming salamat paps..

pero pepede ba na ilagay lahat ng formula na yun sa iisang cell lang ?

kaya sana gusto ko sa VBA..

drag down mo na lng matik na po ung calc nyan pati ung sa conditional... ung sa vb kase d ko pa masyadong kabisado kaya un

 

[ackidcat]

Re: MS excel we give solutions. formula, codes and tutorials.

ibig ko sabhin masyadong hahaba yung formula para dun .. sinubukan ko nadin kasi yan kaso gumugulo na habang humahaba kaya gusto ko sana ng naka vba or macro sya.. patulong naman po sa mga marurunong salamat ..

 

[acelleb]

Re: MS excel we give solutions. formula, codes and tutorials.

good day mga sir .. gusto ko lang sana patulong..

may ginagawa kasi ako need ko lang ng macro or vba.


pag na click yung botton ganto mangyayare

if cell a1 is equal to ab202 and cell c3 contains "payment in future month"
then
color row green
else
color row red

2nd scenario

if cell a1 is equal to cd301 and cell c3 contains "member cancelled" and "still has credit"
or
cell a1 is equal to cd301 and cell c3 contains "member effective" and "still has credit"
then
color row green
else red

sana may makatulong maraming salamat.

Here TS kindly check.