Results 1 to 3 of 3

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

Threaded View

ditto135 Create two line journal entry... 06-03-2011, 12:39 AM
MaczaQ Re: Create two line journal... 06-03-2011, 02:43 PM
Cakin Re: Create two line journal... 06-03-2011, 03:01 PM
  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

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