Move entire row to another row based on a cell value

ANTJONZ

New Member
Joined
Jun 27, 2018
Messages
2
Hello everyone. I need a code that will move specific rows to other rows in the same sheet based on a Cell Value. My spreadsheet has 4 sections (high risk, medium risk, low risk, completed). In column "J" of each section will be a number or a letter. Any number less than 3 is high risk, 3-7 is medium risk, 8 and above is low risk, the letter C is completed. My values for each row are located in C through M. My request is, anytime the value in cell J changes, I need that row range to move into the appropriate "risk" row range on the spreadsheet. Each "risk" section has a range of rows, but the range can be expanded or made smaller based on the number of Risk rows that meet the criteria. Please let me know if more clarity is needed. Thanks in advance!
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
Hi ANTJONZ, welcome to the forum. It would be pretty easy to write a macro for most of what you describe, except for the removing of the row from one category and moving it to a different one. That is because as you add or delete rows within the category areas, the starting and ending row numbers change for all but the starting row of the first category. But, if you have a header at the beginning of each section of categories in a specific column that could be used to locate the beginning row of that category and a macro could be developed. We would still need to know if the data in C:M for the category starts on on same row as the section header or if it is offset and by how many rows if it is offset. If you can provide that additional information I will try to fix you up with a macro to do what you want.
 
Last edited:

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
I tried to respond to your PM but got a message saying the mail box is full. That is odd since you only show one post. At any rate I do not accept any personal emails for issues that originate on this forum because it deprives the other members of the abiltiy to participate. You can click on the word Attachments in large orange letters below and it will take you to other links that explain how to attach images in these threads. One simple way is to make an example on an Excel sheet, highlight it, right click then use the borders icon to put borders around all the highlighted cells. Then copy that range and paste it into the thread reply pane.
 

ANTJONZ

New Member
Joined
Jun 27, 2018
Messages
2
Let's give this a try....

SUMMER REPORTApril 18, 2019
LOCATIONBASE/OSRTYPEVISIT TYPE#REMAININGLINE END DATEOWED TO SCHEDULEBUFFER
HIGH RISK (<3 DAYS OF CONTINGENCY)1 05/22/1905/22/190
2 05/22/1905/22/190
3 05/26/1906/07/1912
4 04/30/1904/30/190
5 06/15/1906/15/190
6 06/14/1906/15/191
7 05/22/1905/22/190
8 05/30/1905/31/191
9 04/30/1904/30/190
10 06/06/1906/07/191
11 06/09/1906/07/19-2
12 06/04/1906/07/193
13 06/04/1906/07/193
14 06/05/1906/07/192
MEDIUM RISK (3 -7 DAYS OF CONTINGENCY)1 05/25/1905/31/196
2 05/31/1906/07/197
3 06/08/1906/15/197
4 06/08/1906/15/197
5 06/02/1906/07/195
6 06/27/1906/30/193
7 05/14/1905/20/196
8 05/10/1905/15/195
9 05/19/1905/23/194
10 06/02/1906/07/195
11 06/10/1906/15/195
12 04/26/1904/30/194
13 04/26/1904/30/194
14 05/31/1906/07/197
MINIMAL/LOW RISK (>8 DAYS OF CONTINGENCY)1 06/03/1906/15/1912
2 05/19/1905/31/1912
3 05/21/1906/07/1917
4 05/29/1906/07/199
5 05/30/1906/07/198
6 04/16/1904/24/198
7 04/21/1904/30/199
8 05/28/1906/07/1910
9 04/26/1905/15/1919
10 05/26/1906/07/1912
11 06/01/1906/15/1914
12 07/06/1907/15/199
13 05/02/1905/15/1913
14 05/11/1906/07/1927
COMPLETED1 03/24/1904/14/19C
2 03/28/1904/03/19C
3 04/10/1904/14/19C

<colgroup><col span="8"><col><col span="2"><col><col></colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,127,613
Messages
5,625,848
Members
416,139
Latest member
MattBoard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top