+ Reply to Thread
Results 1 to 5 of 5

Way to move rows to the bottom of the workbook based on data in cell.

  1. #1
    Registered User
    Join Date
    03-09-2021
    Location
    United States
    MS-Off Ver
    365
    Posts
    2

    Way to move rows to the bottom of the workbook based on data in cell.

    I am looking to move rows based on a couple of things "In Progress", "Not Started", or the cell is "Blank"(no data as sometimes we leave it blank on purpose) in Column F I want the rows with those words to always be at the bottom of my list where data was last entered so say my last entry was 19 I start entering data on 20. The ones that state "In Progress" and "Not Started" are for example at 18 and 19(at this time since it's the bottom of the list) I enter in data in row 20 and the status of "Reassigned" and that tab will then get moved to 18 and the "In Progress" and the "Not Started" would drop to Row 19 and 20 since the formatting states "move". I also need to keep the conditional formatting for each of those cells that are being moved since it's adding data to another part of the sheet. Once the status of those cells are changed I want them to go back up to where they were on the sheet sorted by the "Date Requested"(1st) and "Client Name"(2nd) after the "Status" has been changed to one of my other selections. I only need this done between A2:L475 I have data in cells M2:U5 and A500:C528 that can't be touched/moved as they are the data from the rows and they all being added up to one for daily and weekly totals. Is there anyway to do this? What I want is very specific and everything I was finding on the internet wasn't what I was looking for it just kept doing something close to what I was wanting but it was never exactly what I needed.

    Thanks in advance!
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Way to move rows to the bottom of the workbook based on data in cell.

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Way to move rows to the bottom of the workbook based on data in cell.

    The best I can suggest is to have another column which contains a number based on the status, which you can then use to sort. The formula in that new column could be something like this:
    =IF($F2="",9,IF($F2="Not started",8,IF($F2="In progress",7,1)))
    Then you can sort using 1st that column, 2nd date requested and 3rd client name. Whenever you change a status you'll need to re-apply the sort, though that shouldn't take too much time?
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  4. #4
    Registered User
    Join Date
    03-09-2021
    Location
    United States
    MS-Off Ver
    365
    Posts
    2

    Re: Way to move rows to the bottom of the workbook based on data in cell.

    Sorry about that. with the spreadsheet attached. I would like to have rows with the criteria of "In Progress, Not Started, or "ISBLANK" in the "Status" Column F. In this case rows 2, 5, and 6, (A:L)would be moved to the bottom where the last row that data was inputted in this instance they would move to rows 7, 8, and 9 and the data that is there would move up to 4, 5, and 6 as they aren't part of the criteria. As a new row is added based on the "status" the new one Row say 10 since it's next would either move to number 7 or stay where it is based on the "status" that is selected. Once I change the status of "Bob #1" to "No Conflict" or any other "Status" it should automatically go back in the list to be sorted by Column A "Date Requested" then by Column C "Client Name".
    Attached Files Attached Files

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

    Re: Way to move rows to the bottom of the workbook based on data in cell.

    Hello jordanmiller7890 and Welcome to Excel Forum.
    I interpret the last sentence in post #4 to mean that you don't want to have to apply the sort feature as suggested by Aardigspook. I feel that in order to accomplish what you want without using the sort feature will require VBA. You may want to ask one of the moderators/administrators (see the Members List button above) to move this thread to the appropriate forum.
    I hope that you have a blessed day.
    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 cell to bottom of the table based on value
    By kelleheruk in forum Excel General
    Replies: 2
    Last Post: 11-27-2020, 07:02 AM
  2. Hide rows from bottom up based on a cell value
    By memNJ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2019, 02:28 PM
  3. [SOLVED] Need to move row to bottom of another worksheet based on cell criteria
    By amymsellers in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-30-2016, 09:49 PM
  4. Automatically move rows of data to different worksheets based on cell criteria
    By Kaz09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 12:49 PM
  5. [SOLVED] Move all rows where cell = "complete" to the bottom of the list
    By floribunda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2013, 03:25 PM
  6. How to move rows to new sheet based on cell data
    By jacobmast in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2011, 12:18 AM
  7. How can I take specific rows and move them to the bottom
    By Mcobra41 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2005, 01:06 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