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