Importing new records

[timmulla]

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,

 

[Roland]

maybe

you could use cells.find inside a loop that will through the cells on the
datasheet and search either a set number of times or until a certain value is
found.

You can use the cells.find command to set a variable range to use to copy
the data from one sheet to another.