true power of MS excel. update: PowerBI

[puuts]

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

Sir kirby pahelp naman po sa problem ko.

Meron ako Listbox na nagddisplay ng items from Columns A, B, and C.

    Private Sub UserForm_Initialize()
    
    Dim lngMyRow As Long
    
        For lngMyRow = 2 To Cells(Rows.Count, "B").End(xlUp).Row
        
            If StrConv(Range("F" & lngMyRow), vbUpperCase) = "WAITING FOR APPROVAL" Then
    
                With ListBox1
                    .ColumnCount = 3
                    .ColumnWidths = "55;55;55"
                    .AddItem
                    .List(.ListCount - 1, 0) = Range("A" & lngMyRow)
                    .List(.ListCount - 1, 1) = Range("B" & lngMyRow)
                    .List(.ListCount - 1, 2) = Range("C" & lngMyRow)
                End With
    
            End If
            
        Next lngMyRow
    
    
    With ComboBox1
    
    .AddItem "WAITING FOR APPROVAL"
    .AddItem "APPROVED"
    .AddItem "IN PROGRESS"
    
    End With
    
    TextBox1.Enabled = False
    ComboBox1.Enabled = False
    CommandButton1.Enabled = False
    
    End Sub

Sa Listbox ko naman po is nagddisplay ng items to my Textbox1

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

TextBox1.Value = ListBox1.Value
ComboBox1.Enabled = True
CommandButton1.Enabled = True
ComboBox1.SetFocus

End Sub

Ang problema ko po is, minsan may mga duplicate items sa Column A ko.
Ang gusto ko po maging function ng Commandbutton ko is mag-change ng status ng number. Paano ko po macchange ang status nung ibang duplicate numbers?

Eto po yung file ko.

 

[dannyps2]

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

ako kasi unang program ko is worker monitoring, second lang yung inventory. mahihirapan ka talaga pag dumeretso ka agad ng inventory. pero trust me pag nakagawa ka ng isa madali na ang mga kasunod.

tama po kayo sir kirby..
==============================
I like the idea yong nasa taas, wait lang tayo im sure meron mag tut nyan.

 

[jerhed12]

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

nice salmat po,.

 

[kirby21]

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

Sir kirby pahelp naman po sa problem ko.

Meron ako Listbox na nagddisplay ng items from Columns A, B, and C.

    Private Sub UserForm_Initialize()
    
    Dim lngMyRow As Long
    
        For lngMyRow = 2 To Cells(Rows.Count, "B").End(xlUp).Row
        
            If StrConv(Range("F" & lngMyRow), vbUpperCase) = "WAITING FOR APPROVAL" Then
    
                With ListBox1
                    .ColumnCount = 3
                    .ColumnWidths = "55;55;55"
                    .AddItem
                    .List(.ListCount - 1, 0) = Range("A" & lngMyRow)
                    .List(.ListCount - 1, 1) = Range("B" & lngMyRow)
                    .List(.ListCount - 1, 2) = Range("C" & lngMyRow)
                End With
    
            End If
            
        Next lngMyRow
    
    
    With ComboBox1
    
    .AddItem "WAITING FOR APPROVAL"
    .AddItem "APPROVED"
    .AddItem "IN PROGRESS"
    
    End With
    
    TextBox1.Enabled = False
    ComboBox1.Enabled = False
    CommandButton1.Enabled = False
    
    End Sub

Sa Listbox ko naman po is nagddisplay ng items to my Textbox1

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

TextBox1.Value = ListBox1.Value
ComboBox1.Enabled = True
CommandButton1.Enabled = True
ComboBox1.SetFocus

End Sub

Ang problema ko po is, minsan may mga duplicate items sa Column A ko.
Ang gusto ko po maging function ng Commandbutton ko is mag-change ng status ng number. Paano ko po macchange ang status nung ibang duplicate numbers?

Eto po yung file ko.

bro san mo ba gamit to? pwede ba malaman ang use nito? sorry bro ha. mas madali kasi gumawa ng paraan pag alam mo yung nangyayari eh.

 

[johnjbs24]

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

Hello guys ginawa ko lang tong thread para sa mga kasymb natin na need ng tulong about MS excel. mga reporting staff, encoders, data analyst, secrectary, or Ms excel systems. pasok po kayo dito. share tayo ng knowledge. i will provide tutorials too. believe me after learning this things after a month i got my promotion to go up another level from our company. so try it now. made your bosses like their jaws drop.​

on my first example. you will see chart with controls like the picture below.
View attachment 887637

here you will see conditional formatting with toggle.like the picture below.
View attachment 887650

now you will see a picture album using excel. but in this tutorial i'll give you an example of animal album.
View attachment 888228

in this picture you will see a chart that looks like a temperature. it would be helpful to a presentations with a sales and target sales.
View attachment 888874

now in this picture you will see a speedo meter chart with control. the tutorial was provided from the attachment.
View attachment 888895
​

if nagustohan nyo po. pwede nyo sya idownload sa baba.

digital clock by dhok si...

​

sana po magshare din ang iba,

more excel tutorials coming soon.

Sir, pwede po ba sa Excel ung kunware lagay ako list!

Name Birthday Bank Name Withdrawal Date ACOP



Then pede ko po sila arrange by name, or arrange by birthday, or by bank name or withdrawal date???

Please need help po,

Thank you!

 

[kirby21]

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

Sir, pwede po ba sa Excel ung kunware lagay ako list!

Name Birthday Bank Name Withdrawal Date ACOP



Then pede ko po sila arrange by name, or arrange by birthday, or by bank name or withdrawal date???

Please need help po,

Thank you!

uu naman just use filters.

 

[berdhaws]

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

sir suggestion ko lang, mag simula ka mag design ng userform kahit tatlong txtbox lang at isa or dalawang command button. medyo complicated na kasi pag inventory na agad e develop mo. tulongan tayo dito ganyan rin ako nong nag simula dito, malayo ma abut natin dito kasi marami contributor sa thread na ito..

bossing sge try ko.. thanks ng madame!

 

[junjun gorollo]

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

Pa-bm ts, useful ang thread mo. Salamat po.

 

[emzie03]

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

Nice Thread.

Patambay muna.

 

[akelino01]

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

hi mga master! love ko din ang excel at sa tingin ko basic palang din alam ko.. patambay para madagdagan kaalaman ko..

 

[kirby21]

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

hi mga master! love ko din ang excel at sa tingin ko basic palang din alam ko.. patambay para madagdagan kaalaman ko..

Nice Thread.

Patambay muna.

sure guys. if you have problems with excel let us know will give you solution. including hacks.

 

[dannyps2]

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

sure guys. if you have problems with excel let us know will give you solution. including hacks.

paki hack da sa password nito sir kirby, kainis gusto ko sana e edit print area pero may password po..

 

[akelino01]

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

galing.. more on macro dito looking forward to learn from you guys.. ako kasi more on complicated ifs lang..

 

[kirby21]

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

paki hack da sa password nito sir kirby, kainis gusto ko sana e edit print area pero may password po..

pacheck ng attachment. wala na password yan.

- - - Updated - - -

galing.. more on macro dito looking forward to learn from you guys.. ako kasi more on complicated ifs lang..

tambay lang bro.

 

[dannyps2]

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

galing, pano kaya tinangal ang password non?..

salama po pala...

 

[deechaolan]

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

sir pwede patulong naman ako attach ko ung problem.... hehe gamit ko ms excel 2007

 

[dannyps2]

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

ano po pala gusto nyo mangyari dito? wala pa ts. eh..

 

[deechaolan]

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

ay dun sa column na may brand description ang mangyayari ata dun sa huling column makukuha mo ung brand using if search...

Excel project:
- Create a sheet that will contain the Item Description and Quantity from the sample data given to them.
- Using the Item Description column as basis
- create a new column that will contain the brand names
- make the column formula as generic as possible to be able
to extract the brand names
- using IF and SEARCH conditions to make the formula more generic



You have two options that can be used on how to get the Brand Name in a generic way
1st Option Pattern (by finding a common denominator on all the description):
=IF(<SEARCH>,<MID<SEARCH>>,0)


diko din masayado magets pero uniform ata ung code pagdrag mo sa next column lalabas ung mga brand names nila

 

[kirby21]

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

galing, pano kaya tinangal ang password non?..

salama po pala...

bro check mo yung attachment ko,. template lang yan. pag ginamit mo magkakaron ka ng isa pang quick access toolbar ang name is add in tapos makikita mo dun yung unlock sheet unlock workbook. etc etc etc etc .

- - - Updated - - -

ay dun sa column na may brand description ang mangyayari ata dun sa huling column makukuha mo ung brand using if search...

Excel project:
- Create a sheet that will contain the Item Description and Quantity from the sample data given to them.
- Using the Item Description column as basis
- create a new column that will contain the brand names
- make the column formula as generic as possible to be able
to extract the brand names
- using IF and SEARCH conditions to make the formula more generic



You have two options that can be used on how to get the Brand Name in a generic way
1st Option Pattern (by finding a common denominator on all the description):
=IF(<SEARCH>,<MID<SEARCH>>,0)


diko din masayado magets pero uniform ata ung code pagdrag mo sa next column lalabas ung mga brand names nila

bro kailangan ko ng data ng mga brand. ang problema kasi dito bro is pano ko malalaman sa description kung alin yung brand?

 

[manuelp]

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

boss paturo naman microsoft office 2007 gamit ko. salamat po.