true power of MS excel. update: PowerBI

nash0260 · Jul 15, 2015

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

kirby21 said:
pano ba yun. daily ka may natatanggap na report? tapos may isang file na minamaintain?

d nmn po daily report daily na nag process or daily task na pumapasok per day kung ano ung mga naka pending at mga na process po

- - - Updated - - -

kirby21 said:
pano ba yun. daily ka may natatanggap na report? tapos may isang file na minamaintain?

daily task po pra malaman kung ano ang pending or na process po

muhyul · Jul 16, 2015

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

nash0260 said:
ganito po sample data lng po

s1= sheet1
s2= sheet2

pero dapat ung data nya dapt po hindi maligaw ng cell bka kse mag ramble kpag paste sa sheet2 po kya po ba gawin?
kasi mern times na pde po maulit ung name pano po kaya ma susulusyunan po un?

sir mas maganda gamitan mu ng macro ang gusto mu mangyari..
madali lang to ito gawin..

gusto mu dito mangyari parang database mu yung excel? tama po ba?

- - - Updated - - -

nash0260 said:
d nmn po daily report daily na nag process or daily task na pumapasok per day kung ano ung mga naka pending at mga na process po

- - - Updated - - -

daily task po pra malaman kung ano ang pending or na process po

anu report po ba? report via email sa boss mu sir?
gawan mu nlang po vba macro..

takatomutsu · Jul 17, 2015

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

pa bm ts,,thanks

oral · Jul 17, 2015

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

pano ba yun. daily ka may natatanggap na report? tapos may isang file na minamaintain?

urbc98 · Jul 18, 2015

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

galing... pa BM

aljame · Jul 20, 2015

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

Magandang araw TS!

Patulong nmn ako sa excel program na ginagawa ko para gumana lahat ng buttons na kelangan ko for simple project lang.

Salamat ng marami TS.

nash0260 · Jul 20, 2015

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

muhyul said:
sir mas maganda gamitan mu ng macro ang gusto mu mangyari..
madali lang to ito gawin..

gusto mu dito mangyari parang database mu yung excel? tama po ba?

- - - Updated - - -

anu report po ba? report via email sa boss mu sir?
gawan mu nlang po vba macro..

sir pde po pahnge po ng excel file po? wla kse ako alam sa vba macro po... yes po database na ung excel mismo po

payuket · Jul 20, 2015

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

pasubscribe ts. thanks

muhyul · Jul 21, 2015

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

nash0260 said:
sir pde po pahnge po ng excel file po? wla kse ako alam sa vba macro po... yes po database na ung excel mismo po

sir nash,

bigay ka po muna sample inputs mu.
tas gagawa ako basic macro with form na and database ay nasa excel mu din

- - - Updated - - -

aljame said:
Magandang araw TS!

Patulong nmn ako sa excel program na ginagawa ko para gumana lahat ng buttons na kelangan ko for simple project lang.

Salamat ng marami TS.

sir ito na po ang modify ng excel macro mu..
hope this will help if gusto mu pa improved.

search, delete, and clear are already functional po.
d ko lang sure if ito gusto mu mangyari.

asistio04 · Jul 21, 2015

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

T.s Can you please Email me ,i am willing to pay
[email protected]

Regards,

rare0412 · Jul 22, 2015

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

ano formula ang pde ko gawin for example

gusto ko na ang A1 ay partner sa B1..

na if from b1 to b10 ay sort ko alphabetically...
dapat yun a1 na kapartner ni b1 ay ppunta katapat nung laman ng b1 kung nung nag sort ako

nash0260 · Jul 22, 2015

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

rare0412 said:
ano formula ang pde ko gawin for example

gusto ko na ang A1 ay partner sa B1..

na if from b1 to b10 ay sort ko alphabetically...
dapat yun a1 na kapartner ni b1 ay ppunta katapat nung laman ng b1 kung nung nag sort ako

highlight mo ung gusto mo na alphabetically sama mo lahat sample b1-b10 dapat pati ung a1-a10 kasama sa highlight mo tapos dapat ung b1-b10 eh mauna sa a1-a10 cut mo muna sia tapos balik mo n lng sa original place un sana makatulong

theworstman · Jul 22, 2015

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

Thanks for sharing TS! Such a great help!

kishimiharu · Jul 22, 2015

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

kuya boss patulong.... napapagod kc ako mag copy paste pa isa isa sa isang summary report yun every delivery receipt .. multiple sheet (delivery sheets) to one sheet (summary sheet)

nakakapag dr ako ng 30 + 50 plus a day... at the end of the day mano mano ko pa xa icopy paste sa isang sheet .. huhu kapagod .... salamat po

knives645 · Jul 22, 2015

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

kishimiharu said:
kuya boss patulong.... napapagod kc ako mag copy paste pa isa isa sa isang summary report yun every delivery receipt .. multiple sheet (delivery sheets) to one sheet (summary sheet)

nakakapag dr ako ng 30 + 50 plus a day... at the end of the day mano mano ko pa xa icopy paste sa isang sheet .. huhu kapagod .... salamat po

Kakapagod talaga pag ganyan, ikaw din po ba nag-iinput sa mga dr? O binibigay lang sayo ang mga worksheets na tapos na?
And lahat ba ng dr, same lang ang mga format, places ng cells, etc, as in identical lahat?

kishimiharu · Jul 23, 2015

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

knives645 said:
Kakapagod talaga pag ganyan, ikaw din po ba nag-iinput sa mga dr? O binibigay lang sayo ang mga worksheets na tapos na?
And lahat ba ng dr, same lang ang mga format, places ng cells, etc, as in identical lahat?

yun nga eh ...ako din nag ddr waaaahhh... kaya nid ko talaga tulong nio... uu identical lahat name ng kada sheet is dr#

acelleb · Jul 23, 2015

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

kishimiharu said:
kuya boss patulong.... napapagod kc ako mag copy paste pa isa isa sa isang summary report yun every delivery receipt .. multiple sheet (delivery sheets) to one sheet (summary sheet)

nakakapag dr ako ng 30 + 50 plus a day... at the end of the day mano mano ko pa xa icopy paste sa isang sheet .. huhu kapagod .... salamat po

Eto oh check mo na lang. Modify mo na lang konti ung macro pero un gusto mo mangyare working na jan.
Click mo lang ung smiley na icon sa quick access toolbar para matransfer un data ng DR sheet to Summary sheet.

kishimiharu · Jul 23, 2015

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

WOW salamat ng madame... more power!

- - - Updated - - -

acelleb said:
Eto oh check mo na lang. Modify mo na lang konti ung macro pero un gusto mo mangyare working na jan.
Click mo lang ung smiley na icon sa quick access toolbar para matransfer un data ng DR sheet to Summary sheet.

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

- - - Updated - - -

acelleb said:
Eto oh check mo na lang. Modify mo na lang konti ung macro pero un gusto mo mangyare working na jan.
Click mo lang ung smiley na icon sa quick access toolbar para matransfer un data ng DR sheet to Summary sheet.

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

DxtR112591 · Jul 23, 2015

Mga sir pahelp nman po ako..

gumawa po kc ako ng Loop sa macro.. hndi ko po alam kung paano patigilin ung loop.. gusto ko po sana mang yari ay iistop kapag nadetect nya na blank na ung cell sa column C.. ung macro na ginawa ko kinacopy nya lang ung column C sa column D isa isa.. salamat po at more power!!! View attachment 222492

kaytoy · Jul 23, 2015

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

@DxtR112591

Explore mo code nito-- apply mo sa ginawa mo... medyo related lang ksi ng komti..

kaytoy said:
@nash

Nice One Bro

pero as what i have stated earlier nag-record ako ng macro and inserted
the Loop Function para mag-copy sya until sa wala ng ma-kopya.

Created a button then assigned this macro to that button for your convenience in executing the macro.

I hope from here you can edit the code according to your specifications.

Code:

Sub Nash() Range("A2").Select Selection.Copy ActiveSheet.Next.Select Range("A2").Select ActiveSheet.Paste ActiveSheet.Previous.Select Do Until IsEmpty(ActiveCell) ActiveCell.Offset(1, 0).Range("A1").Select Application.CutCopyMode = False Selection.Copy ActiveSheet.Next.Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste ActiveSheet.Previous.Select Loop End Sub

Pls. See Attached File

I hope it helps™

"To God be the Glory"

true power of MS excel. update: PowerBI

Professional

Novice

Proficient

Recruit

Novice

Recruit

Attachments

Professional

Amateur

Novice

Attachments

The Fanatic

Apprentice

Professional

Novice

Novice

Attachments

The Saint

Novice

Proficient

Attachments

Novice

Recruit

Attachments

Apprentice

Similar threads