+ Reply to Thread
Results 1 to 4 of 4

Return a sequence of rows??

  1. #1
    Registered User
    Join Date
    08-05-2017
    Location
    South Carolina
    MS-Off Ver
    Office 2013
    Posts
    15

    Return a sequence of rows??

    I have an excel file that I'm trying to copy rows based on the value of a cell, but wanting it to copy the rows in a sequence. Any idea how I could do this?

    So, the hope would be to find the first "abc" then "def" then "ghi". Then find the next set. Then the next. And copy the rows in this order to a separate sheet.

    abc abc def ghi ghi def ghi ghi
    1274648 7165372633 937459374 2648467384

  2. #2
    Registered User
    Join Date
    08-05-2017
    Location
    South Carolina
    MS-Off Ver
    Office 2013
    Posts
    15

    Re: Return a sequence of rows??

    Sorry about the table I posted. The text values should be in one column and the number values in an adjacent column.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Return a sequence of rows??

    So better way is attach example excel file with a good description


    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Return a sequence of rows??

    If you want it in other sheet then simply

    1) copy the whole data to other sheet.
    2) sort left to right by the heading.

    should do it.
    You can filter/edit the data from there, if you need to.

+ 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] Return a number in sequence
    By Berna11 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2017, 06:56 PM
  2. Replies: 3
    Last Post: 07-10-2016, 03:32 AM
  3. Replies: 2
    Last Post: 12-29-2015, 02:21 PM
  4. [SOLVED] Function to return sequence from rank?
    By cocacrave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2015, 11:22 AM
  5. Delete Rows in Sequence
    By Jakila2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2011, 05:40 AM
  6. return data for last record in sequence by row
    By tinkerbelle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2010, 09:39 AM
  7. Count rows not in sequence
    By kamill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2005, 09:06 AM

Tags for this Thread

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