Auto Fill Column with VBA Code if condition is Matched

M

MHA535

New Member
Joined
Apr 28, 2018
Messages
5
[FONT=&quot]Hi[/FONT]
[FONT=&quot]I have Multiple Entries of Same Bulk Code in Excel Sheet[/FONT]
[FONT=&quot]I'm looking for VBA Code with the following Condition[/FONT]
[FONT=&quot]If one entry of bulk code contains Intermediate against it in Material Type, for all entries where that bulk code appears, display bulk received as YES(See Screenshot)


https://www.dropbox.com/s/3we37vgkn7hloo3/Bulk Code.jpg?dl=0[/FONT]
[FONT=&quot]

[/FONT]
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
You must log in or register to reply here.

Similar threads

Artik
  • Question Question
VBA code to click Image in WebBrowser control.
Replies
4
Views
327
Artik
Artik
W
  • Question Question
SCHEDULE DASHBOARD VBA CODE (AUTOMATCICALLY TOGGLE TO MATCHING COLUMN)
Replies
0
Views
280
Willkim
W
S
  • Question Question
VBA To Filter Conditionally Formatted coloured cells in multiple columns
Replies
1
Views
717
bobsan42
bobsan42
J
  • Solved
SENDING BULK EMAILS FROM EXCEL VBA IN ONE CLICK/ WITH PARTICULAR PULL ID TO USE
Replies
1
Views
2K
DanteAmor
DanteAmor
MrDB4Excel
  • Solved
DuckDuckGo Conditional Format
2
Replies
12
Views
816
MrDB4Excel
MrDB4Excel

Forum statistics

Threads
1,224,817
Messages
6,181,147
Members
453,021
Latest member
Justyna P

Share this page

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
Back
Top