A1= STYLE A
A2= STYLE B
A3= STYLE C
A4= STYLE D
A5= STYLE E
A6= STYLE F
A7= STYLE G
A8= STYLE H
A9= STYLE I
A10= STYLE J
B1= 304
B2= 111
B3= 205
B4= 316
B5= 524
B6= 308
B7= 209
B8= 116
B9= 415
B10= 420
Conditions: STYLE E can only be a 401, 402, 403, 404, or 405.
I want to use conditional...
I am new to VBA, but I have been trying to figure out a way to simplify this process -- when I took over the project, I was told it would take me between 3-5 days/month to clean up! After playing around with If statements and various functions, I have been able to reduce the time significantly...
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.