auto fill data using VBA

Status
Not open for further replies.

ACCA369

New Member
Joined
Dec 27, 2020
Messages
48
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
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
 

Some videos you may like

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
Joined
Sep 21, 2016
Messages
3,206
Office Version
  1. 2016
Platform
  1. Windows
Why not make the data a Table? Then no need for VBA.
 

ACCA369

New Member
Joined
Dec 27, 2020
Messages
48
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
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.

Watch MrExcel Video

Forum statistics

Threads
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?

Disable AdBlock

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
Top