Add percentage to column based on value

[fpmsi]

I have a spreadsheet that has a company name in Column A and a number value in column b.

I want to create a macro that if the company in column A is "Dow" then add 75% to column b.

Thanks in advance
Ryan.

[sweep]

Hi,

Try this code:

Please Login or Register  to view this content.

[DonkeyOte]

Using Evaluate method:

Please Login or Register  to view this content.

[fpmsi]

Is there a way to make this NOT case sensative?

[DonkeyOte]

Evaluate method isn't as it fires at Worksheet level, VBA unlike Worksheet is Case Sensitive by default.

So re: the iteration, either a) set Module header of: Option Compare Text or b) revise the iteration to:

Please Login or Register  to view this content.

[fpmsi]

Thanks alot guys.

[fpmsi]

Sorry guys, I am being asked if they can have it so the formula is in the field instead of just the value.

So if I run this now the feild changes to a value (example 1 would equal 0.75 now).

Can i get it so it shows =Sum(1*0.75) and the value be 0.75 but they can look in the cell and still see the old value easily.

Thanks

[DonkeyOte]

I'm confused - I thought you were meant to be adding 75% to the value ? (ie * 1.75)

Using iteration approach with * 0.75:

Please Login or Register  to view this content.