extract data from sheet to another based on specific date

[abdo meghari]

Hello
I want extracting data from BRAND sheet to BALANCE sheet based on date=09/02/2023(dd/mm/yyyy) in column A
but should not repeat extracting to the bottom for BALANCE sheet , should clear data for BALANCE sheet before brings data from BRAND sheet.

MM with corrected CBs v03 a (2).xlsm
	A	B	C	D	E	F	G	H
1	DATE	CODE	BRAND	TYPE	ORIGIN	QTY	PRICE	TOTAL
2	09/02/2023	BSJG580120020	BS 1200R20	G580	JAP	200.00	2,200.00	440,000.00
3	09/02/2023	BSTG580120020	BS 1200R20	G580	THI	250.00	2,000.00	500,000.00
4	09/02/2023	BSJR187120020	BS 1200R20	R187	JAP	300.00	2,100.00	630,000.00
5	09/02/2023	BSTR187120020	BS 1200R20	R187	THI	350.00	2,200.00	770,000.00
6	09/02/2023	BSJG580120024	BS 1200R24	G580	JAP	400.00	3,000.00	1,200,000.00
7	10/02/2023	BSTG582120024	BS 1200R24	G582	THI	450.00	2,800.00	1,260,000.00
8	11/02/2023	BSJR23070016	BS 700R16	R230	JAP	500.00	800.00	400,000.00
9	12/02/2023	BSJR23075016	BS 750R16	R230	JAP	550.00	900.00	495,000.00
10	13/02/2023	BSJVSJ75016	BS 750R16	VSJ	JAP	600.00	1,300.00	780,000.00
11	14/02/2023	BSJVSJ140020	BS 1400R20	VSJ	JAP	650.00	2,000.00	1,300,000.00
12	15/02/2023	BSJR180140020	BS 1400R20	R180	JAP	700.00	3,500.00	2,450,000.00
BRANDS

before

MM with corrected CBs v03 a (2).xlsm
	D	E	F	G	H	I	J	K
1	DATE	CODE	BRAND	TYPE	ORIGIN	QTY	PRICE	TOTAL
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
BALANCE

after
[

MM with corrected CBs v03 a (2).xlsm
	D	E	F	G	H	I	J	K
1	DATE	CODE	BRAND	TYPE	ORIGIN	QTY	PRICE	TOTAL
2	09/02/2023	BSJG580120020	BS 1200R20	G580	JAP	200.00	2,200.00	440,000.00
3	09/02/2023	BSTG580120020	BS 1200R20	G580	THI	250.00	2,000.00	500,000.00
4	09/02/2023	BSJR187120020	BS 1200R20	R187	JAP	300.00	2,100.00	630,000.00
5	09/02/2023	BSTR187120020	BS 1200R20	R187	THI	350.00	2,200.00	770,000.00
6	09/02/2023	BSJG580120024	BS 1200R24	G580	JAP	400.00	3,000.00	1,200,000.00
BALANCE

 

[mumps]

It worked for me. This is what I got:

DATE	CODE	BRAND	TYPE	ORIGIN	QTY	PRICE	TOTAL
2023-02-09	BSJG580120020	BS 1200R20	G580	JAP	200.000	2,200.000	440,000.000
2023-02-09	BSTG580120020	BS 1200R20	G580	THI	250.000	2,000.000	500,000.000
2023-02-09	BSJR187120020	BS 1200R20	R187	JAP	300.000	2,100.000	630,000.000
2023-02-09	BSTR187120020	BS 1200R20	R187	THI	350.000	2,200.000	770,000.000
2023-02-09	BSJG580120024	BS 1200R24	G580	JAP	400.000	3,000.000	1,200,000.000

 

[abdo meghari]

@mumps
can you attach your file ,please?

 

[mumps]

Click here for your file.

 

[abdo meghari]

OMG !

I figure out the reason causes this problem . in your code using hyphen in date, but for me is slash , I changed in your code to slash .
now it works perfectly
thanks very much

 

[mumps]

You are very welcome.