Align and insert rows based on reference column

**clarkd6147** · 03-27-2012, 03:22 PM

Hi Everyone,

I have an excel spreadsheet in which I have inserted a reference column (A) and would like to horizontally align column B through column D, inserting empty rows as needed. In this example, 112 in the Number column would be moved down one row. This one has really stumped me. Can an Excel genius who sees this help? Thanks!

Here's an example:

REF Number Category Class
111 112 B D
112 113 A C
113 114 C B
114 123 B B
121 131 F O
122 133 G Y
123 221 C C
131 231 E U
132 212 A C
133 221 R T

**Franck Knight** · 03-27-2012, 03:33 PM

Maybe not the best at this, but I whipped this up real quick for you.

Please Login or Register  to view this content.

Simply put, this checks if Column A is smaller than Column B (and A is not empty), and if so, pushes the row down one.

Since the size of the range will change, I set it up so it checks 100 rows, but you can change that to a higher number as needed, or 65536 (excel 2003 limit) to get everything.

**Pichingualas** · 03-27-2012, 04:37 PM

A simple change that will check up to the used range, updated at each step:

Please Login or Register  to view this content.

Align and insert rows based on reference column

LinkBack

Thread Tools

Rate This Thread

Display

Align and insert rows based on reference column

Re: Align and insert rows based on reference column

Re: Align and insert rows based on reference column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions