true power of MS excel. update: PowerBI

[puuts]

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

@themonyo

Thanks! Hopefully hopefully some others may give another way / option.

with macro

- - - Updated - - -

Total volume po sana ng items ung mais'save sa database sir puuts - tas ung SKU's, if'fill nalang po un sa userform, same as the date box na nagawa ni sir kirby..

maraming salamat po uli sa pagtulong.

so meaning, kung yung mo SKU let' say item 1 to item 5 tapos every item 1 ung quantity, yung 5 na item is massave sa database na sheet with corresponding description,quantity and amount? tama ba?

 

[dimerdime]

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

so meaning, kung yung mo SKU let' say item 1 to item 5 tapos every item 1 ung quantity, yung 5 na item is massave sa database na sheet with corresponding description,quantity and amount? tama ba?

No need na po ung item description sa database sir. Basta ang mai ssave lang sa database is ung total quantity ng items na, volume total, date, and then ung SKU number na iffill lang kada input tulad nung date.

bale kada save po is 1 row lang po siya sa database . maraming salamat ulit

 

[natsu11]

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

Very helpful. Thanks po.

 

[yatotzz]

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

mga idol pa help po. pano po ba maging automatic compute ang lahat ng mga label na naka attach na sample DTR pag na encode ko na yung IN & Out.
for example kung pumasok sya ng 7:05am to 18:29 out = 3 hours OT matic ndi kasama yung .29 mins. same lang din ng sa ibang label.

thnx po sa makaka tulong.

 

[mechatron]

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

Boss pakisuyo naman po... paki unprotect lang po kac edit ko ung ibang items... at iba na ang password kesa ibinigay... thanx po...love ur threads...

 

[romcel11]

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

Boss ask ko lang sana kung pano mo nalagyan ng button sa worksheet yung BROWSE at UPLOAD.

sa activeX Controls po yata. ( dko pa natitignan ung file)

mga idol pa help po. pano po ba maging automatic compute ang lahat ng mga label na naka attach na sample DTR pag na encode ko na yung IN & Out.
for example kung pumasok sya ng 7:05am to 18:29 out = 3 hours OT matic ndi kasama yung .29 mins. same lang din ng sa ibang label.

thnx po sa makaka tulong.

see attached file po. ty

Boss pakisuyo naman po... paki unprotect lang po kac edit ko ung ibang items... at iba na ang password kesa ibinigay... thanx po...love ur threads...

see attached file po. meron po ata akong nasirang isang sheet.
try nyo n lang po mg copy galing sa original

Boss pa unlock naman ng code, parang ayaw kasi gumana ng sa 1st page tutorial.
gusto ko kasi matutunan yung code na ginamit dito

see attachments tapos eto ung code para icrack ung app.

// License Codes //
Version	Name	Code
v4.3	JekG	000014-RKND8F-B3WQ7U-KDNY8V-ZZFZZZ-ZZZZZZ-ZWCJP9-51VJ00-800000-000000
v4.5		000014-RE613W-5D877U-KDNY8V-ZZFZZZ-ZZZZZZ-ZWCJP9-51VJ00-800000-000000
v4.6		
*** Tested working all right for VBA Password Bypasser v4.3, v4.5 and v4.6.

Copyright: http://appnee.com/vba-password-bypasser/#ixzz47YKGLhq6 
Under Creative Commons License: Attribution Non-Commercial No Derivatives

eto ung pang bypass ng vba password.

 

[edzaneallen2016]

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

sir. pa help nman po. gusto ko po sana mangyari is hindi ko na iinput ng manual yung date & time kahit copy paste na lang basta plus 10mins palagi ang adjustment sa time na nasa blank column. see image below. thanks..

 

[romcel11]

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

sir. pa help nman po. gusto ko po sana mangyari is hindi ko na iinput ng manual yung date & time kahit copy paste na lang basta plus 10mins palagi ang adjustment sa time na nasa blank column. see image below. thanks..

=DATE(YEAR(A1),MONTH(A1),DAY(A1))+TIME(HOUR(A1),MINUTE(A1)+10,SECOND(A1))

patry naman po nito ts.
where A1=ung column na pag eencode-an mo.

Note: number formatting nung columnB = "mm/dd/yy h:mm AM/PM"
remove double quote n lang po ("")

 

[themonyo]

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

sir. pa help nman po. gusto ko po sana mangyari is hindi ko na iinput ng manual yung date & time kahit copy paste na lang basta plus 10mins palagi ang adjustment sa time na nasa blank column. see image below. thanks..

check mo to brod.

yung constant value dun is equal to 10mins

 

[edzaneallen2016]

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

Salamat po ka Symb.

 

[mechatron]

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

sa activex controls po yata. ( dko pa natitignan ung file)


see attached file po. Ty


See attached file po. Meron po ata akong nasirang isang sheet.
Try nyo n lang po mg copy galing sa original




See attachments tapos eto ung code para icrack ung app.

// license codes //
version	name	code
v4.3	jekg	000014-rknd8f-b3wq7u-kdny8v-zzfzzz-zzzzzz-zwcjp9-51vj00-800000-000000
v4.5		000014-re613w-5d877u-kdny8v-zzfzzz-zzzzzz-zwcjp9-51vj00-800000-000000
v4.6		
*** tested working all right for vba password bypasser v4.3, v4.5 and v4.6.

Copyright: Http://appnee.com/vba-password-bypasser/#ixzz47ykglhq6 
under creative commons license: Attribution non-commercial no derivatives

eto ung pang bypass ng vba password.

thank you very much bossing

 

[SiRhOSEven]

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

Pwede po kaya yung mag pin ng sheet para lagi sya visible? Parang sticky sheet.

 

[kenjierf]

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

Thank you dito napka usefull sa subject and work.

 

[Mar Lon]

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

View attachment 331498 Hi Sir/Mam ask ko lang kung bakit po hindi gumagana yung formula. kung makikita nyo po sa picture na after ko i-input yung formula nag drop down ako pero ang result kinopya nya lang yung nasa unahan. paki guide naman po ako kung pano ko po ito ma fifix. SALAMAT Godbless.

 

[jskhulitz]

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

ang delimiter ng concatenate function ay comma (,), dun pa lang magtaka ka na kung bakit gumana ang concatenate mo using semi-colon (

Correct formula should be

=CONCATENATE(A1,B1,C1,E1)

 

[romcel11]

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

ang delimiter ng concatenate function ay comma (,), dun pa lang magtaka ka na kung bakit gumana ang concatenate mo using semi-colon (
Correct formula should be

=CONCATENATE(A1,B1,C1,E1)

akala ko dahil sa calculation options. naka-manual sya.

 

[slaprinoa]

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

mga lodi ask ko po if pde b na macro ang VLOOKUP?

 

[seventhofjune]

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

mga lodi ask ko po if pde b na macro ang VLOOKUP?

Pwede naman po.

 

[prococio]

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

Ayos 'tong thread na 'to. Dami kong natututunan! Hahaha. Salamat mga ka-SB.

 

[romcel11]

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

mga lodi ask ko po if pde b na macro ang VLOOKUP?

Pwede naman po.

make sure lang na ma-ha-handle po natin ng ayos kapag ng return ng error si vlookup sa VBA.