I have been straining myself over making this spreadsheet for a friend, and i can't for the life of me figure it out! And he wants it by thursday The problem is i can't seem to make a validation box for it that say the words Transfer and Embroidery to change the values of the worksheet!
My friend would like to generate a detailed model to calculate how much to charge each member. All values and Costs should be calculated automatically from the costs and the Orders worksheets. The type of artwork (Transfer or Embroidery) should be selectable from a validated list containing the two options. The artwork choice should apply to all jackets ordered. Once the grand total has been calculated, the spreadsheet should be used to determine the cost.
to each member for each type of jacket. The cost to members for each jacket type should include
bagging, shipping machine set-up and VAT.
My friend James wants this done by thursday and i haven't the life of me on how to do it ! i just wrote out the letter she gave me :,(!
Please help I will be eternally greatful!
the files are here :D
Table of info.xlsxQuotation.xlsx
Bookmarks