Move entire row to another row based on a cell value

[ANTJONZ]

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!

 

[JLGWhiz]

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.

 

[JLGWhiz]

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]

Let's give this a try....

	SUMMER REPORT	April 18, 2019
	LOCATION	BASE/OSR	TYPE	VISIT TYPE	#REMAINING	LINE END DATE	OWED TO SCHEDULE	BUFFER
HIGH RISK (<3 DAYS OF CONTINGENCY)	1					05/22/19	05/22/19	0
2					05/22/19	05/22/19	0
3					05/26/19	06/07/19	12
4					04/30/19	04/30/19	0
5					06/15/19	06/15/19	0
6					06/14/19	06/15/19	1
7					05/22/19	05/22/19	0
8					05/30/19	05/31/19	1
9					04/30/19	04/30/19	0
10					06/06/19	06/07/19	1
11					06/09/19	06/07/19	-2
12					06/04/19	06/07/19	3
13					06/04/19	06/07/19	3
14					06/05/19	06/07/19	2
MEDIUM RISK (3 -7 DAYS OF CONTINGENCY)	1					05/25/19	05/31/19	6
2					05/31/19	06/07/19	7
3					06/08/19	06/15/19	7
4					06/08/19	06/15/19	7
5					06/02/19	06/07/19	5
6					06/27/19	06/30/19	3
7					05/14/19	05/20/19	6
8					05/10/19	05/15/19	5
9					05/19/19	05/23/19	4
10					06/02/19	06/07/19	5
11					06/10/19	06/15/19	5
12					04/26/19	04/30/19	4
13					04/26/19	04/30/19	4
14					05/31/19	06/07/19	7
MINIMAL/LOW RISK (>8 DAYS OF CONTINGENCY)	1					06/03/19	06/15/19	12
2					05/19/19	05/31/19	12
3					05/21/19	06/07/19	17
4					05/29/19	06/07/19	9
5					05/30/19	06/07/19	8
6					04/16/19	04/24/19	8
7					04/21/19	04/30/19	9
8					05/28/19	06/07/19	10
9					04/26/19	05/15/19	19
10					05/26/19	06/07/19	12
11					06/01/19	06/15/19	14
12					07/06/19	07/15/19	9
13					05/02/19	05/15/19	13
14					05/11/19	06/07/19	27
COMPLETED	1					03/24/19	04/14/19	C
2					03/28/19	04/03/19	C
3					04/10/19	04/14/19	C

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