Urgent question

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
xaveboyzAsked:
Who is Participating?
 
SpideyModConnect With a Mentor Commented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
bruintjeCommented:
Hi, xaveboyz

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

HTH:O)Bruintje
0
 
xaveboyzAuthor Commented:
i mean, i dont know the code in vba  for doing that
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
bruintjeCommented:
ok i'm patching up a sample
0
 
xaveboyzAuthor Commented:
i mean, i dont know the code in vba  for doing that
0
 
bruintjeCommented:
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
 
xaveboyzAuthor Commented:
sorry bruintje,but  i really need the vba code, thanks for help anyway
0
 
DanRollinsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.