Code for updating string values.

[raze_lux]

Hello guys,

I've been having some trouble recently with some vba code.

I need to do the following:

In this column (M): docheadertxt,

All lines described as " BANK RECLASS PROGRAM" and " BCOS RECLAS PROGRAMA" ;

the corresponding text in the column "O" (Category), must be BA, instead of BS.

this is the current situation:

Example:


DocHeaderTxt HeaderCodes Category
BCOS RECLAS PROGRAMA PBSR BS
BCOS RECLAS PROGRAMA PBSR BS
BCOS RECLAS PROGRAMA PBSR BS
BCOS RECLAS PROGRAMA PBSR BS
BANK RECLASS PROGRAM PBSR BS

I want this:

DocHeaderTxt HeaderCodes Category
BCOS RECLAS PROGRAMA PBSR BA
BCOS RECLAS PROGRAMA PBSR BA
BCOS RECLAS PROGRAMA PBSR BA
BCOS RECLAS PROGRAMA PBSR BA
BANK RECLASS PROGRAM PBSR BA

I'll attach the file for you guys to take a look.

Note, I'm a beginner, I have no idea how to do this, although it seems to be pretty simple.

[dilipandey]

Hi Raze_lux,

Welcome to the forum.

suggest you to change the thread title to reflect the query you are asking.. also go through the forum rules:-


http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[raze_lux]

Alright! Done.

Thanks

[MarvinP]

Hi raze_lux and welcome to the forum,

Put this formula in R2 and pull it down for all the rows.

Please Login or Register  to view this content.

Then copy the entire column R and Paste (Values Only) over Column O.

[raze_lux]

Thank you so much! This helped a lot! =D