Posted by David Stanley on January 04, 2002 11:28 AM
I have two worksheets. One is a master sheet with a column of all our inventory item numbers and beginning inventory qty and values. My other work sheet has a column with inventory item numbers that I purchased this month, qty and value. I want to update my master sheet, beginning inventory, with purchases. My columns of item numbers don't match because my purchases worksheet only has item numbers that were purchased. I can do this in Access with linking tables and running update queries, but would like to update in excel. Is it possible?
Thank you for your consideration.