+ Reply to Thread
Results 1 to 4 of 4

Move a row to a new location based on 6 different criteria

  1. #1
    Registered User
    Join Date
    05-17-2019
    Location
    Arizona
    MS-Off Ver
    2019
    Posts
    2

    Unhappy Move a row to a new location based on 6 different criteria

    I have about 180 rows of trip information I need to organize to 6 different teams. They need to be put on the team in order of time: early to late. I am having trouble figuring out the best way to go about this with my limited excel knowledge. In the attached picture, I need it to be moved to the team sections based on the value in column F. The number 1 needs the row to be moved to team 1 and so on as I'm assigning values to column F. The picture I attach shows what I'm working with and kind of how I'd need it to look. I need to assign on column F and have it move over in real time to the "Teams" so I can make sure it's a good map for the day. Any help will be appreciated.

    Thank you!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by rroybal58; 05-18-2019 at 03:56 PM.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Move a row to a new location based on 6 different criteria

    Please take the following construcftively. Since you are a first time poster, you can attach your file to the thread by uploading to the site server. At the bottom of the 'Post Quick Reply' box, click on 'Go Advanced', then click 'Manage Attachments' and follow the menu. By uploading the file, we will all be able to download it to our monitors and read it much better, work with it and provide much better response.
    Then when you have provide the file, you want to be specific in describing your objective. Avoid using indefinite pronouns that could refer to anything or anybody such as the ones in red font from you original post. Also avoid ambiguous open ended phrases like the ones in blue font. And pharases that could be misinterpreted like the one in green font.
    They need to be put on the team in order of time: early to late. I am having trouble figuring out the best way to go about this with my limited excel knowledge. In the attached picture, I need it to be moved to the team sections based on the value in column F. The number 1 needs the row to be moved to team 1 and so on as I'm assigning values to column F. The picture I attach shows what I'm working with and kind of how I'd need it to look. I need to assign on column F and have it move over in real time to the "Teams" so I can make sure it's a good map for the day. Any help will be appreciated.
    Instead of indefinite pronouns, use specific range references like "cells in columns A:D" or "Range with Name and quantiy". In other words, something that ties the data down to where it resides on the worksheet.

    Hopefully this will help you to describe your objectives so that someone can respond with useful suggestions and solutions.
    Last edited by JLGWhiz; 05-17-2019 at 09:15 PM.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Registered User
    Join Date
    05-17-2019
    Location
    Arizona
    MS-Off Ver
    2019
    Posts
    2

    Re: Move a row to a new location based on 6 different criteria

    Thank you so much for the advice. My second attempt to explain..

    A2,B2, D2 ...C2, B2, D2..so on need to be put on the team in order (i3-k3...n3-p3, i27-k27) of time: early to late. I've color coded the team area that I would like a2, b2, d2, to auto populate with the correlating team

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Move a row to a new location based on 6 different criteria

    This proposal employs a cell that contains only the team number i.e. cell I1 contains the number 5. Note that this number may be hidden (for aesthetic purposes) by choosing font = white for cell I1.
    The formula that populates I3:J29 is: =IFERROR(INDEX(A$2:A$159,AGGREGATE(15,6,(ROW($A$2:$A$159)-ROW($A$1))/($D$2:$D$159=$I$1),ROWS($A$1:$A1))),"")
    The formula that populates K3:K29 is: =IF(I3="","",INDEX(D$2:D$159,AGGREGATE(15,6,(ROW($A$2:$A$159)-ROW($A$1))/($D$2:$D$159=$I$1),ROWS($A$1:$A1))))
    The information for the other teams may be similarly filled.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Move row based on criteria
    By karmaimages in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2023, 11:30 AM
  2. Move Multiple Files into Specific Location Based On Criteria
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-14-2018, 08:44 AM
  3. VBA to Move Folders to Another location Based on Modified date
    By mvinay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2016, 10:02 PM
  4. Replies: 17
    Last Post: 05-23-2016, 11:04 PM
  5. Replies: 3
    Last Post: 05-17-2016, 05:14 PM
  6. [SOLVED] Macro to Move Rows to New Worksheets Based on Criteria & Then HIDE & Move Back
    By abro0821 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2014, 04:00 PM
  7. Replies: 3
    Last Post: 08-15-2013, 01:22 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