Hello

ive got confused.

If i have two worksheets (w1 and w2) and on w1 i have a database of
products on ws1 i.e.
column A = product name
column B = cost per product
column C = weight

then in worksheet 2 i want to basically make an order form that will
calculate the total cost of an order. I want to write the name of the
product and the number ordred and have the rest of the table be
autofilled with the total cost and total weight for that product. I
dont want to copy and paste from one sheet to the other. Also i dont
want to show unecessary data from ws1 on ws2 i.e. cost per product and
weight are not needed, just the name and the total cost and the total
weight. this rules out my earlier idea of copying and pasting from one
ws to the other. There must be a more elegant way. Does anyone know of
one?


Any help appreciated.


--
thegeezer3
------------------------------------------------------------------------
thegeezer3's Profile: http://www.excelforum.com/member.php...o&userid=23623
View this thread: http://www.excelforum.com/showthread...hreadid=379434