Help needed for a simple spreadsheet

W

William

I use MS office 2000, using excell to calculate costings, i would lik
to simplyfy the way i use the spreadsheet to calculate costs but canno
find out how to set up a basic database which will automatically link t
the spreadsheet, any help would be gratefully appreciated.

Using a simple 5 column spreadsheet i would like to set it up a
follows.

Column A - enter simple item code (upto 10 digits) which wil
auto-complete after 3 digits and allow scrolling through similar code
until the correct item is found, column C would then automatically b
entered with the full item description and column D would automaticall
be entered with the price (both from a new database).
Column B - enter quantity
Column C - automatically be entered with full product descriptio
linked to item code in A
Column D - automatically be entered with item price, again linked to A
Column E - automatically calculate B x D

Ideally this would be set up on A4 with space at the top for jo
reference (which would be shown at the top of each page), column
would auotmatically be totalled and this would then be forwarded to th
next page

I am sure that this should be simple to do within excell but have bee
unable to find anything in the tutorial books to help me set it up
 
J

Jef Gorbach

William said:
I use MS office 2000, using excell to calculate costings, i would like
to simplyfy the way i use the spreadsheet to calculate costs but cannot
find out how to set up a basic database which will automatically link to
the spreadsheet, any help would be gratefully appreciated.

Using a simple 5 column spreadsheet i would like to set it up as
follows.

Column A - enter simple item code (upto 10 digits) which will
auto-complete after 3 digits and allow scrolling through similar codes
until the correct item is found, column C would then automatically be
entered with the full item description and column D would automatically
be entered with the price (both from a new database).
Column B - enter quantity
Column C - automatically be entered with full product description
linked to item code in A
Column D - automatically be entered with item price, again linked to A
Column E - automatically calculate B x D

Ideally this would be set up on A4 with space at the top for job
reference (which would be shown at the top of each page), column E
would auotmatically be totalled and this would then be forwarded to the
next page

I am sure that this should be simple to do within excell but have been
unable to find anything in the tutorial books to help me set it up.
Click to expand...

Consider using vlookup to match column(a) against your pricing sheet to
return values for columns(c,d)
 
Top