Here's what I need to do...I have some list boxes created, and I have them
linked together.

However, I need the item in list box 2 to change based on what list box 1 is.

For Example

In list box 1 I have 3 entries of inventory id's being "a","b", and "c"

In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3"

now lets say that I have "3" of a

when I click list box 1 and set it to "a" I want list box 2 to automatically
select "3"

is there a way to do this with excel?

Thanks

Jamesmor