match and sort by two columns

**yowzerz** · 02-04-2010, 06:31 PM

Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column
G,H,I has the same corresponding sales data for the next month.

Although Column A and F both have customer names, there are many changes
month over month with the addition and deletion of certain customers so the
rows do not match up exactly. Is there a quick way to have the rows match up
according to customer names in column A and F and then sort them
alpabetically?

Currently my list looks like this:
Jan Feb
A A
B C
D D
F E
H F
L G
M H

I would like it to look like this:
Jan Feb
A A
B
C
D D
E
F F
G
H H
L
M

**martindwilson** · 02-04-2010, 08:08 PM

post a workbook!

**JBeaucaire** · 02-04-2010, 08:30 PM

Hi Yowzer, welcome to the forum.

Click GO ADVANCED and use the paperclip icon to post up your sample workbook.

**yowzerz** · 02-10-2010, 07:39 PM

Basically, I want the rows lined up by what is in columns A and M. There are some entries that are in A that are not in M, so the M through W would be blank in that row. There are some entries in M that are not in A, so A through K would be blank in that row. I hope this is clear for what I am looking to do. I appreciate your help.

**JBeaucaire** · 02-10-2010, 10:56 PM

Try this on a copy of your sheet:

Please Login or Register  to view this content.

**yowzerz** · 02-12-2010, 12:49 PM

wow thank you soooo much. you just saved me a couple hours of work every month.

**JBeaucaire** · 02-12-2010, 01:23 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

**yowzerz** · 02-12-2010, 02:14 PM

I will be sure to mark solved. I hate to ask again, but is this possible to do with 4 columns? Its pretty much the same exact thing as the previous example but with 4 tables that need to be aligned by columns B, O, AB, AL. This would be a life saver!!!

**JBeaucaire** · 02-16-2010, 11:04 PM

Hehe...not exactly the same thing, but try this:

Please Login or Register  to view this content.

Be patient, this one will take a while to loop.

**yowzerz** · 02-19-2010, 12:39 PM

Thanks so much for your time and help! I'm sorry, I got an error message stating "Type mismatch"

**JBeaucaire** · 02-19-2010, 02:50 PM

Where in the code? You can speed up this process by providing more detail than that...or post up the misbehaving workbook with the macro already in it so I can see for myself.

**yowzerz** · 02-22-2010, 07:04 PM

thanks for all your help, ive posted the workbook

**JBeaucaire** · 02-22-2010, 07:18 PM

1) Delete the macro you downloaded from the ThisWorkbook module. The macro didn't go in there to begin with, and the forum corrupted the upload and put a bunch of ** in the code in place of column references I had used.

Delete it.

2) Click on INSERT > MODULE and post the code in a regular module. Download the code above again, I've repaired the corrupted code.

Make sure you only put global workbook-event macros into ThisWorkbook, sheet-event macros into the sheet modules...all other macros go in regular modules.

**yowzerz** · 02-24-2010, 03:44 PM

sorry, im getting yet another error message. am i doing something wrong? it says

Run-time error '1004':
The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort By box isnt the same or blank.

**JBeaucaire** · 02-24-2010, 04:38 PM

Sorry, change this line near the top:

Please Login or Register  to view this content.

And this near the bottom:

Please Login or Register  to view this content.

**yowzerz** · 03-04-2010, 05:53 PM

Absolutely perfect. THanks for all your time!!!

**JBeaucaire** · 03-04-2010, 06:00 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

**JBeaucaire** · 03-04-2010, 06:09 PM

As per a Private Message:

Go to your original post, post #1 at the beginning of this whole thread.
Click on EDIT
Click on GO ADVANCED
Next to the title is a drop box, set this prefix box to [SOLVED]

==========
Across from my name in any post, this one included, are some icons. The Reputation Feedback icon is the one that looks like blue scales.

**nachi** · 07-21-2011, 08:41 PM

Can you explain this macro or its difficult to explain, Can you atleast explain the concept

**nachi** · 07-21-2011, 08:56 PM

Hi All,

Can you resolve my excel and explain me the concept how to create macro, My problem is same thing of matching and sorting, but comparison of one column to many, for ex: Column A compare to B, C, D ..etc and sorting respective with column A. Is my problem is recognize by you. I have attached the excel for your reference.

**KaySwiss9** · 07-23-2013, 03:58 PM

I am trying to do the same thing with my workbook, but am having difficulties. Could you show me how? I have attached the relevant file. (I am matching Columns A & B; C is data related to Column B).
Thank you.

**JBeaucaire** · 07-23-2013, 06:54 PM

Kay,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

====================

match and sort by two columns

LinkBack

Thread Tools

Display

match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns

Re: match and sort by two columns (New Query)

Re: match and sort by two columns

Re: match and sort by two columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions