Populate data from spreadsheet to spreadsheet

[Closed]
Report
Posts
1
Registration date
Wednesday November 13, 2013
Status
Member
Last seen
November 13, 2013
-
Hello,

Project Description:
For daily customer orders, I need to be able to quickly and automatically have all rows in column D populated with the current Daily Inventory Quantity for specific item codes listed in Column A. The Source of the Daily Inventory Quantity is in Column AB on another spreadsheet containing the Daily report.

Note, the codes listed in column A varies, and are not in sequence (but I'm pretty sure that can be adjusted) and are a collection of codes per customer order, also located in the Daily Report, which is a much bigger list.

If it is possible, I would like to create a formula or macro (something simple yet effective because I am not a computer coder or specialist) that can separately or simultaneously locate the codes and quantity in the Daily Report, and then list the quantity respectfully in column D.