Vlookup to update automatically

[DrowningInQuicksand]

Hello,

I have a working VLOOKUP formula for generating a one page inventory list.
It grabs values from worksheets in other spreadsheets.
The only problem is it doesn't automatically update.
Please, someone help me!

Thanks in advance,

Drowning in Quicksand

 

[JTWood]

Check File > Options > Formulas and make sure calculations are set to automatic

 

[DrowningInQuicksand]

Hello JTWood,

Thank you for your prompt reply. Actually, it is set to automatic. I'm wondering if I have to open & close one or more sheets after adjusting values on sheet where adjustments are made?

 

[JTWood]

When you say "worksheets", do you mean "workbooks"? As in, a separate file?

 

[DrowningInQuicksand]

Tomorrow, I will elaborate & upload two files to our dropbox account that will give you a better idea of what I'm trying to do.

Thank you

 

[DrowningInQuicksand]

Good morning JTWood,

Currently, we record inventory in/out quantities on Excel spreadsheets.
When dealing with products that are available in various sizes, shapes & colors, multiple worksheets per spreadsheet are required. A perfect example of a multi-sku'd product is the Microfiber Lens Cloth. This item is available in 18 colors per size, for each of the three available: sizes, small, medium & large. I included only those worksheets relating to 3 of the 18 cloth colors, & for only the small variety of cloth.</SPAN>

The goal of this project is to create a worksheet listing all our products, equipped with automatically updatable VLOOKUP values that represent all net differences since the last lookup. The values are derived from the bottom-most value appearing under the column named Balance, on the appropriate inventory worksheet. Each worksheet contains several columns of data. The column named Balance is the only relevant column on each inventory worksheet (in the spreadsheet named 4x7_Copy) for this assignment.
</SPAN>
As you can see from C5 on the spreadsheet named Inventory_Copy, the code has been created & works properly. However, I don't know how to update the code automatically. Having the values update automatically would save me a considerable amount of work on a regular basis.


Thank you</SPAN>

 

[DrowningInQuicksand]

Please see Dropbox links I neglected to include in previous post:

The column named Balance is the only relevant column on each inventory worksheet (located at https://www.dropbox.com/Cloth4x7_Copy.xls</SPAN>) for this assignment.
</SPAN>
As you can see from C5 on the following spreadsheet: https://www.dropbox.com/Inventory_Copy.xls</SPAN>, the code has been created & works properly. However, I don't know how to update the code automatically. Having the values update automatically would save me a considerable amount of work on a regular basis.


Thank you</SPAN>