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

**teja32@gmail.com** · 03-21-2011, 04:30 AM

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** · 03-21-2011, 06:08 AM

hi, please check attachment

**TMS** · 03-21-2011, 06:42 AM

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

Sub Macro1()

Dim CellAdd As String
Dim CellToChange As Range
Dim AddText As String

AddText = vbCrLf & _
          "Step1: Open URL" & _
          vbCrLf & _
          "Step2: Enter UserID and Password"

On Error Resume Next
Set CellToChange = Cells.Find(what:="Login", lookat:=xlPart)
CellAdd = CellToChange.Address
CellToChange = CellToChange & AddText
Do
    Set CellToChange = Cells.FindNext(CellToChange)
    If CellToChange Is Nothing Or CellToChange.Address = CellAdd Then Exit Do
    CellToChange = CellToChange & AddText
    Debug.Print CellToChange; CellAdd
Loop
End Sub

Regards

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

Re: Macro for searching for a Word and If found append some more data steps to that c

Re: Macro for searching for a Word and If found append some more data steps to that c

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions