Updating data into one spreadsheet from another

[Rick]

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

 

[Guest]

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


http://www.cpearson.com/excel/lookups.htm