What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

true power of MS excel. update: PowerBI

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

lovely14 said:
Pakidelete lahat ng code existing including modules.. then copy and paste this to your worksheet code editor

Public InputsP As String
Public InputsH As String
Public InputsL17 As String
Public InputsL18 As String

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
tRow = Target.Row
If Target.Column = 16 Then
Range("L" & tRow).Value = InputsP
End If

If Target.Column = 8 Then
Range("D" & tRow).Value = InputsH
End If

If Target.Column = 12 Then
If Target.Row = 17 Then
Application.EnableEvents = False
Range("H" & tRow).Value = InputsL17
End If
End If

If Target.Column = 12 Then
If Target.Row = 18 Then
Application.EnableEvents = False
Range("H" & tRow).Value = InputsL18
End If
End If
Application.EnableEvents = True
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
InputsP = Range("P" & Target.Row).Value
InputsH = Range("H" & Target.Row).Value
InputsL17 = Range("L" & Target.Row).Value
InputsL18 = Range("L" & Target.Row).Value
End Sub
Click to expand...

Galing galing! Haha, nareceive ko na yung PM tungkol dun sa Excel. Thanks Ma'am! :)
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

markjosefff said:
Galing galing! Haha, nareceive ko na yung PM tungkol dun sa Excel. Thanks Ma'am! :)
Click to expand...

ok na po ba yn? haha kaso may disadvantage yn haha, kasi buong column ng p or column h, ay magrurun din haha
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

lovely14 said:
ok na po ba yn? haha kaso may disadvantage yn haha, kasi buong column ng p or column h, ay magrurun din haha
Click to expand...

Oks na oks Ma'am :) 3 tables lang naman talaga yun eh hehe. Maraming salamat ^_^
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

markjosefff said:
Oks na oks Ma'am :) 3 tables lang naman talaga yun eh hehe. Maraming salamat ^_^
Click to expand...

You're welcome. :)

Kung may question ulit ,ask me na lang haha
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

Good AM po sa lahat mga kaSB,

bka po may mai-susuggest kayo na function na similar po sa gusto kong gawin..
http://d-h.st/WMf1 medyo ayaw po kasing gumana nung offset.. nagamit ko na po dati with same formula
pero hindi ko po alam kung bakit ngayon po ayaw.. :weep: :weep: :weep: and ask ko lang po kung possible na idrag nlng po yung index instead po replacing numbers :) maraming salamat po
 
Re: MS excel reportings, presentations, and vba helping thre

sir try ko nga po to thanks
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

berylx said:
Good AM po sa lahat mga kaSB,

bka po may mai-susuggest kayo na function na similar po sa gusto kong gawin..
http://d-h.st/WMf1 medyo ayaw po kasing gumana nung offset.. nagamit ko na po dati with same formula
pero hindi ko po alam kung bakit ngayon po ayaw.. :weep: :weep: :weep: and ask ko lang po kung possible na idrag nlng po yung index instead po replacing numbers :) maraming salamat po
Click to expand...

sir berlyx pede dto mo na ln upload ung file? nipprevent ako ng antivirus ko eh haha, malicious site haha
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

berylx said:
Good AM po sa lahat mga kaSB,

bka po may mai-susuggest kayo na function na similar po sa gusto kong gawin..
http://d-h.st/WMf1 medyo ayaw po kasing gumana nung offset.. nagamit ko na po dati with same formula
pero hindi ko po alam kung bakit ngayon po ayaw.. :weep: :weep: :weep: and ask ko lang po kung possible na idrag nlng po yung index instead po replacing numbers :) maraming salamat po
Click to expand...


@berylx

diko masyado kabisado yang offset na function... sinubukan ko lang po
i hope tama ang ginawa kong bagong poormula.
Pls. See attached File...
..hope it helps™
 

Attachments

  • Sample01.rar
    15.2 KB · Views: 20
Re: MS excel reportings, presentations, and vba helping thre

ayos to TS.thanks a lot..malaki tulong to
 
Re: MS excel reportings, presentations, and vba helping thre

sir, pahelp lang po sana, pano po ba magserial sa excel, ung auto serial po sana. na kapag nag input ng value sa Row B, C, at D, may serial agad na lalabas, tapos po kapag may kaparehas na value, as in same value sa Row B, C, at D, same serial po ang lalabas

eto po sample

Row A | Row B | Row C | Row D
Serial No. | 1st Value | 2nd Value | 3rd Value
01 | 12 | 10 | 15
02 | 1 | 5 | 9
03 | 15 | 9 | 16
02 | 1 | 5 | 9

sana po matulungan nyo ko.

thanks po in advance.



naglagay na po ko sample
 

Attachments

  • sample excel.rar
    6.6 KB · Views: 17
Last edited:
Re: MS excel reportings, presentations, and vba helping thre

Sa lahat ng tumulong sa thread na to at sa lahat ng nagpost ng questions. Merry Christmas sa inyo lahat.
 
Re: MS excel reportings, presentations, and vba helping thre

Sino dito Marunong gumawa ng PERT-CPM na medyo advance? yung parang automatic na talaga...
paturo naman guysor meron ba kayung materials dyan pwede kung pag-aralan...

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

TS help nman po.

pano po ba pagpapalitin yung rows using vba
HOW TO SWITCH ROWS:
yung nasa unahan po na row mapupunta sa pangalawa and yung nasa pangalawa mapupunta sa unahan.
Ito po sample master:
CURRENT 111111 01/01/2016
FORMER 111111 12/01/2015 12/31/2015
CURRENT 222222 01/01/2016
FORMER 222222 12/01/2015 12/31/2015
CURRENT 333333 01/01/2016
FORMER 333333 12/01/2015 12/31/2015
CURRENT 444444 01/01/2016
FORMER 444444 12/01/2015 12/31/2015
CURRENT 555555 01/01/2016
FORMER 555555 12/01/2015 12/31/2015

ganito po output:

RESULT SHOULD BE LIKE THIS:

FORMER 111111 12/01/2015 12/31/2015
CURRENT 111111 01/01/2016
FORMER 222222 12/01/2015 12/31/2015
CURRENT 222222 01/01/2016
FORMER 333333 12/01/2015 12/31/2015
CURRENT 333333 01/01/2016
FORMER 444444 12/01/2015 12/31/2015
CURRENT 444444 01/01/2016
FORMER 555555 12/01/2015 12/31/2015
CURRENT 555555 01/01/2016

Maraming salamat master!
 

Attachments

  • sample.zip
    7.1 KB · Views: 4
Last edited:
Re: MS excel formula, programming, analysis, presentation and tutorials.

albert3 said:
TS help nman po.

pano po ba pagpapalitin yung rows using vba
HOW TO SWITCH ROWS:
yung nasa unahan po na row mapupunta sa pangalawa and yung nasa pangalawa mapupunta sa unahan.
Ito po sample master:
CURRENT 111111 01/01/2016
FORMER 111111 12/01/2015 12/31/2015
CURRENT 222222 01/01/2016
FORMER 222222 12/01/2015 12/31/2015
CURRENT 333333 01/01/2016
FORMER 333333 12/01/2015 12/31/2015
CURRENT 444444 01/01/2016
FORMER 444444 12/01/2015 12/31/2015
CURRENT 555555 01/01/2016
FORMER 555555 12/01/2015 12/31/2015

ganito po output:

RESULT SHOULD BE LIKE THIS:

FORMER 111111 12/01/2015 12/31/2015
CURRENT 111111 01/01/2016
FORMER 222222 12/01/2015 12/31/2015
CURRENT 222222 01/01/2016
FORMER 333333 12/01/2015 12/31/2015
CURRENT 333333 01/01/2016
FORMER 444444 12/01/2015 12/31/2015
CURRENT 444444 01/01/2016
FORMER 555555 12/01/2015 12/31/2015
CURRENT 555555 01/01/2016

Maraming salamat master!
Click to expand...


@albert

diko masyado ma-gets...
but i suggest you RECORD your own macro according to your specifications..
it would be not that hard i suppose...

Recording Macro on Excel Video Link - https://www.youtube.com/watch?v=Lod7Mp-VLx0

...hope it helps™ :-)
 
Re: MS excel reportings, presentations, and vba helping thre

View attachment 254985
sir pahelp naman po. paano ito iunprotect. ang hirap e. sinunod ko sinabe ni ts. ayaw gumana. salamat. gusto ko mkuha ung code nia. thanks
 

Attachments

  • OHSAS 18001.zip
    93.3 KB · Views: 8
Re: MS excel reportings, presentations, and vba helping thre

Makikita mo naman yung code niya kahit hindi mo tanggling yung protection. Press Alt + F11.
 
Re: MS excel reportings, presentations, and vba helping thre

brysamae said:
View attachment 1098772
sir pahelp naman po. paano ito iunprotect. ang hirap e. sinunod ko sinabe ni ts. ayaw gumana. salamat. gusto ko mkuha ung code nia. thanks
Click to expand...

parang wala naman ako tut para tanggalin ang password ng vba. ang alam ko lang is tanggalin yung password ng sheet.
 
Re: MS excel reportings, presentations, and vba helping thre

up up and away.
 
Re: MS excel reportings, presentations, and vba helping thre

pa help nmn po..

gusto ko sana pag yung value ng cell is greater than 0 mag hihide yung buong row..

if cell A1 is = abc123 then

if(cell b1 >0 and cell c1.values " the value is greater than zero" then

row1.hide


pati nadin po yung command na mag u-unhide sa lahat ng hidden rows at columns


pa help po salamat ..
 
You must log in or register to reply here.

Similar threads

R
Please Help me datagridview rearange
Replies
0
Views
352
rapsoyso09
R
&watag
Excel Visual Basic Application
Replies
4
Views
1K
walo
walo
N
Data entry to other workbook excel vba
Replies
2
Views
645
neil1188
N
God love us
For Excel VBA expert only
Replies
0
Views
606
God love us
God love us
Patch2012
Excel VBA Incrementing Code [HELP]
Replies
4
Views
606
arcajx
arcajx
Back
Top Bottom