true power of MS excel. update: PowerBI

[chot07]

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

patulong po, may macro code po ako, and ang function nya is to save yung inutted data to another sheet WITHIN the same workbook. Pero ang gusto ko sana mangyari, yung inputted data ko sa ibang WORKBOOK magsasave, patulong po sana ako.

Code:

Sub RoundedRectangle1_Click()
Dim i, lastrow As Long
If ActiveSheet.Range("d6") = "" Or ActiveSheet.Range("g6") = "" Or ActiveSheet.Range("c9") = "" Then
MsgBox "Please complete all fields!"
Exit Sub
End If

lastrow = Sheets("database").Cells(Cells.Rows.Count, 2).End(xlUp).Row + 1
i = 9
Do While Cells(i, 3) <> "" And i < 29
Sheets("Database").Cells(lastrow, 2) = ActiveSheet.Range("g6") ' Date
Sheets("Database").Cells(lastrow, 3) = ActiveSheet.Range("d6") ' Ref
Sheets("Database").Cells(lastrow, 4) = ActiveSheet.Cells(i, 3) ' Code
Sheets("Database").Cells(lastrow, 5) = ActiveSheet.Cells(i, 4) ' Description
Sheets("Database").Cells(lastrow, 6) = ActiveSheet.Cells(i, 5) ' U/M
Sheets("Database").Cells(lastrow, 7) = ActiveSheet.Cells(i, 6) ' Qty
Sheets("Database").Cells(lastrow, 8) = ActiveSheet.Cells(i, 7) ' Price
Sheets("Database").Cells(lastrow, 9) = "IN" ' Transaction
i = i + 1
lastrow = lastrow + 1
Loop
MsgBox "Saved Succesfully!"
ThisWorkbook.Save
Call RoundedRectangle2_Click
End Sub

 

[mark692]

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

guys pede ba to sa VBA macro?

View attachment 315452

kapag tinype ko ung invoice number dun sa Column I hahanapin nya yung invoice number na tinype ko sa Column I dun sa source table tapos ialalgay nya sa Column J ung name na may parehong invoice,,

 

[amirsinghsingh]

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

pwede bro pm mo lang ako para mapagusapan natin

 

[themonyo]

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

guys pede ba to sa VBA macro?

View attachment 1203930

kapag tinype ko ung invoice number dun sa Column I hahanapin nya yung invoice number na tinype ko sa Column I dun sa source table tapos ialalgay nya sa Column J ung name na may parehong invoice,,

Hindi kelangan ng macro nyan brod, vlookup lang yan

 

[mark692]

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

Hindi kelangan ng macro nyan brod, vlookup lang yan

meron n ko gnyan bro puro vlookup kaya lang ang problema sa sobrang dami ng formula bumabagal na ung excel file ko haha meron b ditong magaling sa excel VBA ska macro bulacan area babayaran ko n lang hahah

 

[amirsinghsingh]

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

Sir hindi ako bulacan area e pero kaya ko gawin yang sinasabi mo.

 

[Secret25]

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

my formula ba oh vba codes para i-auto suggest yung mga common email domain pag type mo ng @ character sa cell? halimbawa sample@ tapos pag type mo ng g eh iauauto suggest yung gmail.com..

 

[mark692]

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

Hindi kelangan ng macro nyan brod, vlookup lang yan

bro san ba kita pede kausapn bukod dto hirap magmsg dto eh hehe

 

[&watag]

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

Sir baka pwede mu ako matulungan kung okay lang sayo. Visual basic connect to excel thanks.

 

[verong01]

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

sir panu po ung sa graph with controls patuts naman aq.. balak ko gamitin dun yun eh.. at yung links nung sales dashboard mo ung unang sample..

 

[wolfe]

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

Great help!! Thanks for the uploads!!

 

[chot07]

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

Ito boss

View attachment 315966

 

[kirby21]

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

we are in need of data analyst. specifically Sales analyst.

requirements skills:
pivot
vlookup
forecasting
if statements
and good analytical thinking.

feel free to leave me a message.


thanks

 

[selleTura]

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

Ito yung thread na hinahanap ko. Masyado lang talaga akong mahilig sa excel.

Paano po gumawa ng search box sa excel?

 

[Jay102688]

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

maraming salamat po

 

[raizelnim17]

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

maraming

po dito sir

 

[DarkDen]

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

Bump! Thank you, Kirby21. Cheers!

 

[owshet]

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

thanks idol.

 

[MarshMarco]

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

hello. may other way po ba para unprotect ko un sheet?

 

[joperd]

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

hello. may other way po ba para unprotect ko un sheet?

eto dude.

gawa ka new workbook tas alt f11. tas paste mo tong code.

Sub PasswordBreaker()


Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126


ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next


End Sub
----------

then, I-open mo sa same Excel Application. ung Excel na gusto mo I-Unlock.
tas from the target excel file. View>MACRO>"Password Breaker">RUN.

Unlocked na yan..