+ Reply to Thread
Results 1 to 3 of 3

Create two line journal entry from one line, two different column for debit & credit

  1. #1
    Registered User
    Join Date
    06-02-2011
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Create two line journal entry from one line, two different column for debit & credit

    Hi all,

    I'm trying to make a macro for general ledger purpose, Basically the data is in one line and the output will be made in two lines

    I already found similar solution in this page
    http://www.excelforum.com/excel-prog...-one-line.html
    but currently the solution for that problem was to create two columns with different flag for debit and credit.

    What my user needs is that debit and credit value to be in different column

    I also attach the sample of input and output to clarify, just in case my explanation above isn't clear enough
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: Create two line journal entry from one line, two different column for debit & cre

    Hello,

    I think attached file will solve your problem as well.
    Please check it.

    Best Regards
    Maciej
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-30-2010
    Location
    Lincoln, NE
    MS-Off Ver
    Office Xp, and Office 2007
    Posts
    30

    Re: Create two line journal entry from one line, two different column for debit & cre

    Delete please
    Last edited by Cakin; 06-03-2011 at 03:08 PM. Reason: opps clicked wrong thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1