Macro to match criteria and apply algebra operation

[namy77]

Good afternoon,

I am trying to simplify my work by reducing repetition.

Basically, I have to sift through hundred of lines to match if Column A = "A" and Column B = "B", then change the price with a 10% tax mark up.

Since this file is generated daily, it is important to have a macro, rather than formulas, as I need an operation to change the price (where the 2 conditions are met) values in one instance and keep all the cells exactly where they are for further manual calculations.

ThankszF2FULA.png

[bakerman2]

Try this for starters.

Please Login or Register  to view this content.

[namy77]

Thanks - it seems to work very well!

I am trying to edit the code to match with my spreadsheet structure and it seems like it is not moving to the next test very well. Basically my real spreadsheet has a few headers, and A and B now are on comlumn D and E, with price on column G. So I got the following code. If I copy and paste an example to the first row it would work but it would not go through the whole list.

Thanks much!

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

Change the 1 to the rownumber where your data starts (just below headers)
Also make sure there are no empty rows in between your data.

[namy77]

There will be empty spaces in between - is there away to circumvent this or I would have to write the same code for i=n, with the nth row being the next line after the gap.

Thanks!

[bakerman2]

How about this ?

Please Login or Register  to view this content.

[jindon]

No loop

Please Login or Register  to view this content.

[namy77]

Thanks - both ways work perfectly!

One last request? Is there away for me to run a MsgBox to report how many calculations were made (how many times the criteria were matched and calculations were done)?

My final customized code is as follows - to run calculations for 2 scenarios:

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.