Previous Topic Next Topic

Excel Macro

Closed
faye - Jun 22, 2011 at 10:42 AM
Ambucias
Posts
47363
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 - Jun 22, 2011 at 03:36 PM
Hello,

I need a macro to do the following:

Look for the word prod in column C (500 rows). When it finds it, replace it with 814, 815,816 - three rows replace 1

Example

691700.Prog.Non_interco

Becomes

691700.813. Non.interco
691700.815.Non.Interco
691700.816.Non.Interco

It then moves to the next occurance and do the same thing until it has evaluated each row.


1 reply

Answer 1 / 1
Ambucias
Posts
47363
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 11,278
Jun 22, 2011 at 03:36 PM
Greetings,

Bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must re-write and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0