Results 1 to 5 of 5

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

Threaded View

  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

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. [SOLVED] 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