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
worksheet.
 - 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
following).
 - 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?

  --Maniac

---

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.

Hi there,

First, please download the following file:
http://www.maxlin.ca/tos/ga/CombineSort.zip

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
Sheet3.

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,
Tox-ga

Works great. Just what I was looking for. Thanks