Align 3 columns with 2 columns of matching data

**loritee** · 08-22-2013, 04:12 PM

Hi,

I'm a newb and I'm sure this has been done before so bare with me.

I need help to align first two columns and sort adjacent 3. I'm able to align using =IF(ISERROR(MATCH(A3,$DF$1:$DF$330,0)),"",A3), however sorting is eluding me. See below - I'm only posting a portion of the sheet because it has some 3000+ rows. Thanks for your help.

Item Item Qty. on Hand Minimum On Order
021-013 021-029 1 1 0
021-015 110-014 4 4 0
021-016 121-009 2 2 0
021-028 122-602 58 75 26
021-029 137-390 0 8 11
110-014 137-452 2 3 0
121-001 137-457 22 26 0
121-007 145-951 5 5 0
121-009 148-302 1 2 0
122-602 156-001 1 2 0
137-390 156-002 2 2 0

**elayaz** · 08-23-2013, 12:20 AM

Hello,

Welcome to the forum.. Please post the sample data as an excel file.
Select go-advanced button and use the paperclip icon to attach the file.

**millz** · 08-23-2013, 02:00 AM

I have made a macro for similar function before. You can try and see if this suits your needs.

Please Login or Register  to view this content.

Edit: this was made very long ago before I discovered about Cells() object/method, so I was using a separate function to convert Column numbers to alphabets

**loritee** · 08-23-2013, 09:28 AM

elayaz

Excel sheet is attached.

Column DE to be matched/aligned with A (DF - DH) to be sorted in keeping with.

millz ...thank you. I'll give it a try and let you know if it works.