VBA if string is found then perform calculation in different column

[Samgrewal]

Hi,

I am new to VBA and wondering what the best way to do this would be :
if unit by column contains SP then grab price and divide it by 10 in the updated price field. If it is something else, do nothing.
Is it best to do this as an array function or go through the cells until you reach the end and just offset to get the desired value in the updated price column?

ID	Unit By	Price	Cost	updated price
1	SP	10	5
2	UN	6	1

 

[Micron]

Any particular reason why you want to use vba? Why not

=IFERROR(IF(FIND("SP",B2)>0,C2/10),0)
or
=IFERROR(IF(FIND("SP",B2)>0,C2/10),"") in updated price column?

 

[Samgrewal]

Any particular reason why you want to use vba? Why not

=IFERROR(IF(FIND("SP",B2)>0,C2/10),0)
or
=IFERROR(IF(FIND("SP",B2)>0,C2/10),"") in updated price column?

The IT person runs a report off a scheduler every morning. There’s about 20 worksheets that’s are similar just for different branches of our company. I will need to run this type of formula for each worksheet. I thought it would be easier to just copy and paste the vba code.

 

[Micron]

Not sure what you're describing.
The workbook/sheet gets replaced every day? Then your code would be lost anyway.
A range is cleared and populated every day? Then the formula will stay since it would be outside the range.
If a workbook gets replaced every day then you'll need to run your code from somewhere else - more complicated.
If the sheets get replaced every day, you'll need code at the workbook level.

Just my opinion but repeatedly copying/pasting code would be a non-starter for me.