I understand what you are asking...
I have only done such things using macros. You might be able to setup a
data source to another Calc document and fill the drop down that way,
but it would not be portable to Excel.
Michael J. Reude wrote:
Ok... by reference I talking about the inventory sheet needs to have
drop down fields that will autofill the rest of the fields in either
by item number or by description when you select your item.
Michael
Andrew Douglas Pitonyak wrote:
Michael J. Reude wrote:
Hi, I am helping my Mom run a small business selling soaps,
candles, and other homemade items. What I'm wanting to do is create
a spreadsheet that has a database of items: item number,
description, On Hand Qty, Cost, MSRP, and Sale price. That's the
easy part.
Next I want to create a separate file that would become the
invoice template. This file would need to have several entry rows
and be able to reference the database spreadsheet for a list of
items, either by item number or by description. Does anyone know if
this is possible or where I could find information on how to do this
(What documentation to download, etc.).
What do you mean by "reference" the inventory?
I recently worked on a project that used a sheet for customers and a
sheet for inventory. Well, the inventory did not really contain the
current inventory, it just contained a list of stuff, the part
number, description, and price... The user would run specific macros
to add the customer information to the invoice and another macro to
add inventory items to the invoice. The macro would cause pages to be
added to the invoice as required.
Perhaps I should be more specific. If I wanted to add an item to the
invoice, I would place the cursor in the row containing the item that
I wanted. Then I would run the macro. Ultimately, this would not help
you on a PDA because it uses a macro to do the dirty work.
And no, It can't be done on the Base program because I need to
use this on a PDA that does not have the Open Office Suite on it.
Unless there is a Palm OS version of Open Office I'm not aware of.
Also, this has to be saved as an Excel file with no problems.
Thank You,
Michael
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
