true power of MS excel. update: PowerBI

[stpdrob]

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

hi guys need help about staff/salary excel

may excel po ba kayu about time in time out ng staff and namomonitor yung pasok nila? and nag auto compute ang salary nila mga ganun po ba. sana may makatulong po maraming salamat.

 

[IamNumber25]

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

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

 

[athenesia]

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

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

working naman yung sa first page tutorial.

 

[darkvalley18]

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

sir meron k complete tutorial about vb macro?mga ganun?

 

[IamNumber25]

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

working naman yung sa first page tutorial.

wow
sa akin kasi excel stop working lumalabas kapag nag run na ako ng code dun sa module 2

 

[franzm]

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

malaking tulong to, salamat boss

 

[bherong]

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

ask ko lang sir... pano palabasin ulit yung parang tooltip pag nagtype ka na ng function. hindi yung suggestion formula... yung parang pag nag type ako ng IF function merong tooltip na lalabas kung ano ung procedures ng IF.. example: IF(value, VALUE IF TRUE, VALUE IF FALSE)... parang ganyan... wala na lumalabas sa akin eh... MS Office 2016,, TIA po...

 

[espreketetat123]

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

mga sir patulong naman po, paano po kaya yung kapag may sinearch ako sa excel example:nagtype ako ng number lalabas yung details niya salamat po ng marami

 

[timeaftertime]

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

Hello Guys

Baka meron sa inyong gusto magpagawa ng EXCEL VBA na project? Mura lang po kaso i only accept BTC 0.003 btc to 0.02 btc depende po sa ipapagawa po ninyo. PM lang po kung kelangang kelangan po. Maraming salamat po.

 

[blue11]

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

pa-marka dito mga boss

 

[blu3jp]

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

Hi Sir Salamat sa thread na toh.. pwede ba ako huminge ng konti 2logn regarding sa customize Excel Format with VBA codes nagkakaroon kc aq ng problema regarding sa number to word translation. salamat

 

[ugly19]

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

Salamat po dito. pag-aaralan ko, para ma-enhance ang skills ko din. Lv99. Haha.

 

[chot07]

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

ask lang boss, may macro ba tayo na kayang maggenerate ng formatted na excel file?
parang ganito
View attachment 313439 yan yung first file, pag naggenerate ng new excel file, yung total lang ang makukuhang value tapos ang generated na excel ay ito View attachment 313440

 

[timeaftertime]

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

ask lang boss, may macro ba tayo na kayang maggenerate ng formatted na excel file?
parang ganito
View attachment 1199846 yan yung first file, pag naggenerate ng new excel file, yung total lang ang makukuhang value tapos ang generated na excel ay ito View attachment 1199847

kuya pm mo ko kung interested ka, kaya ko gawin yung pinapagawa mo.

 

[joperd]

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

Mga sir, question naman..

I need a formula to show random time, na may MINIMUM and MAXIMUM value.
I tried using this formula.

=TIME(RANDBETWEEN(B3,G3),RANDBETWEEN(B3,G3),RANDBETWEEN(B3,G3))

yung Minimum ay nasa column B at yung maximum value nasa Column G.

Pero di sya gumagana

Please help.

Thanks.

 

[blue11]

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

mga master, paano i-disable yun unhide columns without protecting the sheet? I want other users to have full access maliban lang sa ni-hide ko n columns. TIA.

 

[Dandelion30]

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

TS nagbabakasakali lang matulungan mo ako, paano po ako maglalagay ng autonumber sa loob ng table? Yung everytime na magtatab ako sa last row ng table automatic yung numbering pag may nadagdag na row sa pinakadulo. Salamat TS sana matulungan mo ako.

 

[joperd]

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

TS nagbabakasakali lang matulungan mo ako, paano po ako maglalagay ng autonumber sa loob ng table? Yung everytime na magtatab ako sa last row ng table automatic yung numbering pag may nadagdag na row sa pinakadulo. Salamat TS sana matulungan mo ako.

Try mo to papz.

Right click sa sheet name tas "view code"
Ilagay mo tong code.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim RowOffset As Long
Dim IndexCol As String
'Set values
RowOffset = 0

IndexCol = "C" 'Change the C to the column where you want the numbers to show

Intersect(ActiveCell.EntireRow, Columns(IndexCol)).Value = ActiveCell.Row + RowOffset
End Sub

 

[Secret25]

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

pamarka ulit..need ko masterin excel ngayon..

 

[Verbatim29]

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

Up for you ts.