Creating automated lists in excel based on a dropdown

  • 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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!