Lining up data from two different files

Hi,

I have two different Excel tables. They contain a lot of the same data, but they don't necessarily contain the same number of records (one table contains records that the other doesn't have, and vice versa). So it might look something like this:

Table 1
MyColumn
---05---
---12---
---12---
---16---

Table 2
MyColumn
---04---
---05---
---12---
---13---

The goal is to structure each table such that, where MyColumn has a common value between the two tables, the record # would always be the same. Whereas if a particular MyColumn value is unique to that table, then the other table would have a blank record in that spot. This is what the user wants to see. So in this case, the final result should look like:

Table 1
MyColumn
---------
---05---
---12---
---12---
---------
---16---

Table 2
MyColumn
---04---
---05---
---12---
---------
---13---
---------

I'm thinking this will require a macro that loops through, compares column values, and inserts blanks where needed, but I can't imagine how this is going to work. Any ideas?

Please let me know if I'm not making sense.

Thanks,
hk

Anyone...?

Am I requesting something that can't be done?

bump......

bump......