+ Reply to Thread
Results 1 to 2 of 2

Search and extract results to a txt file

  1. #1
    Registered User
    Join Date
    06-07-2010
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2003
    Posts
    1

    Search and extract results to a txt file

    Hi
    I have an excel worksheet containing around 70thousand records. I am planning to write a macro that would search a string in a column (multiple occurances) and extract specific data from the row the string is found and output the same to a text file.

    eg: Suppose column I contains the data i want to search for and suppose the search string is found at I3, I34, I130. Then I need to extract the following data in the following format in text file

    A3,D3,I3
    A34,D34,I34
    A130,D130,I130

    Appreciate your help.

    regards
    Vijay

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Search and extract results to a txt file

    Hi vijayboomi,
    Welcome to the Forum.

    What code do you have so far?
    If none, the first place to start is researching "find" in the VBA help files.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1