Fill the values & replace the old values by vba code depends upon 2 col

**johnodys** · 03-26-2014, 03:48 AM

Dear experts

I have set of data in multiple range ,need to fill the and replace the old values depends upon two column values (AH & AL)

IF Active Calls is "TATA" In AH:AH, and IF Action Onwer Col is "Blank",in AL:AL
Then Fill the Blank cells by Values "SVC" in the col Action Owner,Then Replace Old values by "Updates Awaited" in Status Col(AM:AM)

find the attachment & basic code take this code for this task

Please Login or Register  to view this content.

**Richard Buttrey** · 03-26-2014, 05:10 AM

Hi,

Rather than a looping macro (which can often be slow) use a macro to first filter the data set for the two conditions you mention and then add SVC and Updates Awaited to columns AL & AM using the .SpecialCells(xlCellTypeVisible) instruction.

Your macro doesn't seem to reflect the requirement you stated in the bold text.

**johnodys** · 03-26-2014, 06:46 AM

sir, This code used for different scenario but Not able to loop to this task... you may take this code as base level or try new code...

**Richard Buttrey** · 03-26-2014, 09:04 AM

Hi,

Run the following macro.

Please Login or Register  to view this content.

**breadwinner** · 03-27-2014, 03:08 AM

John You got solution...

**johnodys** · 03-27-2014, 03:11 AM

Yes.... Richard sir thanks alot works perfectly.. superb one

Fill the values & replace the old values by vba code depends upon 2 col

LinkBack

Thread Tools

Rate This Thread

Display

Fill the values & replace the old values by vba code depends upon 2 col

Re: Fill the values & replace the old values by vba code depends upon 2 col

Re: Fill the values & replace the old values by vba code depends upon 2 col

Re: Fill the values & replace the old values by vba code depends upon 2 col

Re: Fill the values & replace the old values by vba code depends upon 2 col

Re: Fill the values & replace the old values by vba code depends upon 2 col

Thread Information

Users Browsing this Thread

Similar Threads

replace code/id values with a name found in a list

vba code to replace old values by new value depends upon 2 col values

[SOLVED] vba to Replace Old values by new values depends upon cell values in AC:AC col

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

[SOLVED] Need vba or formula help to set values depends upon 3 conditions values in 3 col

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions