Good morning,

I am trying to develop a spreadsheet for our company at the moment to show real time updates on inventory. We have a folder specifically for inbound and one for outbound, with item codes for each material. What I am wanting to know is there a way for me to point Excel to Folder A and then to Folder B then get the sum as a real time update? I know there may be some scripting involved possibly, just wanting to know if this is possible and how I may need to go about doing it.

Thanks,

Michael
Plastic Resources, Inc.

Are the items in a specific order? Do some items exist in one file and not the other? Why not have both sheets in the same workbook?

At any rate, this should present little problem. You can get the data from one sheet or the other quite easily using various means including sumif, lookup functions, etc. Heck, oif the item lists are identical, you don't need anything fancy at all, just sheet1!a1 +sheet2!a2. That though is risky so I would use something more definite.

Some sample sheets would help if this doesn't get you what you want.