Need help with Excel worksheet
In essence, I think you've got it
"Mike H." wrote:
If I understand your scenario correctly, I think you need a couple things
first.
1. You need a Bill of Material which contains all the Items and their
components, preferably like this:
ColA ColB
Item1 Component1
Item1 Component2
Item1 Component3
Item2 Component1
Item2 Component2
Item3 Component3
Item4 Component4
etc.
2. Then you need a sheet where you enter the Items that are being loaded on
the truck.
3. Then I would suggest adding a menu item or a button on the sheet that
has code behind it that creates the packing slip for you. If one enters
Item1 on the sheet discussed in #2 above, then after clicking a button you'd
have a sheet like this:
Item Component Package #
Item1 Componen1 _______
Item1 Component2 _______
Item1 Component3 _______
Is that what you want this to do?
|