Greetings everyone,
I'm a medium level Excel user. I've been having problem with converting and sorting the data according to the format I wanted. Attached in the link are the sample data and the format that I intended to create.
For your info, I've had extract the data from actual online statement and compiled into single sheets. Its a lot of data, I've run out of imagination & formulas. Perhaps someone who is a master in VBA would help me.
http://www.sendspace.com/file/frz05k
Thank you in advance.
Bookmarks