I am using excel for creating estimates. Basically, I have 3 tabs:
- estimate I have a list of skus on each row with vlookups for description, qty, price that i just copy over each time (that uses vlookup to search for product descriptions and prices based on SKU)
- price sheet (full list of skus)
- groupings (groups of skus and qtys that manually get copied and pasted into the estimate sheet)
Is there a way that rather then manually inserting the lines each time and copy/pasting the skus and qtys from my grouping sheet, i may just be able to have a dropdown that references the group of skus i want on the estimate sheet?