true power of MS excel. update: PowerBI

[kirby21]

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

hello po mga bossing,, merun po ako ditong gnawa.. beginer lng po ako..

paano ko po ggawing, pang monday to sunday ang simple inventory na to? at magkakaroon siya ng column report or ung pie grap/bar grap ng whole week?

or any sugestions pa po para maayos ko po ing inventory...
sana po mtulungan niu ako..
thanks..

bro pakitingin ng attachment. right click mo lang si graph tapos select data

 

[berdhaws]

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

bro pakitingin ng attachment. right click mo lang si graph tapos select data

boss thanks..

merun po akong bagong ginawa dito..

papano ko po ito malalagyan ng database?
at para maging araw araw po ung inventory with date?

para po kasi sa business namin to.. sana matulungann niu ako..thanks...
patulung naman po pagandahin tong system namin..

 

[darling74]

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

po dito

 

[anorre]

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

thank youuuuuuu

 

[kirby21]

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

boss thanks..

merun po akong bagong ginawa dito..

papano ko po ito malalagyan ng database?
at para maging araw araw po ung inventory with date?

para po kasi sa business namin to.. sana matulungann niu ako..thanks...
patulung naman po pagandahin tong system namin..

dali lang to bro. macro ang sagot dito at magpapaganda,

 

[berdhaws]

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

dali lang to bro. macro ang sagot dito at magpapaganda,

bossing, wala ako idea sa macro..
ano po ba un at papano un?\

penge sanang sample boss para mapag aralan?..

 

[deljolo]

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

p subs. po sir..

 

[kirby21]

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

bossing, wala ako idea sa macro..
ano po ba un at papano un?\

penge sanang sample boss para mapag aralan?..

check mo to. pasensya ka na kung masyado simple. wala pa kasi talaga ko time. pero ayusin natin pag di na ko busy. returns nalang ang kulang nyan when it comes to flow. tapos sa mappings na sheet baguhin mo nalang yung SKU description at unit price. bahala ka na kung magdadagdag ka din.

 

[dannyps2]

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

salamat po sa inyo kirby21 at aubrey03.

Meron ako ulit ginawa code

Private Sub CommandButton1_Click()

'Populate data worksheet
With Worksheets("ComputerNumber")

'Open Storage sheet for the raw data
.Activate
'Insert Data into cells
With .Range("a10").End(xlUp)
.Offset(1, 0) = TextBox1.Text
.Offset(1, 1) = ComboBox1.Value
End With
End With
End Sub

hangang 10 data lang po ang pwede e enter ng user, sana may msgbox pag sumobra na sa 10 data ang entry ng user, pano po ang code non?

 

[berdhaws]

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

check mo to. pasensya ka na kung masyado simple. wala pa kasi talaga ko time. pero ayusin natin pag di na ko busy. returns nalang ang kulang nyan when it comes to flow. tapos sa mappings na sheet baguhin mo nalang yung SKU description at unit price. bahala ka na kung magdadagdag ka din.

thanks ng madme bossing a... pag aralan ko to.. salmat..

 

[aubrey03]

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

salamat po sa inyo kirby21 at aubrey03.

Meron ako ulit ginawa code

Private Sub CommandButton1_Click()

'Populate data worksheet
With Worksheets("ComputerNumber")

'Open Storage sheet for the raw data
.Activate
'Insert Data into cells
With .Range("a10").End(xlUp)
.Offset(1, 0) = TextBox1.Text
.Offset(1, 1) = ComboBox1.Value
End With
End With
End Sub

hangang 10 data lang po ang pwede e enter ng user, sana may msgbox pag sumobra na sa 10 data ang entry ng user, pano po ang code non?

ganito lang po:

Private Sub CommandButton1_Click()

'Populate data worksheet
With Worksheets("ComputerNumber")

'Open Storage sheet for the raw data
.Activate
'Insert Data into cells
With .Range("a11").End(xlUp)
.Offset(1, 0) = TextBox1.Text
.Offset(1, 1) = ComboBox1.Value
End With
End With

If Worksheets("ComputerNumber").Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count = 10 then
dim n as integer
n = Msgbox("You are only allowed to enter 10 items,VbOkOnly,"Warning")
end if

End Sub

 

[chandrolito]

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

Pa subscribe ... Tnx

 

[kirby21]

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

ganito lang po:

Private Sub CommandButton1_Click()

'Populate data worksheet
With Worksheets("ComputerNumber")

'Open Storage sheet for the raw data
.Activate
'Insert Data into cells
With .Range("a11").End(xlUp)
.Offset(1, 0) = TextBox1.Text
.Offset(1, 1) = ComboBox1.Value
End With
End With

If Worksheets("ComputerNumber").Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count = 10 then
dim n as integer
n = Msgbox("You are only allowed to enter 10 items,VbOkOnly,"Warning")
end if

End Sub

aubrey sigurado meron ka nito. patingin naman sample ng dashboard mo. hehehe

 

[dannyps2]

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

Salamat sa tulong mo sir aubrey03 at syo din ts.. good morning!

 

[Auditor]

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

Pa-subscribe dito TS. For future reference and hopefully makahingi ng tulong sa inyo in the future..

Very nice thread.. Helpful to sa mga taong laging kaharap si manong excel.

 

[dannyps2]

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

ganito lang po:

Private Sub CommandButton1_Click()

'Populate data worksheet
With Worksheets("ComputerNumber")

'Open Storage sheet for the raw data
.Activate
'Insert Data into cells
With .Range("a11").End(xlUp)
.Offset(1, 0) = TextBox1.Text
.Offset(1, 1) = ComboBox1.Value
End With
End With

If Worksheets("ComputerNumber").Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count = 10 then
dim n as integer
n = Msgbox("You are only allowed to enter 10 items,VbOkOnly,"Warning")
end if

End Sub

sir, dagdag ko lang dito, gusto ko sana ang data ma stored mula "A5 up to A10" lang, ano po ba code ma dagdag ko dito?

 

[berdhaws]

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

check mo to. pasensya ka na kung masyado simple. wala pa kasi talaga ko time. pero ayusin natin pag di na ko busy. returns nalang ang kulang nyan when it comes to flow. tapos sa mappings na sheet baguhin mo nalang yung SKU description at unit price. bahala ka na kung magdadagdag ka din.

Boss papano kapag ung evryday? Kht wala na ung data pbase.. Kahut ung una ko nlng gnwa,ung may beggining,pull out,sold,end.. Tapos evryday updated ung inventory.. With reports..

 

[kirby21]

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

Boss papano kapag ung evryday? Kht wala na ung data pbase.. Kahut ung una ko nlng gnwa,ung may beggining,pull out,sold,end.. Tapos evryday updated ung inventory.. With reports..

panong everyday b? kailangan natin kasi yung database para macalculate lahat ng transaction eh.

 

[kramluap]

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

thanks sa upload sir. . sana with tuts din. tnx a lot

 

[berdhaws]

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

panong everyday b? kailangan natin kasi yung database para macalculate lahat ng transaction eh.

ung evryday nag uupdate ng inventory sir.. kelangan lng nmn ung beggining,pull out,sold,end tapos sir merun xang monthly report?
dko kasi magets ung una niung sinend..