Solved

Urgent question

Posted on 2002-05-24
8
152 Views
Last Modified: 2010-05-02
I have file in excel:

name           transaction   amount        
john                         D              20            
john                         W              10            
john                         I              5              
Marry                        D              10            

D=deposit transaction
I=interest transaction
W=Withdrawal transaction

my question is how to shape those data into  this figure below in excel ? i'm currently use VBA for excel

name   Total deposit  total interest  total withdrawal
john          20                 5                     10
marry         10
0
Comment
Question by:xaveboyz
8 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 7032985
Hi, xaveboyz

you mean you already have a macro or you want one to get this result?

HTH:O)Bruintje
0
 

Author Comment

by:xaveboyz
ID: 7032997
i mean, i dont know the code in vba  for doing that
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7033000
ok i'm patching up a sample
0
 

Author Comment

by:xaveboyz
ID: 7033001
i mean, i dont know the code in vba  for doing that
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 44

Expert Comment

by:bruintje
ID: 7033047
no need to code you can use a pivottable to do this

don't know which version of excel you use you can download a small sample here

http://www.bredlum.com/ee_temp/xlpivotsample.xls

just let me know if you need more help
:O)Bruintje
0
 

Author Comment

by:xaveboyz
ID: 7033808
sorry bruintje,but  i really need the vba code, thanks for help anyway
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7818518
Hi xaveboyz,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

xaveboyz, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 7909943
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now