# auto fill data using VBA

Status
Not open for further replies.

#### ACCA369

##### New Member
Book 36.xlsx
ABCDEFG
1SampleProg_1Value_1Data_set2Netural_set2
2199090832
310-9090933
4151801801135
55-90901236
61418018014
72-909015
834-18018017
91436036018
1011909019
1129909020
120-909022
131518018023
1413-909026
154-18018027
162736036029
1725-909030
1825-180180
1927360360
20119090
2134-9090
226-180180
2330360360
241-9090
253-180180
26
27
28
29
5 Corner H1 - VBA
Cell Formulas
RangeFormula
B2:B25B2=IFS(COUNTIF(\$E\$2:\$E\$37,A2),C2,COUNTIF(\$F\$2:\$F\$37,A2),0,COUNTIF(\$E\$2:\$F\$37,"<>"&A2),C2*-1)
C2:C25C2=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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### footoo

##### Well-known Member
Why not make the data a Table? Then no need for VBA.

#### ACCA369

##### New Member
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 ?

Status
Not open for further replies.

Replies
2
Views
83
Replies
35
Views
523
Replies
9
Views
159
Replies
1
Views
71
Replies
4
Views
120

1,127,529
Messages
5,625,351
Members
416,096
Latest member
forevans

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back