I have a pricing catalog from that has about 70 items/products/services
If I create a quote for a customer based on those 70 items (and select say 5 or 10 items), I want the resulting pricing table to have all the items in a specific order.
I have ranked the "order" of preference in the catalog.
The attached workbook has:
1) Catalog with the rankings/preference
2) Sample Raw Pricing Table
3) Goal: how I want things to appear (the order or items).
Note that it would also be good to have the Total cost...so somehow, the total cost would appear at the next blank row...
Thanks
Villagechief
Bookmarks