Is there a way to compare records from one spreadsheet to another, then have
the missing or (new records) imported into the spreadsheet that they are
missing from.

Basically, I have one spreadsheet that people are constantly working with
and I'm looking to import new records from another spreadsheet that is being
used as a datasource. Column A:A could be used as a comparison between the
two spreadsheets. I'm not sure if microsoft query could be used to do this?

Any information would be greatly appreciated.

Thanks,





--
Regards,

timmulla