macro for updating cells

[instanceoftime]

Thank you all for past help, I am here yet again.

I have a spreadsheet of inventory. I paste into it incoming inventory and would like to copy current info (price and sku) into the new cells.

The spreadsheet is sorted so any new inventory shows first.

If the item number is the same (A) I would like to copy (G) and (H) from below it (directly or not directly if it is blank as well)

20	COKE CLASSIC 24/12 OZ	5.99	12/15/22	14	SUNDRIES			Beverages
20	COKE CLASSIC 24/12 OZ	5.99	11/4/22	14	SUNDRIES	049000012781	11.49	Beverages
20	COKE CLASSIC 24/12 OZ	12.69	4/13/22	14	SUNDRIES	049000012781	11.49
25	COKE DIET 24/12 OZ	14.49	11/4/22	14	SUNDRIES			Beverages
25	COKE DIET 24/12 OZ	13.39	8/11/22	14	SUNDRIES			Beverages
25	COKE DIET 24/12 OZ	12.69	6/23/22	14	SUNDRIES	049000010633	11.49	Beverages
25	COKE DIET 24/12 OZ	11.69	7/27/21	14	SUNDRIES	049000010633	11.49
25	COKE DIET 24/12 OZ	11.19	5/26/21	14	SUNDRIES	049000010633	11.49
25	COKE DIET 24/12 OZ	10.99	1/13/21	14	SUNDRIES	049000010633	11.49
81	PEPSI 24/12Z HI-CONE P100	8.49	2/18/22	14	SUNDRIES	01201701	7.69
81	PEPSI 24/12Z HI-CONE P100	6.59	5/5/21	14	SUNDRIES	01201701	7.69
83	DIET PEPSI 24/12Z HI-CONE	8.49	8/27/22	14	SUNDRIES			Beverages
83	DIET PEPSI 24/12Z HI-CONE	8.49	5/31/22	14	SUNDRIES	012000171857	7.69	Beverages
83	DIET PEPSI 24/12Z HI-CONE	6.59	5/5/21	14	SUNDRIES	012000171857	7.69
123	RUBBER MULCH 1.5CUFT RED	10.99	9/14/22	27	GARDEN			Gardening
150	KIKKOMAN SOY SAUCE 64 OZ	6.69	11/4/22	13	FOOD			Sauces
150	KIKKOMAN SOY SAUCE 64 OZ	5.99	10/17/22	13	FOOD			Sauces
150	KIKKOMAN SOY SAUCE 64 OZ	5.99	10/6/22	13	FOOD	041390001505	5.39	Sauces

 

[instanceoftime]

Just wondering how long it took to process 30,000 rows?
.. and did you compare the alternative?

less than a second