hello everyone. i just joined this list. i've been using OpenOffice for quite some time now (on Linux). i'm not a power user by any stretch of the imagination. that being said, i have a question.
i'm trying to set up some spreadsheets for the salon i work for that will keep track of inventory. i'm trying to make this as easy for the other stylists as possible. here's what i have. a master sheet with all products listed and the amount we have in stock. another sheet that uses drop-down lists of the products and stylists. so when a stylist sells something they just choose the correct product that they sold. what i'd like to do is reference one sheet from the other. so if a stylist sells product A, selects product A from the drop-down on Sheet A it will subtract from the inventory of product A on Sheet B. is this possible when using the Data Validity tool (how i created the drop-down lists)? i know i can do this if the numbers are simply entered - i'm just trying to make this as simple for the others as possible. thank you so much. stylist Hair Strobel you need my hair-fu www.monkeypantz.net --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]