+ Reply to Thread
Results 1 to 4 of 4

Conditional Row Selection

  1. #1
    Registered User
    Join Date
    02-10-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    2

    Conditional Row Selection

    I am new to this forum and a fairly well versed user of Excel, and looking forward to not only helping others but getting help when I'm stumped, so here it goes. I have a jobs report with the jobs numbered vertically. Each job has status info that is approximately 20 columns wide. The jobs are tracked in one of four stages indicated by an "X" in a particular column pertaining to that stage. I would like to extract all the data in each row and create a separate sheet with just those jobs within each of the four stages, keeping the original report intact. Is there custom programming or a macro for this. Thanks.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Conditional Row Selection

    It will be much easier to help if you attach an example workbook, showing your data structure, and what your desired outcome looks like
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Conditional Row Selection

    Hi, welcome to the forum. I think what you want can be achieved via Advanced filter. Have a look at it.
    If you are pleased with a member's answer then use the Star icon to rate it.

  4. #4
    Registered User
    Join Date
    02-10-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Conditional Row Selection

    Thank you....got it solved.

+ 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. conditional selection
    By murarihyd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2011, 03:49 PM
  2. conditional selection
    By txtrooper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2010, 09:23 PM
  3. Conditional Selection of Cells
    By pakiyabhai in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-05-2010, 04:35 AM
  4. conditional lookup and selection
    By philiasfogg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2009, 07:21 AM
  5. Conditional Selection (Drop Down Box)
    By heatwave in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2008, 02:54 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