copy specific ranges highlighted blue from sheet to another

[Ali M]

hello
I want copying data are highlighted by blue color from sheet to another
sheet1

Pri.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	SSTR	TTR	MMR	NNR	QTY	PRICE	TOTAL
2	07/08/2021	SLFR-100	FOOD-1	PR100	NRIT1	10.00	25.00	250.00
3	08/08/2021	SLFR-101	FOOD-2	PR101	NRIT2	20.00	30.00	600.00
4	09/08/2021	SLFR-102	FOOD-3	PR102	NRIT3	23.00	35.00	805.00
5	10/08/2021	SLFR-103	FOOD-4	PR103	NRIT4	25.00	30.00	750.00
6	11/08/2021	SLFR-104	FOOD-5	PR104	NRIT5	20.00	40.00	800.00
7	12/08/2021	SLFR-105	FOOD-6	PR105	NRIT6	10.00	45.00	450.00
8	13/08/2021	SLFR-106	FOOD-7	PR106	NRIT7	20.00	45.00	900.00
9	14/08/2021	SLFR-107	FOOD-8	PR107	NRIT8	15.00	55.00	825.00
10	15/08/2021	SLFR-108	FOOD-9	PR108	NRIT9	5.00	60.00	300.00
11	16/08/2021	SLFR-109	FOOD-10	PR109	NRIT10	10.00	70.00	700.00
12	17/08/2021	SLFR-110	FOOD-11	PR110	NRIT11	20.00	80.00	1,600.00
13	18/08/2021	SLFR-111	FOOD-12	PR111	NRIT12	25.00	85.00	2,125.00
14	19/08/2021	SLFR-112	FOOD-13	PR112	NRIT13	20.00	90.00	1,800.00
15	20/08/2021	SLFR-113	FOOD-14	PR113	NRIT14	20.00	25.00	500.00
16	21/08/2021	SLFR-114	FOOD-15	PR114	NRIT15	10.00	30.00	300.00
17	22/08/2021	SLFR-115	FOOD-16	PR115	NRIT16	10.00	45.00	450.00
18	23/08/2021	SLFR-116	FOOD-17	PR116	NRIT17	10.00	40.00	400.00
19	24/08/2021	SLFR-117	FOOD-18	PR117	NRIT18	15.00	50.00	750.00
20	25/08/2021	SLFR-118	FOOD-19	PR118	NRIT19	15.00	60.00	900.00
21	26/08/2021	SLFR-119	FOOD-20	PR119	NRIT20	5.00	45.00	225.00
22	27/08/2021	SLFR-115	FOOD-16	PR116	NRIT17	5.00	20.00	100.00
23	28/08/2021	SLFR-116	FOOD-17	PR117	NRIT18	10.00	35.00	350.00
24	29/08/2021	SLFR-117	FOOD-18	PR118	NRIT19	20.00	50.00	1,000.00
25	30/08/2021	SLFR-118	FOOD-19	PR119	NRIT20	10.00	45.00	450.00
26	31/08/2021	SLFR-119	FOOD-20	PR120	NRIT21	20.00	25.00	500.00
27	01/09/2021	SLFR-120	FOOD-21	PR121	NRIT22	10.00	20.00	200.00
28	02/09/2021	SLFR-121	FOOD-22	PR122	NRIT23	5.00	20.00	100.00
29	03/09/2021	SLFR-122	FOOD-23	PR123	NRIT24	20.00	25.00	500.00
MAIN

Cell Formulas
Range	Formula
H2:H29	H2	=F2*G2

result should be

Pri.xlsm
	A	B	C	D	E	F	G	H
1	ITEM	SSTR	TTR	MMR	NNR	QTY	PRICE	TOTAL
2	07/08/2021	SLFR-100	FOOD-1	PR100	NRIT1	10.00	25.00	250.00
3	19/08/2021	SLFR-112	FOOD-13	PR112	NRIT13	20.00	90.00	1,800.00
4	27/08/2021	SLFR-115	FOOD-16	PR116	NRIT17	5.00	20.00	100.00
OUTPUT

Cell Formulas
Range	Formula
H2:H4	H2	=F2*G2

 

[Shortmeister1]

If you look in the custom filters, there is now an option to sort a range by colour. There's also a filter by colour, but it's a little too basic for your purposes. If you sort by multiple colours, you can then copy the output to your new sheet.

 

[Ali M]

well , how do that by macro ?

 

[Shortmeister1]

No. It's a filter option on the right side of the Home ribbon.

 

[Ali M]

I would do that by macro .