Google Answers Logo
View Question
Q: Data sorting Problem is Excel ( Answered 5 out of 5 stars,   0 Comments )
Subject: Data sorting Problem is Excel
Category: Computers > Software
Asked by: tw32-ga
List Price: $50.00
Posted: 08 Jun 2004 08:54 PDT
Expires: 08 Jul 2004 08:54 PDT
Question ID: 358168
I have two seperate sheets of data. I want to find if the is a match
in one column and if so move that data to the same line then sort.

This is how the raw data would be shown

First Sheet                    Second Sheet
100   $5000                    400   $20000
200   $1000                    300   $30000
300   $10000                   500   $80000
400   $20000                   100   $60000
500   $30000                   200   $70000
350   $45000                   600   $80000

      This is how I would like the data to be shown after it is combined

100   $5000            100   $60000
200   $1000            200   $70000
300   $10000           300   $30000
350   $45000          
400   $20000           400   $20000
500   $30000           500   $80000
                       600   $80000

Request for Question Clarification by maniac-ga on 08 Jun 2004 14:59 PDT
Hello Tw32,

Could you clarify a few points before I start preparing an answer?
 - I assume you won't mind a solution using a macro - please confirm.
I will include step by step instructions on adding the macro to a
 - Which version of Microsoft Excel are you using so I can check for compatibility?
 - How do you want to select the sheets to be combined? For example,
using fixed names such as "Sheet1" and "Sheet2", the first two sheets
of the workbook, or the sheet currently displayed (and the one
 - I suggest creating a third sheet with the combined data, preserving
the contents of the first and second sheet. If that is not OK, which
sheet should get the combined data?
 - Do you have column headings you want copied into the combined data?


Clarification of Question by tw32-ga on 09 Jun 2004 05:14 PDT
Thanks for the reply.  Yes a macro would be fine, but I have no idea
how to set them up so it would have to be step by step.  I am using
Excell 2002.  Combining the data to a third sheet would be fine, and
there would be no need to copy column headings.  I just need to make
sure the column where the data is common shows up on the same row in
the new sheet.
Subject: Re: Data sorting Problem is Excel
Answered By: tox-ga on 10 Jun 2004 03:16 PDT
Rated:5 out of 5 stars
Hi there,

First, please download the following file:

and unzip CombineSort.xls into a folder.

To run:
Ensure that you are able to run macros from Excel. To do this, goto
Tools > Options > Security > Macro Security... and ensure the
Medium/Low radio button is selected in the Security Level tab.

1. Open the Excel document contained the data formatted according to
your specifications.  Ensure that the sheets are called "Sheet1",
"Sheet2" and "Sheet3".  The results of the macro will be displayed in

2. Open CombineSort.xls. If your are prompted, ensure you Enable Macros.

3. In the Excel document containing your data, goto Tools > Macros >
Macros... or press Alt+F8. In the drop down menu labeled "Macros in:",
select All Open Workbooks. The the selection box above,
CombineSort.xls!CombineSort should be selected. Click Run.

4. The correct data should be displayed in Sheet3.

If you require any further clarifications, please let me know.

Best regards,
tw32-ga rated this answer:5 out of 5 stars
Works great. Just what I was looking for. Thanks

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy