Pulling data into cells from Workbook A - B, based on the presence of data in the column.

Hello,

I'm new to this forum, but from what I've seen there's a very active and supportive community. I've been using excel logic and lookup functions for years (never as advanced as actually utilizing VBS code or macros), however this one has me stumped.

I have a list of products (dimensional lumber) that includes information on sizing, length, how many boards are in a package, and how many cubic meters in a package.

Simply by entering how many packages there are, the total cubic board meters and total pieces is calculated.

This information is entered via container, down a list of up to 18 containers, each container being a sheet.


What I need to do is have the information automatically pulled into a packing list that will add each sheet's entered information across the row.

I've tried to use vlookup to isolate the columns to pull from and add on the packing list, but I'm getting either a #REF or #VALUE error. I've set the bound higher than the highest package number, but still the error persists.

Attached are the two files I need to have linked together.

Thank you for any help you can offer,

ThetaBacon

No one has any ideas eh?