want vba scripting code and vba array code

[roykana]

Dear all master,

I want very fast vba scripting code and array vba code to import or read data in a folder or sub folder containing excel files.

There are 500-600 excel files. I want some excel files that I have marked yellow or only have outstanding values to appear in the excel result file.

The multiple file formats are all the same and with the sheet name "2014". I have shared the example excel file.

Provide 2 lines, namely hard-coded and with File Dialog Box so I can uncomment according to my needs.
link file : want vba scripting code and vba array code - Google Drive

LINK

Thanks
roykana

 

[roykana]

Dear all master,

I want very fast vba scripting code and array vba code to import or read data in a folder or sub folder containing excel files.

There are 500-600 excel files. I want some excel files that I have marked yellow or only have outstanding values to appear in the excel result file.

The multiple file formats are all the same and with the sheet name "2014". I have shared the example excel file.

Provide 2 lines, namely hard-coded and with File Dialog Box so I can uncomment according to my needs.
link file : want vba scripting code and vba array code - Google Drive

LINK

Thanks
roykana

Dear all master,
for the file link that I share, I have changed the language to English so it is easy to understand. Below I want to explain logically.

D
Date	description	Debit	Credit	Amount
01-01-16	beginning balance			-
18-08-19	sale- FN SI62107016		428,000.00	(428,000.00)
18-08-19	payment - cash	50,000.00		(378,000.00)
01-03-20	sale- FN SI62107017		5,010,000.00	(5,388,000.00)
25-06-20	payment - cash	2,000,000.00		(3,388,000.00)
06-10-20	payment - cash	3,010,000.00		(378,000.00)
08-07-20	sale- FN SI62107018		1,209,000.00	(1,587,000.00)
11-07-20	payment - cash	500,000.00		(1,087,000.00)
01-12-20	sale- FN SI62107019		270,000.00	(1,357,000.00)
01-12-20	payment - cash	50,000.00		(1,307,000.00)
01-12-20	Retur - FN RS52006005	10,000.00		(1,297,000.00)
01-12-20	Others - Pay Discount	30,000.00		(1,267,000.00)
20-02-21	sale- FN SI62107020		515,000.00	(1,782,000.00)
20-02-21	payment - cash	515,000.00		(1,267,000.00)

RESULT

Filename	Date	description	Debit	Credit	Amount
D	18-08-19​	Sale- FN SI62107016		428,000	- 428,000
D	18-08-19​	payment - cash	50,000		- 378,000
D	08-07-20​	sale- FN SI62107018		1,209,000	- 1,587,000
D	11-07-20​	payment - cash	500,000		- 1,087,000
D	01-12-20​	sale- FN SI62107019		270,000	- 1,357,000
D	01-12-20​	payment - cash	50,000		- 1,307,000
D	01-12-20​	Retur - FN RS52006005	10,000		- 1,297,000
D	01-12-20​	Others - Pay Discount	30,000		- 1,267,000

so I give an example if there is a sale (01) line then below it there is a payment or something else for the (01) sale. if there is no payment or other then the next line is sales (02). If you have any questions or misunderstandings, please communicate with me.
so if the value of the sale is not the same as the payment, return and others for the sale then that value is outstanding so it appears in the excel result file.


Thanks
roykana