Results 1 to 2 of 2

If ... find next ... and copy to new column without blanks

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Groningen
    MS-Off Ver
    Excel 2010
    Posts
    25

    If ... find next ... and copy to new column without blanks

    Hi guys,
    I have several hundred .txt files which each contain thousands of rows. What I need to do is find rows which start with a certain string ("Details" *) and copy this to a new column without blanks. The added difficulty is that I also need to copy the first instance of "Onset" * after this indicator (variable # of rows between them) and also copy this to a new column without blanks. See attached for an example what I would like to be the outcome.
    Any and all suggestions are very much appreciated.
    Kind regards, Dennis

    p.s. Bonus problem! Is there a way to open all the .txt files and run the solution for the problem above on all of them?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy Column(s) based on another column dynamicly without blanks
    By johnmelvin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2013, 12:24 PM
  2. [SOLVED] find a column by date and filter that column by removing blanks
    By rsami in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2013, 10:56 PM
  3. [SOLVED] Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2012, 06:11 AM
  4. Replies: 1
    Last Post: 08-13-2012, 10:59 AM
  5. Scan a Column A (numbers and blanks) and copy its contents WITHOUT BLANKS into Column B
    By bighandsam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 05:16 PM

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