true power of MS excel. update: PowerBI

[dannyps2]

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

Sir, baka ma bigyan mo ako tutorial ng email code with attachment using thunderbird, kasi dati ko gamit MS outlook e hirap e configure ng outlook 2007, kaya gusto ko mag explore sa thunderbird.

salamat po!

 

[kirby21]

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

Sir, baka ma bigyan mo ako tutorial ng email code with attachment using thunderbird, kasi dati ko gamit MS outlook e hirap e configure ng outlook 2007, kaya gusto ko mag explore sa thunderbird.

salamat po!

sorry boss la ko knowledge sa thunderbird eh. sa outlook di din kasi ako masyado nagmamacro.

 

[LokieMarc]

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

Maraming salamat po! Sana marami pang tuts na ganito po.

 

[ackidcat]

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

Good day mga sir baka may alam po kayo na solution dito sa problem ko..
ang gusto ko kasi na pag may amount na nakalagay sa mga column ko may corresponding na text na mappnta
dun sa comment column.. example is yung nasa pic.. kung pede sana vba codes gamit ko dito kaso hanggang 2 lang kaya ko..


View attachment 288961

 

[kirby21]

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

Good day mga sir baka may alam po kayo na solution dito sa problem ko..
ang gusto ko kasi na pag may amount na nakalagay sa mga column ko may corresponding na text na mappnta
dun sa comment column.. example is yung nasa pic.. kung pede sana vba codes gamit ko dito kaso hanggang 2 lang kaya ko..


View attachment 1157656

dapat formula boss. as much as possible kung kaya ng formula kasi dun ako.

=if(a2="","","Credit1")&if(b2="","","&",Credit2")&if(c2="","",",Credit3")&if(d2="","",",Credit4")

 

[ackidcat]

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

cge idol salamat.. try ko ito ..

 

[joperd]

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

As per sir Kirby.

Inedit ko lang.

=IF(A2="","",",Credit1")&IF(B2="","",",Credit2")&IF(C2="","",",Credit3")&IF(D2="","","Credit4")

galing dami ko na natutunan.

dapat formula boss. as much as possible kung kaya ng formula kasi dun ako.

=if(a2="","","Credit1")&if(b2="","","&",Credit2")&if(c2="","",",Credit3")&if(d2="","",",Credit4")

 

[John101821]

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

HI PO ASK KO LANG PO .GAMIT KONG MS EXCEL SA WORK IS 2013 .ALMOST 22 THOUSANDS ROWS NA ANG NA ENCODE KO
SUDDENLY WHEN I TRY TO ADD ANOTHER ROW AND COLUMS THEY APPEARED A NOTIFICATION PROBLEM
"There isn't enough memory to complete this action.
Try using less data or closing other applications.
To increase memory availability, consider:
- Using a 64-bit version of Microsoft Excel
- Adding memory to your device"
PAANO PO BA IFIX ITO DI NAMAN PO KASI PWEDE PALITAN NG 64BIT ITO DAHIL COMPANY LAPTOP ITO AT STANDARD NA RAW.
NA TRY KO NARIN ILIPAT SA KABILANG WORRKBOOK AND SHEET PERO GANUN PADIN YUNG RESULTS..

SALAMAT PO SA MGA TUTULONG..

 

[joperd]

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

Another Question sir.


ganito po kasi ung scenario ko.

May mga excel files akong galing sa internet browser.
Gusto ko sana.
ma-pull out yung file from website.
tas save per "specific naming convention" sa specific drive.

Ex. Month and year - type of invoice - account name and account number.

Aun po muna for now.

thanks.

 

[verong01]

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

sir patuts naman nung yung sa unang sample nyo na brand trends

 

[dannyps2]

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

Guys, pano kaya to ginawa? walang password box na lalabas pag na click mo yong vba project nya. need help po para ma discover kung ano mga code nasa loob.

salamat!

 

[kirby21]

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

HI PO ASK KO LANG PO .GAMIT KONG MS EXCEL SA WORK IS 2013 .ALMOST 22 THOUSANDS ROWS NA ANG NA ENCODE KO
SUDDENLY WHEN I TRY TO ADD ANOTHER ROW AND COLUMS THEY APPEARED A NOTIFICATION PROBLEM
"There isn't enough memory to complete this action.
Try using less data or closing other applications.
To increase memory availability, consider:
- Using a 64-bit version of Microsoft Excel
- Adding memory to your device"
PAANO PO BA IFIX ITO DI NAMAN PO KASI PWEDE PALITAN NG 64BIT ITO DAHIL COMPANY LAPTOP ITO AT STANDARD NA RAW.
NA TRY KO NARIN ILIPAT SA KABILANG WORRKBOOK AND SHEET PERO GANUN PADIN YUNG RESULTS..

SALAMAT PO SA MGA TUTULONG..

ilang MB ba ang file mo? convert to .xlsb(Binary) para magcompress. if you have sumifs vlookup for every row given na yan. but you can try to manual the calculation. then ilang excel file ba ang nakabukas when you do that? check the task manager while nakaopen ang mga excel files mo.

- - - Updated - - -

Another Question sir.


ganito po kasi ung scenario ko.

May mga excel files akong galing sa internet browser.
Gusto ko sana.
ma-pull out yung file from website.
tas save per "specific naming convention" sa specific drive.

Ex. Month and year - type of invoice - account name and account number.

Aun po muna for now.

thanks.

online ba to or offline? we can try but let me see the html file first. so i know if its possible. pwede kumuha ng data sa web but hindi lahat. so need ko talaga makita yung html.

- - - Updated - - -

Guys, pano kaya to ginawa? walang password box na lalabas pag na click mo yong vba project nya. need help po para ma discover kung ano mga code nasa loob.

salamat!

alin ba dito ang need mo makuha? di ko din mabuksan eh. gumawa nalang tayo if you want.kaya naman natin to,

- - - Updated - - -

sorry guys if i was not around for the past few days. seminar kasi eh.

hope you guys understand.thanks

 

[John101821]

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

isang excel file lang po yung naka open sa akin sir. at yung mga formula ko burado na lahat yun..
yung manual calculation paano po ba iyon?

 

[kirby21]

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

isang excel file lang po yung naka open sa akin sir. at yung mga formula ko burado na lahat yun..
yung manual calculation paano po ba iyon?

nasa excel options sya. ilang MB yan boss?

 

[chuckz]

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

Mga Sir may alam ba kayong madaling way para mabilis ko mabura yung duplication pero ang ititira nya is yung value na mas mataas?

 

[kirby21]

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

Mga Sir may alam ba kayong madaling way para mabilis ko mabura yung duplication pero ang ititira nya is yung value na mas mataas?

please explain more. and add screenshot or samples.

thanks

 

[briyhen30]

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

Paturo naman kung pano pwede macheck changes between cells on 2 excel sheets po.

di kasi ako marunong sa excel salamat sa papansin

 

[joperd]

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

Sir eto po.. attached yung HTML code.

Thank you..

ilang MB ba ang file mo? convert to .xlsb(Binary) para magcompress. if you have sumifs vlookup for every row given na yan. but you can try to manual the calculation. then ilang excel file ba ang nakabukas when you do that? check the task manager while nakaopen ang mga excel files mo.

- - - Updated - - -



online ba to or offline? we can try but let me see the html file first. so i know if its possible. pwede kumuha ng data sa web but hindi lahat. so need ko talaga makita yung html.

- - - Updated - - -



alin ba dito ang need mo makuha? di ko din mabuksan eh. gumawa nalang tayo if you want.kaya naman natin to,

- - - Updated - - -

sorry guys if i was not around for the past few days. seminar kasi eh.

hope you guys understand.thanks

 

[kirby21]

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

Paturo naman kung pano pwede macheck changes between cells on 2 excel sheets po.

di kasi ako marunong sa excel salamat sa papansin

comparing ba? please give us screenshot. parar magkaron kami idea anong diskarte gagawin.

- - - Updated - - -

Sir eto po.. attached yung HTML code.

Thank you..

boss meron ka export to excel or csv dun ah. hindi ba nagwork yun? and anong fields ba dapat kuhanan ng data? and san ka nagquery dito? i mean san ka nagsearch?

 

[bytesize]

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

Good day mga sir baka may alam po kayo na solution dito sa problem ko..
ang gusto ko kasi na pag may amount na nakalagay sa mga column ko may corresponding na text na mappnta
dun sa comment column.. example is yung nasa pic.. kung pede sana vba codes gamit ko dito kaso hanggang 2 lang kaya ko..


View attachment 1157656

sir pwedeng formula yan medyo mahaba nga lang. copy mo sa cell E2 tapos drag mo pababa


=LEFT(IFERROR(IF(ABS(A2)=1,"credit1,",""),"")& IFERROR(IF(ABS(B2)=1," credit2,",""),"")&IFERROR(IF(ABS(C2)=1," credit3,",""),"")&IFERROR(IF(ABS(D2)=1," credit4 ",""),""),LEN(IFERROR(IF(ABS(A2)=1,"credit1,",""),"")&IFERROR(IF(ABS(B2)=1," credit2,",""),"")&IFERROR(IF(ABS(C2)=1," credit3,",""),"")&IFERROR(IF(ABS(D2)=1," credit4 ",""),""))-1)