Matching similiar columns

[excelrookie82]

Alright, I'm an Excel rookie and I'm wondering if it will do what I need it to. My goal is to match the same "item" numbers with each other. If you look at the "before" attachment, do you see how the E and F columns have some of the same numbers in them (6, 10, 18, 24)? I'm hoping there is a way to sort the information so that the rows with the same numbers in columns E and F will be next to each other. In the "after" attachment, do you see how E and F columns are sorted so that the numbers are in numerical order? All of the information to the left of E and the right of F didn't change but they are now sorted in order. Column F has 2 then E has 3 F has 4 and they both have 6 then F has 8, E has 9 and both have 10 again, etc.

Please note that I'm using Excel XP, not 2007 like it shows in the screen shots.

I don't know if this is even possible but any help would be appreciated. Thanks!!!

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[excelrookie82]

Sorry, I'm not even sure what I'm trying to do so I wasn't sure what to title the thread. I hope the new title works a little bit better?

[shg]

Much better. I have a VBA routine that does this. Are you comfortable with that?

[excelrookie82]

i have no clue what vba is

or i should say, i don't know how to use and i barely know what vba is.

[shg]

The code is at the end of the post. Copy it to a code module as follows:

Adding Code to a Sheet module
1. Copy the code from the post
2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the selected worksheet.
3. Paste the code in the window
4. Press Alt+Q to close the VBE and return to Excel

Then,

1. Move col E to col A (select the column, hold down the Shift key, and drag it to col A).

2. Select (what is now) A1, hold the Ctrl key, and select F1 (so that both are selected).

3. In the Names box (left of the formula bar), type keys

4. Do Alt+F8, and run AlignKeys.

Please Login or Register  to view this content.

[excelrookie82]

I'll try this when I get to work tomorrow. Thanks for the help, I really really appreciate it!

[excelrookie82]

thanks again. this worked like a charm! I really appreciate your help.