I have 2 tables side by side in a spreadsheet. I need to compare the 2
tables and if the names, departments etc appear in table 1 (on the
left) but not in table 2 on the right I need a macro to insert cells in
table 2 at the appropriate position and then copy the info from table 1
and paste it into the newly inserted cells in table 2 on the right so
that both tables have the same values in the same rows. The length of
the tables could vary from 20 rows to 3000 rows and may not always be
in the same location (cells) when I receive them so the macro would
need to be "relative"

Any help on this would be greatly appreciated.

Many thanks in advance,

Taffy