I have a spreadsheet that is used for construction change orders. The way it has to be set up there is 4 columns description, qty,cost per, and total. The description qty and cost per are all being pulled from another sheet in the work book and to create seperate line items I just use the carriage return feature on the other sheet. I need to get my total column to take and multiply qty x cost and enter it into total, then take the next carriage returned value and go quanity x cost and then move onto next carriage returned item. at the bottom of the totals column i will need a formula that will add up all the totals as well.


Thanks in advance for any help!