Automatic data entry

[danielle]

I have an invoice set up. What I want to be able to do is when I enter an item code into the invoice, I want the Item description and Price to automatically appear in the cells on the right of the Item Code. The stock inventory is in a table on another worksheet (but within the same file).

 

[Aladin Akyurek]

On 2002-03-17 02:41, danielle wrote:
I have an invoice set up. What I want to be able to do is when I enter an item code into the invoice, I want the Item description and Price to automatically appear in the cells on the right of the Item Code. The stock inventory is in a table on another worksheet (but within the same file).

See my reply to your "Lookup Table" query.

Aladin