Hi there forumers, a slightly curly lookup question.
I want the used to be able to enter a value (in this case an assembly number). Once they hit enter i want to check another sheet for the number and return an array (the part numbers contained in the assembly and the quantity used in the assembly).
An Example:
the user types: AS30
In another sheet is a list of the parts contained in AS30. Part numbers start with an S:
s1 s2 s3 s4 PART NUMBERS
1 3 2 1 QUANTITY
Once the AS number has been located, I want the array transferred to another sheet so that calculations can be done. Am I asking too much? Is it time i learnt how to use VB properly?
Thanks alot for any advice.
Evan
Bookmarks