Macro for searching for a Word and If found append some more data steps to that cell

[[email protected]]

Hi,

I have a Excel sheet with different data in the rows.

I need to search for a particular word and if found i need to append the data in the column along witthe existing data.Can I write a macro for doing this job. I need to do some 400 times.

For example:

Input:
A1: Open the Application and Login
A2: Use the Data in application
A3: The Login Application needs to be activated


Now whereever I find the word Login I need to append the following data stpes to that particular cell

Step1:Open URL
Step2: Enter UserID and Password

Output:
A1: Open the Application and Login
Step1:Open URL
Step2: Enter UserID and Password
A2: Use the Data in Application
A3: The Login Application needs to be activated
Step1:Open URL
Step2: Enter UserID and Password





Thanks

[watersev]

hi, please check attachment

[TMS]

This demonstrates the principle though it may need to be made more generic:

Please Login or Register  to view this content.

Regards