Previous Topic Next Topic

Excel Macro

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

Similar discussions

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

11 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses