vba code to replace old values by new value with 2 type of criteria

[breadwinner]

Dear Experts

i have set of range i want run formula on existing result only for where meet criteria from depends upon 3 difference column cells .

i have vba code to run formula in column AK:AK only where cell is blank in range there only formula fill up but i expect run formula on existing values where criteria meets up in 3 column replace old values by new values....

Please Login or Register  to view this content.

find the attachment and look at code also where you find what i expect

[HaHoBe]

Hi, breadwinner,

could the Autofilter be used to narrow down the number of cells to work on in order to just have the cells visible which need to be altered?

Ciao,
Holger

[breadwinner]

Yes I can do autofilter on criteria but sometime i work on huge database.. file get struck some time that why i need formula on existing value

[HaHoBe]

Hi, breadwinner,

depending on the number of records the code may take a long time to go through all data. Please test it on a copy of your workbook first:

Please Login or Register  to view this content.

Ciao,
Holger

[breadwinner]

Sir Amazing Master Piece code !!! works perfectly thanks

[HaHoBe]

Hi, breadwinner,

a small change should be made to the code:

Please Login or Register  to view this content.

Ciao,
Holger