+ Reply to Thread
Results 1 to 3 of 3

Macro for copying - starting and ending based on value in row

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    39

    Macro for copying - starting and ending based on value in row

    All data is copied in the first column i.e. A
    Below is a sample of data that I need to work with. it is comprised of text and other weird format. The numbers that I am interested in have a space 0. example - "89.45 0"
    In these figures, I need to find the values that come below a cell having value - failed.
    below the cell that has failed, will always be a cell having value - node this is.
    now I need to count the number of rows of decimals that are coming below the failed cell.
    for example, using the below data, the data will be pasted starting from cell A1. Below the first "failed" cell value, comes "the node this is" cell, below this cell are the decimal numbers that have failed. unfortunately there is no clear end to the failed data except that the cell "node this is" is repeated. this will mark the end of the data that needs to be copied to a different location. The "failed" value can be repeated in the column, and I need the cells having the decimal formats.

    To make things simple and sum up the requirement. I need the values that come under "Failed" and that is starting after "node this is" and ending before the next " node this is"


    here
    there
    89.45 0
    and there is
    failed
    node this is
    76.98 0
    lala
    32.78 0
    meow
    12.89 0
    here is
    node this is
    blah
    98.56 0
    what
    failed
    node this is
    43.89 0
    56.65 0
    haha
    node this is
    23
    54
    hee

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Macro for copying - starting and ending based on value in row

    Hi rexer231,

    I am not sure that I totally understood you, but I hope this will help.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro for copying - starting and ending based on value in row

    Does this help?

    Please Login or Register  to view this content.
    Copies from Column A to Column C.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to find Starting value and Ending Value of the product
    By svenkata in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-27-2012, 02:27 PM
  2. how to code a userform to take average of row starting and ending at selcted dates
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2011, 11:54 AM
  3. Charts with setting starting and ending point on x (time)
    By yuri in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-24-2008, 08:28 AM
  4. [SOLVED] Starting work period on a Saturday and ending on a friday
    By JLyons in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM
  5. Starting work period on a Saturday and ending on a friday
    By JLyons in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2005, 10:06 AM

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