Move equations from line to line automatically
I need to create a excel template to import information into a MRP system.
Specificelly for cabinet doors Pricing is done by the square foot so I need
to keep trac of the total price. The problem is the order can be as little as
one door or it can be thousands of doors. I would like to see
HEIGHT WIDTH STYLE QUANTITY SQ FT PRICE
TOTAL
So that the total would always appear below the last door entered. I am
using Office 2003.Is this possible?
|