Pick detail of specific GL account with details

[Salamullah]

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

 

[welshgasman]

Re: Pick detail of speific GL account with details

Filter on Account, then copy and paste.?

 

[Salamullah]

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.

 

[welshgasman]

Re: Pick detail of speific GL account with details

I would start with the macro recorder, and build from that.

 

[Salamullah]

Re: Pick detail of speific GL account with details

Many thanks in advance