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 reportings, presentations, and vba helping thre

Boss paturo kung paano gawin if may tutorial ka mas maganda
 
Re: MS excel we give solutions. formula, codes and tutorials.

How about yung, my mga formula? like pag compute sa Shear and Moment? yung mga ganun? kelan kc nami e.input yung solutions ehh. salamat TS!
 
Re: MS excel reportings, presentations, and vba helping thre

dagdag kaalaman. salamuch!
 
Re: MS excel reportings, presentations, and vba helping thre

Boss paturo kung paano gawin if may tutorial ka mas maganda

pacheck ng attachment. extract mo nalang, video clip din yan.

- - - Updated - - -

How about yung, my mga formula? like pag compute sa Shear and Moment? yung mga ganun? kelan kc nami e.input yung solutions ehh. salamat TS!

ano ba boss gusto mo matutunan?
 

Attachments

  • Tutorial.rar
    3.8 MB · Views: 109
Re: MS excel we give solutions. formula, codes and tutorials.

nice post ts laking tulong ito up ko ito para makita din ng iba salamat
 
Re: MS excel we give solutions. formula, codes and tutorials.

Sir Kirby bali yung gusto ko na mangyari ay pag na click yung copy to clip board ay maka-copy yung lahat ng info tapos pwede siyang i paste sa notepad.

Halimbawa: Name: John Doe

Contact Number : 1234567

Fruits: Banana

Code: 1234

Comments: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure
dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum."

Recomendations: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure
dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum."


about sa function not sure bago pa lang kasi ako nag aaral ng macros.


Thanks in advanced! :salute:
 
Re: MS excel reportings, presentations, and vba helping thre

sir patulong formula for scanning IMEI 14 digit lang sana iscan
yung way sana sir kapg 13 ang lumabas or 15 may pop message or kung hindi IMEI barcode lalabas my pop up message parin na lalabas
sana matulungan nyo ako

salamat in advance :)
 
Re: MS excel we give solutions. formula, codes and tutorials.

Sir Kirby bali yung gusto ko na mangyari ay pag na click yung copy to clip board ay maka-copy yung lahat ng info tapos pwede siyang i paste sa notepad.

Halimbawa: Name: John Doe

Contact Number : 1234567

Fruits: Banana

Code: 1234

Comments: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure
dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum."

Recomendations: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure
dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum."


about sa function not sure bago pa lang kasi ako nag aaral ng macros.


Thanks in advanced! :salute:

Code:
Sub Test()

    Dim Desktop As String
    Dim FileName As String
    Desktop = CreateObject("Wscript.Shell").Specialfolders("Desktop")
    With ActiveSheet
        FileName = .Range("A92").Value
        .Range("A1:A113").Copy
        Workbooks.Add
        ActiveSheet.Paste
        Application.CutCopyMode = False
    End With
    With ActiveWorkbook
        .SaveAs FileName:=Desktop & Application.PathSeparator & FileName & ".scr" _
            , FileFormat:=xlTextMSDOS, CreateBackup:=False
        .Close SaveChanges:=False
    End With
    
End Sub

edit mo nalang muna to.

- - - Updated - - -

sir patulong formula for scanning IMEI 14 digit lang sana iscan
yung way sana sir kapg 13 ang lumabas or 15 may pop message or kung hindi IMEI barcode lalabas my pop up message parin na lalabas
sana matulungan nyo ako

salamat in advance :)

meron k ba current file na ginagawa?
 
Re: MS excel we give solutions. formula, codes and tutorials.

pa marka po. thanks
 
Re: MS excel we give solutions. formula, codes and tutorials.

ts..paturo naman ng pivot table sige na po sana matulungan mo q........
 
Re: MS excel we give solutions. formula, codes and tutorials.

ts..paturo naman ng pivot table sige na po sana matulungan mo q........

ano ba gusto mo malaman sa pivot?
 
Re: MS excel we give solutions. formula, codes and tutorials.

Hi help naman maglagay ng start/stop button sa excel using VBA that automatically go to the next blank row when I Click on Start and Stop. and meron syang dalawang table na start and stop with the same function. Please!!!! See sample image:

View attachment 204511
 

Attachments

  • Capture.PNG
    Capture.PNG
    14.7 KB · Views: 24
Re: MS excel reportings, presentations, and vba helping thre

sir mayroon ba kayong tutorial about Microsoft access at excel 2010!
 
Re: MS excel we give solutions. formula, codes and tutorials.

Hi help naman maglagay ng start/stop button sa excel using VBA that automatically go to the next blank row when I Click on Start and Stop. and meron syang dalawang table na start and stop with the same function. Please!!!! See sample image:

View attachment 1008470

assuming 2nd column yung start mo kaya number 2

Code:
Sub start()
Dim lastrow As Long
lastrow = ActiveSheet.Cells(Cells.Rows.Count, 2).End(xlUp).Row + 1
ActiveSheet.Cells(lastrow, 2) = Time
End Sub


assuming 3rd column yung stop mo kaya number 3

Code:
Sub stop()
Dim lastrow As Long
lastrow = ActiveSheet.Cells(Cells.Rows.Count, 3).End(xlUp).Row + 1
ActiveSheet.Cells(lastrow, 3) = Time
End Sub

- - - Updated - - -

sir mayroon ba kayong tutorial about Microsoft access at excel 2010!

excel lang po meron ako eh.

hanapin mo si knives from this thread. meron po sya. thanks
 
Last edited:
Re: MS excel we give solutions. formula, codes and tutorials.

Sir pde po pa help nid ko po kaseng verify ng
Count Processing Time
for Initial Interview to Technical Interview
Ilan po ung magiging interval pero may range po depende sa date na hinihingi may start and end po. Depende sa hinihingi po ng boss ko po

sample po
range nya 2/1/2015 to 2/28/2015

dapat po ung mga nag initial to technical po ma count nya kung ilan lahat ung naging interval ng processing po
 

Attachments

  • sample.JPG
    sample.JPG
    52.9 KB · Views: 16
Last edited:
Re: MS excel we give solutions. formula, codes and tutorials.

Sir pde po pa help nid ko po kaseng verify ng
Count Processing Time
for Initial Interview to Technical Interview
Ilan po ung magiging interval pero may range po depende sa date na hinihingi may start and end po. Depende sa hinihingi po ng boss ko po

sample po
range nya 2/1/2015 to 2/28/2015

dapat po ung mga nag initial to technical po ma count nya kung ilan lahat ung naging interval ng processing po

paelaborate naman boss/
 
Re: MS excel we give solutions. formula, codes and tutorials.

Tanung lang po, panu po ba ang formula ng date difference ng dalawang date without sundays?
Example
A1
3/2/2015
A2
3/9/2015
A3
6

Pahelp naman po. Thanks in advance!
 
Back
Top Bottom