<div>
<div class="content wysiwyg-content">
I am trying to find a macro or add-in that will insert a new row when it finds a change in value in a particular column. &nbsp;In example below, I want to be able to select column A (Team) and have Excel insert a new row when it finds a new value. In this case I'd get a new row under Team and then under 0123.<br />
<br />
<br />
TEAM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SCHOOL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;STYLE &nbsp; &nbsp;EMBELLISH &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GARMENT COLOR &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
0123 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PURDUE &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BAC &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;WDMK &nbsp; &nbsp; &nbsp; &nbsp; BLKOGD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
0123 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PURDUE &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BAC &nbsp; &nbsp; &nbsp;WDMK &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; BLKOGD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
0143 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BAYLOR &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BAC &nbsp; &nbsp; &nbsp;WDMK &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HNTGLD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
0150 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GEORGIA &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BAC &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;WDMK &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLKRED
</div>
</div>


I am trying to find a macro or add-in that will insert a new row when it finds a change in value in a particular column.  In example below, I want to be able to select column A (Team) and have Excel insert a new row when it finds a new value. In this case I'd get a new row under Team and then under 0123.


TEAM	SCHOOL	STYLE    EMBELLISH	 GARMENT COLOR	
0123	PURDUE	BAC	     WDMK         BLKOGD	               
0123	PURDUE	BAC      WDMK	        BLKOGD	               
0143	BAYLOR	BAC      WDMK  	HNTGLD	                
0150	GEORGIA	BAC	     WDMK    	BLKRED

Insert a blank row based on the value in a certain column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.