installing a range at once

[noalla]

2023 EN.xlsm
	A	B	C	D	E	F	G
1	Column1	Column2	Column3		Column1	Column2	Column3
2	1000	0.15	150		2000	0.001	150
3	2000	0.3	600		4000	0.002	600
4	3000	0.45	1350		6000	0.003	1350
5	5000	0.6	3000		8000	0.004	3000
6	6000	0.75	4500		10000	0.005	4500
7	7000	0.9	6300		12000	0.006	6300
8	8000	1.05	8400		14000	0.007	8400
9	9000	1.2	10800		16000	0.008	10800
10	10000	1.35	13500		18000	0.009	13500
11	What is required is that I want to install the contents of cells in the range A1:A9 all at once
12	The problem is that even when I use the macro in cells G1:G9, it repeats and copies the same equations in the range A1:A9, and I want them to apply to any field if the macro is activated, or if there is another way that makes me install a specific range in one go.
13	MACRO NAME "F"
Sheet1

Cell Formulas
Range	Formula
C2,G2	C2	=$A$2*$B$2
C3,G3	C3	=$A$3*$B$3
C4,G4	C4	=$A$4*$B$4
C5,G5	C5	=$A$5*$B$5
C6,G6	C6	=$A$6*$B$6
C7,G7	C7	=$A$7*$B$7
C8,G8	C8	=$A$8*$B$8
C9,G9	C9	=$A$9*$B$9
C10,G10	C10	=$A$10*$B$10

 

[johnnyL]

You might want to post the macro that you are using, if you say that is what is installing the formulas.