need macro to deal with 8000 rows to merge items based on helper column

[Omran Y]

Hello experts

I look forward from the experts to write macro to deal with more than 8000 rows based on helper column.

I need match helper column (F) with column B based on part of the item , if the part of item in helper column F is matched with column B then should merge for column C,D and insert column E to calculate as I put the formula, but I don't need formula. Also will increase data A:D in BANK sheet and will add more from parts of items in helper column . so I want clear data from row2 in OPERATION sheet when run the macro every time before populate & merge data.

ZX.xlsm
	A	B	C	D	E	F
1	DATE	OPERATION NAME	DEBIT	CREDIT		OPERATION NAME
2	01/03/2023	FIRST BALANCE DATE 31/12/2022	10,000.00			FIRST BALANCE
3	01/03/2023	BB IN TPUT R400-99 CASH PREPAID	10,000.00			CASH PREPAID
4	02/03/2023	CASH PREPAID BB IN TPUT MM200	2,000.00			BANK SWIFT
5	03/03/2023	BANK SWIFT FG-1000	30,000.00			PAID BANK
6	04/03/2023	MS.9888888 BANK SWIFT FG-1001	60,000.00			CASH PIAD
7	05/03/2023	PAID BANK MTSWF90000		2,000.00
8	06/03/2023	BANK SWIFT FGS-10001	10,000.00
9	07/03/2023	CASH PREPAID BB IN TPUT LM70000	30,000.00
10	08/03/2023	INN70000 CASH PIAD		6,000.00
11	09/03/2023	CASH PIAD MN9000 UY600		1,000.00
12
BANK

ZX.xlsm
	A	B	C	D	E
1	ITEM	OPERATION NAME	DEBIT	CREDIT	BALANCE
2
3
4
5
6
OPERATION

expected

ZX.xlsm
	A	B	C	D	E
1	ITEM	OPERATION NAME	DEBIT	CREDIT	BALANCE
2	1	FIRST BALANCE DATE 31/12/2022	10,000.00		10,000.00
3	2	CASH PREPAID	42,000.00		52,000.00
4	3	BANK SWIFT	100,000.00		152,000.00
5	4	PAID BANK		2,000.00	150,000.00
6	5	CASH PIAD		7,000.00	143,000.00
OPERATION

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E6	E3	=E2+C3-D3

thank you

 

[Omran Y]

it's fixed .
thank you so much .

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.