It is probably possible with a macro, but I am not 100% sure what you have done. Can you send the file to me or upload it somewhere and give us a link? Or could you do a fake using the same technique as the original?
Johnny Rosenberg 2007/8/15, jack wallen <[EMAIL PROTECTED]>: > > 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] > >