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.

Madami po akong natutunan sa thread na ito.. :thumbsup::thumbsup::thumbsup::clap::clap:
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

albert3 said:
Thank you Master.

Paano po kung gusto ko sya i-autosave sa source directory nya?
Click to expand...

Anu yung source directory.?
yun ba yung path kung san nakasave yung workbook.?

palitan mu lang code sa SaveAs.. yung path..

eto..
"C:\Users\" & Environ("USERNAME") & "\Desktop\" & ActiveSheet.Name & ".txt",

gawin mu ganito..
Thisworkbook.Path &"\" & ActiveSheet.Name & ".txt",
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

Sir Newbie lng
ask ko lng po kpg magtype ako ng khit anu kay Cell A2 tapos lalabas kay Cell B2 ung date if kelan ka ngtype kay Cell A2.
pde po b un?
pra po syang updating log file.
tnx po
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

slaprinoa said:
Sir Newbie lng
ask ko lng po kpg magtype ako ng khit anu kay Cell A2 tapos lalabas kay Cell B2 ung date if kelan ka ngtype kay Cell A2.
pde po b un?
pra po syang updating log file.
tnx po
Click to expand...

1. Open Microsoft Excel
2. Press ALT + F11
3. Sa kaliwa, Double Click Sheet1
4. i-paste ito :

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$2" Then

    ThisWorkbook.Worksheets("Sheet1").Range("B2").Value = Now()

End If


End Sub

5. Balik ka excel, magtype ka ngayon sa cell A2.
 
Re: MS excel reportings, presentations, and vba helping thre

Salamat dito TS Malaking tulong to. and sana may guide din kayo sa excel pag gawa ng payroll
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

Pa dl ts, salamat
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

puuts said:
1. Open Microsoft Excel
2. Press ALT + F11
3. Sa kaliwa, Double Click Sheet1
4. i-paste ito :

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$2" Then

    ThisWorkbook.Worksheets("Sheet1").Range("B2").Value = Now()

End If


End Sub

5. Balik ka excel, magtype ka ngayon sa cell A2.
Click to expand...

Sir

try ko if allowed kpg madaming cell kaso ndi pla pde.
bka po my praan na pde po sya sa mdaming cell.

salamat po ng marami. dagdag kaalaman.
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

slaprinoa said:
Sir

try ko if allowed kpg madaming cell kaso ndi pla pde.
bka po my praan na pde po sya sa mdaming cell.

salamat po ng marami. dagdag kaalaman.
Click to expand...


panong madaming cell? madaming cell na paglalagyan ng data? madaming cell na paglalagyan ng output?

give me an example ng "madaming cell" na sinasabi mo baka pwedeng gawan ng paraan.
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

athenesia said:
Anu yung source directory.?
yun ba yung path kung san nakasave yung workbook.?

palitan mu lang code sa SaveAs.. yung path..

eto..
"C:\Users\" & Environ("USERNAME") & "\Desktop\" & ActiveSheet.Name & ".txt",

gawin mu ganito..
Thisworkbook.Path &"\" & ActiveSheet.Name & ".txt",
Click to expand...


Yes master, yung path kung san nakasave yung workbook. sinubukan ko pong palitan ito "C:\Users\" & Environ("USERNAME") & "\Desktop\" & ActiveSheet.Name & ".txt", by this one Thisworkbook.Path &"\" & ActiveSheet.Name & ".txt" kaso po sa ibang location na sisave yung file
dito po napupunta "C:\Users\Albert\AppData\Roaming\Microsoft\Excel"

sinubukan ko pong magexperiment kasi di ko po talaga makuha master. Naka vba project PERSONAL macro po ako Master.
 
Last edited:
Re: MS excel formula, programming, analysis, presentation and tutorials.

puuts said:
panong madaming cell? madaming cell na paglalagyan ng data? madaming cell na paglalagyan ng output?

give me an example ng "madaming cell" na sinasabi mo baka pwedeng gawan ng paraan.
Click to expand...

Sir pki-check po ng attachment. salamat po ulit
 

Attachments

  • status.zip
    45.4 KB · Views: 36
Re: MS excel formula, programming, analysis, presentation and tutorials.

slaprinoa said:
Sir pki-check po ng attachment. salamat po ulit
Click to expand...

parang ganito ang gusto mo mangyari?

Sa column N maglalagay ng data (dynamic ang range), so saang column ko ilalagay ung output? sa column V ba?
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

puuts said:
parang ganito ang gusto mo mangyari?

Sa column N maglalagay ng data (dynamic ang range), so saang column ko ilalagay ung output? sa column V ba?
Click to expand...

Yes Sir. Tama po kau.
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

slaprinoa said:
Yes Sir. Tama po kau.
Click to expand...

Overwrite mo yung luma.

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Application.Intersect(Target, Range("N4:N1048576")) Is Nothing Then
    
        If ThisWorkbook.Worksheets("Sheet1").Range("N" & Target.Row).Value <> "" Then
        
            ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = Now()
        Else
        
            ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = ""
            
        End If

    End If

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

puuts said:
Overwrite mo yung luma.

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Application.Intersect(Target, Range("N4:N1048576")) Is Nothing Then
    
        If ThisWorkbook.Worksheets("Sheet1").Range("N" & Target.Row).Value <> "" Then
        
            ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = Now()
        Else
        
            ThisWorkbook.Worksheets("Sheet1").Range("V" & Target.Row).Value = ""
            
        End If

    End If

End Sub
Click to expand...

ok na po. hirap pla ng code nya.
san ko po pde mpg-aralan about macro & vba?
tnx po
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

Thanks po sa pag share nito. Galing.
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

hello mga excel master. ask lang, saan kaya magandang website or tutorial for beginners to advance excel? sobrang advance na pala nitong thread hehe. need for my office job kasi hindi ako makasabay sa ibang officemate ko and somehow try for sideline na din. salamat!
 
Re: MS excel reportings, presentations, and vba helping thre

expire na po yung link pa.up nmn po..salamat
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

kirby21 said:
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

at eto naman ang sample dashboards ko

sample 1
http://i.giphy.com/xTiTnzLUI4whphKpoc.gif

sample 2
http://i.giphy.com/3o85xkmN4eEdkNV6Zq.gif
​
if nagustohan nyo po. pwede nyo sya idownload sa baba.

digital clock by dhok si...

​

sana po magshare din ang iba,


grading system excel application upload by our contributors. http://www.symbianize.com/showthread.php?t=1132342&p=19858679&viewfull=1#post19858679

eto na po para yung iba di na masyado magtanong sa excel tricks. lalo na mga charts with controls. im giving you all this.

http://i.imgsafe.org/19867c1.jpg

Excel hacks.rar


eto po splitted into two parts. thanks to devildarkrs
part 1
http://www.symbianize.com/attachment.php?attachmentid=1043979&d=1436253924
part 2
http://www.symbianize.com/attachment.php?attachmentid=1043978&d=1436253924
credits to creator of the book.


HOW TO UNLOCK VBA PROJECT
credits goes to athenesia​
Click to expand...

maraming salamat dto ! :thumbsup::thumbsup::thumbsup:
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

Master tutulungan mo po ba ko sa excel file ko?
 
Re: MS excel formula, programming, analysis, presentation and tutorials.

pelera said:
Master tutulungan mo po ba ko sa excel file ko?
Click to expand...

Post mo lang kung ano problema mo sa excel at tignan natin kung may makakasagot :noidea:
 
You must log in or register to reply here.

Similar threads

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