The easiest method is to use VLOOKUP(). See:


http://www.cpearson.com/excel/lookups.htm
--
Gary''s Student


"Rick" wrote:

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