auto fill data using VBA

[ACCA369]

Book 36.xlsx
	A	B	C	D	E	F	G
1	Sample	Prog_1	Value_1		Data_set2	Netural_set2
2	19	90	90		8	32
3	10	-90	90		9	33
4	15	180	180		11	35
5	5	-90	90		12	36
6	14	180	180		14
7	2	-90	90		15
8	34	-180	180		17
9	14	360	360		18
10	11	90	90		19
11	29	90	90		20
12	0	-90	90		22
13	15	180	180		23
14	13	-90	90		26
15	4	-180	180		27
16	27	360	360		29
17	25	-90	90		30
18	25	-180	180
19	27	360	360
20	11	90	90
21	34	-90	90
22	6	-180	180
23	30	360	360
24	1	-90	90
25	3	-180	180
26
27
28
29
5 Corner H1 - VBA

Cell Formulas
Range	Formula
B2:B25	B2	=IFS(COUNTIF($E$2:$E$37,A2),C2,COUNTIF($F$2:$F$37,A2),0,COUNTIF($E$2:$F$37,"<>"&A2),C2*-1)
C2:C25	C2	=IFS(B1=0,C1,B1<0,C1*2,B1>0,90)

Hello,
could you pls help me to solve using VBA code
1) when i enter data in Column A number
auto fill column b & column C
you can see the formula information in the excel

 

[footoo]

Why not make the data a Table? Then no need for VBA.

 

[ACCA369]

Why not make the data a Table? Then no need for VBA.

Thanks, you are correct
Instead of Direct entry of data in Column A
If i takes reference linked data from another sheet 2 for column A, how can I do ?

 

[Joe4]

Duplicate to: VBA - link sheet 1 and sheet 2 with autofill formula in sheet 2

This makes 4 different threads on the same topic.