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 we give solutions. formula, codes and tutorials.

thanks po sa lahat ng tumutulong. pasensya na po sa iba. di po kasi ako nakakapasok ng office. coz im suffering pulmonary tuberculosis. sana po maintindihan nyo.

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

kishimiharu said:
WOW salamat ng madame... more power!

- - - Updated - - -



kuya anu ba meaning my excalmation mark yun book1...wla pong smiley..salamat sory makulit lng me

- - - Updated - - -



AYAW PO MAG RUN : RUN TIME ERROR 1004 APPLICATION DEFINED OR OBJECT DEFINED ERROR----- ANU KAYA MALI... DINAGDAGAN KO LNG PO YUN CODE



Sub AddToSummary()
Dim lastRow As Long

'Note: DR sheet values should be fixed in column and row
rownum = 10
Do While ActiveSheet.Range("A" & rownum).Value <> ""

'Copy values from DR sheet to summary
'Date
'Sheets("Summary").Range("A" & lastRow).Value = ActiveSheet.Range("G3").Value
'DR
'Sheets("Summary").Range("B" & lastRow).Value = ActiveSheet.Range("C22").Value
'INVOICE
'Sheets("Summary").Range("C" & lastRow).Value = ActiveSheet.Range("C22").Value
'SO
'Sheets("Summary").Range("D" & lastRow).Value = ActiveSheet.Range("F5").Value
'PO
'Sheets("Summary").Range("E" & lastRow).Value = ActiveSheet.Range("G5").Value
'NAME
'Sheets("Summary").Range("F" & lastRow).Value = ActiveSheet.Range("D3").Value
'Qty
'Sheets("Summary").Range("G" & lastRow).Value = ActiveSheet.Range("A" & rownum).Value
'CODE
Sheets("Summary").Range("I" & lastRow).Value = ActiveSheet.Range("C" & rownum).Value
'Desc
Sheets("Summary").Range("J" & lastRow).Value = ActiveSheet.Range("D" & rownum).Value
'PRICE
Sheets("Summary").Range("L" & lastRow).Value = ActiveSheet.Range("F" & rownum).Value
'Total
Sheets("Summary").Range("M" & lastRow).Value = ActiveSheet.Range("G" & rownum).Value
rownum = rownum + 1
Loop

End Sub




SENSYA NA PO SA KULIT KO ,, BADLY NEEDED LNG HEHHE
Click to expand...



un smiley nasa Quick Access Toolbar, pwedeng nasa taas/baba ng Ribbon.

View attachment 222576

Ano ba dinagdag mo sa code?
 

Attachments

  • Untitled.png
    Untitled.png
    78.9 KB · Views: 28
Last edited:
Re: MS excel we give solutions. formula, codes and tutorials.

acelleb said:
un smiley nasa quick access toolbar, pwedeng nasa taas/baba ng ribbon.

View attachment 1046419

ano ba dinagdag mo sa code?
Click to expand...


nag dagdag po me ng column

date/ dr /si /so /c/po /client /qty /code /desc /price /total


NI run ko error daw
 

Attachments

  • Book1EDITED.zip
    17 KB · Views: 31
Last edited:
Re: MS excel we give solutions. formula, codes and tutorials.

kishimiharu said:
nag dagdag po me ng column

date/ dr /si /so /c/po /client /qty /code /desc /price /total


NI run ko error daw
Click to expand...

error xa kasi inalis mo un code para makuha ung value ng lastrow sa Summary Sheet

nawala to

'Check 1st last row used in summary sheet
lastRow = Sheets("Summary").Cells(Rows.Count, "A").End(xlUp).Row
lastRow = lastRow + 1
 
Last edited:
Re: MS excel we give solutions. formula, codes and tutorials.

kirby21 said:
thanks po sa lahat ng tumutulong. pasensya na po sa iba. di po kasi ako nakakapasok ng office. coz im suffering pulmonary tuberculosis. sana po maintindihan nyo.

thanks
Click to expand...

get well soon boss
 
Re: MS excel reportings, presentations, and vba helping thre

wow!.useful to ah..thanks dito bro!
 
Re: Yeah!

View attachment 223139

Hi sa mga expert jan sa excel. I NEED HELP. nakita nyo ba yan picture? now my problem is, pano yung
"Capitalize-a-title-when-addressing-someone-Part-2.pdf"
ilipat sa "/free-worksheets/kindergarten/language/
" para maging "/free-worksheets/kindergarten/language/
Capitalize-a-title-when-addressing-someone-Part-2.pdf
" gets nyo? alam ko paisa isahin pero 1k ang gagawin kong gnyan. need ko sana malaman isahan lipat lang PLEASE HELP ME MASTER!
 

Attachments

  • 123.png
    123.png
    87.1 KB · Views: 31
Re: Yeah!

nisaam said:
View attachment 1047502

Hi sa mga expert jan sa excel. I NEED HELP. nakita nyo ba yan picture? now my problem is, pano yung
"Capitalize-a-title-when-addressing-someone-Part-2.pdf"
ilipat sa "/free-worksheets/kindergarten/language/
" para maging "/free-worksheets/kindergarten/language/
Capitalize-a-title-when-addressing-someone-Part-2.pdf
" gets nyo? alam ko paisa isahin pero 1k ang gagawin kong gnyan. need ko sana malaman isahan lipat lang PLEASE HELP ME MASTER!
Click to expand...



ampersand lang boss. &

sa column d gawin mo let's say nasa row 20 ka na. bali = a20&c20
tapos copy and paste mo hanggang lastrow ng data mo.
 
Last edited:
Re: Yeah!

nisaam said:
View attachment 1047502

Hi sa mga expert jan sa excel. I NEED HELP. nakita nyo ba yan picture? now my problem is, pano yung
"Capitalize-a-title-when-addressing-someone-Part-2.pdf"
ilipat sa "/free-worksheets/kindergarten/language/
" para maging "/free-worksheets/kindergarten/language/
Capitalize-a-title-when-addressing-someone-Part-2.pdf
" gets nyo? alam ko paisa isahin pero 1k ang gagawin kong gnyan. need ko sana malaman isahan lipat lang PLEASE HELP ME MASTER!
Click to expand...

boss prang nakakalito ung gnagawa mo prang same output lng po...

bkit d nyo try gumamit ng combine ng right left len po pra makuha nyo po sia ^^,
 
Last edited:
Re: MS excel reportings, presentations, and vba helping thre

ayos to..pasubscribe muna..thanks!
 
Re: MS excel we give solutions. formula, codes and tutorials.

mga pre.. phelp nman po sa excel challenge na to.. maraming salamat po... formula po.. wag po macro.. bawal din po ang helper column.. salamat!!
 

Attachments

  • ES-(1).rar
    11.2 KB · Views: 45
Re: MS excel we give solutions. formula, codes and tutorials.

DxtR112591 said:
mga pre.. phelp nman po sa excel challenge na to.. maraming salamat po... formula po.. wag po macro.. bawal din po ang helper column.. salamat!!
Click to expand...

@DxtR112591 - Hirap naman nito hehe... bakit bawal gumawa ng column helper... saan ba galing ang challenge na ito?
i'll try pag-may time.
 
Re: MS excel we give solutions. formula, codes and tutorials.

DxtR112591 said:
mga pre.. phelp nman po sa excel challenge na to.. maraming salamat po... formula po.. wag po macro.. bawal din po ang helper column.. salamat!!
Click to expand...

kaya ba talaga to ng isang deretsong formula lang.?
 
Re: MS excel reportings, presentations, and vba helping thre

WOW thanks dito sir kirby magagamit ko to sa mga reports ko :dance:

- - - Updated - - -

DxtR112591 said:
mga pre.. phelp nman po sa excel challenge na to.. maraming salamat po... formula po.. wag po macro.. bawal din po ang helper column.. salamat!!
Click to expand...


Post ko mamaya ung sagot ko ginagawa ko na sya :) ung nasa baba na column un ba ung sagot?:noidea:
 
Re: MS excel reportings, presentations, and vba helping thre

ohohOrmhel said:
WOW thanks dito sir kirby magagamit ko to sa mga reports ko :dance:

- - - Updated - - -




Post ko mamaya ung sagot ko ginagawa ko na sya :) ung nasa baba na column un ba ung sagot?:noidea:
Click to expand...


maraming salamat tropa.. ! galing tong challenge dun sa mga ka workmate ko.. salamat!!
 
You must log in or register to reply here.

Similar threads

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