needhelpnow
New Member
- Joined
- Oct 6, 2006
- Messages
- 5
Hi
I hope someone will be able to help me. I work with Excel 2003. I need to take info from our delivery schedule and put it into a format that will tell me a couple of different things. Due to confidentiality rules, I am not able to use the correct names of what I am dealing with. But I can say that we sell our products as kits that have several different items in each. Let's say we sell things like DVD players, among other things.
The first info I have to take from the main part of the sched is each DVD kit, the expected delivery date of these kits, and the quantity of each. I have done a pivot table to gather this info and it seems to work for me.
It is this part that I need some assistance with. I then have to break down each kit to it's sub products (boards, covers, manuals etc) and still maintain how many of each and the dates they will ship. Some of our products share some of the parts. What is the best way to gather this info? I have tried to use the Lookup functions to pull the info from the pivot table but I am having a hard time figuring out what to do next that doesn't involve just manual entries each time the schedule changes.
Any help would be appreciated.
Thanks,
K
I hope someone will be able to help me. I work with Excel 2003. I need to take info from our delivery schedule and put it into a format that will tell me a couple of different things. Due to confidentiality rules, I am not able to use the correct names of what I am dealing with. But I can say that we sell our products as kits that have several different items in each. Let's say we sell things like DVD players, among other things.
The first info I have to take from the main part of the sched is each DVD kit, the expected delivery date of these kits, and the quantity of each. I have done a pivot table to gather this info and it seems to work for me.
It is this part that I need some assistance with. I then have to break down each kit to it's sub products (boards, covers, manuals etc) and still maintain how many of each and the dates they will ship. Some of our products share some of the parts. What is the best way to gather this info? I have tried to use the Lookup functions to pull the info from the pivot table but I am having a hard time figuring out what to do next that doesn't involve just manual entries each time the schedule changes.
Any help would be appreciated.
Thanks,
K