HOME       >>       Software

Need Assistance With Excel How to build a quote sheet


I'm trying to build a quote sheet for our company. Basically, I have made a master parts list with prices, quantities, and descriptions on one worksheet and a quote sheet on another. What I want to get accomplished is this:


When I'm on the master sheet, I will modify the quantity numbers to incur a change from 0. What I want to happen on the quote sheet is that the quote sheet will automatically insert the data (description of item, quantity, and total price) from the row that has a positive quantity onto that worksheet. Finally, I want a total cost figure cell that will move down as more items are added to the quote sheet and that can get a sum of the total costs to display the final project cost.


Attached are screenshots to help explain what I'm trying to do:




Can someone help me out? Is this even possible? (I think it might be with dynamic ranges and whatnot, but Google-fu confused the crap out of me.)


Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.