Automatic data entry

danielle · Mar 17th, 2002, 03:41 AM

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 · Mar 17th, 2002, 03:50 AM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 03:41 AM	#1
danielle New Member Join Date: Mar 2002 Location: Melbourne, Victoria Posts: 10	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).