I have two spreadsheets. They are somewhat identical. The big file has
thousands of products showing how many are in stock. The smaller file
has a fraction of these same products and I need to update the quanity
in stock field in my smaller spreadhseet every day. Is there a script
or method I can use to have this done without doing each cell one by
one?

Thanks,
Rick