Previous Topic Next Topic

Excel Macro

Closed
faye - Jun 22, 2011 at 10:42 AM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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.


Related:

1 response

Answer 1 / 1
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,164
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/apps-sites/internet-archeology/ccm/10131-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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses