Pick detail of specific GL account with details

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
221
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
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
779
Re: Pick detail of speific GL account with details

Filter on Account, then copy and paste.?
 

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
221
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

Well-known Member
Joined
May 25, 2013
Messages
779
Re: Pick detail of speific GL account with details

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

Watch MrExcel Video

Forum statistics

Threads
1,096,193
Messages
5,448,890
Members
405,538
Latest member
ksumali

This Week's Hot Topics

Top