Johnny Rosenberg wrote:
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]



You can refer to different sheets by preceding the usual cell reference with a sheet name so, for example, "Sheet1.A1" refers to cell A1 in the sheet named "Sheet1". When you start a new spread sheet the sheets are named "Sheet1", "Sheet2" and "Sheet3" unless you've done something to change this. You can rename a sheet by *right* clicking its tab and entering a new name. If you name a sheet "Products" then you'd refer to "Products.A1".

Sheets are named automatically and their names change if you rename them. You can also name rows and/or columns but you have to tell Calc you are doing it. Read about Names in the Help for more details. Using Names is very useful as (a) you don't have to remember row/column numbers, (b) Calc will automatically adjust things if you insert/delete rows columns providing the names stay the same and (c) you can more easily teach non- technical users to use names than to use row/column numbers.

Hope this helps.

--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org

Reply via email to