Results 1 to 5 of 5

Thread: Pick detail of specific GL account with details
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2011
    Location
    Saudi Arabia
    Posts
    199
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Pick detail of specific GL account with details

    I want to bring transactions of specific account 10001 from GL dump need help please. I have 25 columns which all I needed, given below 5 as sample

    GL dump

    Date | account| Description | amount | remarks

    01/01/19 | 10001 | expense | 100 | ABC
    02/01/19 | 10002 | income | 200 | CDE
    03/02/19 | 10001 | expense | 1000 | GEF
    04/03/19 | 10003 | assets | 3000 | ZZZ
    05/04/19 | 10001 | expense |300 |AAA

  2. #2
    Board Regular
    Join Date
    May 2013
    Posts
    602
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pick detail of speific GL account with details

    Filter on Account, then copy and paste.?
    Office 2007
    Access novice. Sometimes trying to give something back

  3. #3
    Board Regular
    Join Date
    Mar 2011
    Location
    Saudi Arabia
    Posts
    199
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pick detail of speific GL account with details

    Hi Welshgasman,

    The file is created for automation so objective is to avoid manual working, so need formula to get specific account detail from the running GL data for the year.

  4. #4
    Board Regular
    Join Date
    May 2013
    Posts
    602
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pick detail of speific GL account with details

    I would start with the macro recorder, and build from that.
    Office 2007
    Access novice. Sometimes trying to give something back

  5. #5
    Board Regular
    Join Date
    Mar 2011
    Location
    Saudi Arabia
    Posts
    199
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pick detail of speific GL account with details

    Many thanks in advance

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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