Macro code to copy & paste cell data

[Maverick27]

Hi

Anyone care to share a Macro code to copy & paste the data from Cells C & D to Cells A & B ?

Final output:

Below is the criteria rules for formulating the Macro Code:

1. Copy the Data from Cell C & Cell D below the Cell containing the Text "Invoice" on Col D
2. Paste the data on Cell A & Cell B on the 1st instance data of Col C eg: A7/ B7 & A16/B16...etc
3. The Final Row at the bottom of the Sheet is on A6060 & B6060

Final Row Screenshot

Thanks in Advance

 

[Maverick27]

MREXCEL.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1					No	Type	Date	Due Date	Trans. Date	Order No
2					2451445	Invoice	45384	45384	45384	2402009
3					2451445	CC0002		ALLIANCE PLUMBING SYSTEMS LIMITED			KES
4						FS/MS
5								NAIROBI
6							Delivery Note 2451455
7			2451445	CC0002	OHA0024	1	Ohms 2In1 Blender 1.5L 500W Obp-600G	4725	10.6	4224.15	S
8							Total Delivery Note 2451455, 4,224.15
9					Total Items	Tag/Object	VAT Amount			4224.15
10					1	FS/MS,NA,NBI,RET	675.86
11					2451446	Invoice	45384	45384	45384	2402012
12					2451446	CC0002		CASH SALE (WESTLANDS)			KES
13						FS/MS
14						726249490		NAIROBI
15							Delivery Note 2451456
16			2451446	CC0002	CEO0304	1	Coupe Dinner Plate 16" 41Cm 210-161N	3713		3713	S
17					CEO0303	1	Coupe Dinner Plate 14" 34Cm 210-141N	2160		2160	S
18					CEO0287	1	Rect.Rim Deep Platter 15.75" x 5.85" 710-162R	3119		3119	S
19					CEO0143	1	Slant Square Plate 28Cm 707-111	1538		1538	S
20					CEO0146	2	Slant Rectangle Plate 31Cm x 19Cm 707-123	965		1930	S
21					JBP0121	1	686 Clear Pc 2 Tier Fruit Tray 35Cm/25Cm	3125		3125	S
22							Total Delivery Note 2451456, 15,585.00
23							MPESA - SD2IVDVQ2DS - KSH 18,078/=
24					Total Items	Tag/Object	VAT Amount			15585
25					7	FS/MS,NA,NBI,RET	2493.6
26					2451447	Invoice	45384	45384	45384	2402014
27					2451447	CC0002		SPEZ LTD			KES
28						FS/MS
29
30							Delivery Note 2451457
31					JBP0084	1	8114TG Grey Pp 4 Compartmen Cutlery Box	1645		1645	S
32							Total Delivery Note 2451457, 1,645.00
33							SCS4DTC4PG Confirmed. Ksh 1908
34					Total Items	Tag/Object	VAT Amount			1645
35					1	FS/MS,NA,NBI,RET	263.2
36					2451448	Invoice	45384	45384	45384	2402015
37					2451448	CC0002		CASH SALE (WESTLANDS)			KES
38						FS/MS
39								NAIROBI
40							Delivery Note 2451458
41					TES0034	1	Tesc.Crêpe Turner With Spreader "Delicia"630066	956		956	S
42							Total Delivery Note 2451458, 956.00
43							Paid in cash
44					Total Items	Tag/Object	VAT Amount			956
45					1	FS/MS,NA,NBI,RET	152.96
46					2451449	Invoice	45384	45414	45384	2402016
47					2451449	CC0005		CATERMART LTD			KES
48						MSMKT		P.O.BOX: 261 - 00621
49								NAIROBI
50						Delivery		PIN: P051130877X
51								MR.NASIM KADRI
52							Delivery Note 2451459
53					CEO0007	12	Dynasty Deep Soup Plate 24.5Cm 610-V102	616		7392	S
54							Total Delivery Note 2451459, 7,392.00
55					Total Items	Tag/Object	VAT Amount			7392
56
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F:F	Cell Value	="Invoice"	text	NO