Print Template

[stocky789]

Hey guys!

I'm new here and a massive noob with excel but basically what I am doing is building a pricing tool. I have built the pricing section of it however I want a template where the data entered is basically replicated to a degree into another sheet. I don't want every row though since it shows markups etc and the printing section is essentially for customers to see.

Basically from the pricing section I want the item, the QTY and the price transferred over into the print template to match those exact columns. So anytime the quantity column is anything other than 1, I need that item to populate into the necessary columns on the print template. (I hope I am making sense)

I would also like headers, so for example if anything under the "Data" tab is entered (This is following the rule that anything above 0 populates) it creates a blank row with a category stating "these are the data products in this quote". Then if there is anything out of the handset section it will have a blank row under item saying "these are the handsets in this quote"

I have attached three photos, one of the main pricing tool, the second is what the layout looks like without formatting and the third is what i want it to look like (obviously with automation involved)

Basically I know how to do all this if i were to go in and manually add everything to the print section but that is very trivial and tedious each time someone needs to quote and the idea is the sales guys are only going to get a preview of the quote and what it looks like, the actual print sheet itself won't be editable.

Here is the image

It won't allow me to post a link of it at all so not sure how I am going to show you guys

[torachan]

Missed the big yellow banner at the head of the page.
Images are hard to manipulate, workbook would get you an answer more suited to your requirements.
torachan.

[stocky789]

Hey,

I have attached the workbook with a photo in the print sheet of what I am looking at doing hopefully it makes sense

[torachan]

I fully understand what you want.
There is no easy way to say this.
To be able to manipulate data in a sensible manner the stock sheet would have to be totally revamped.
I will wait to see if one of my brave colleagues steps forward first before commenting much more.
Two golden rules - do not use merged cells - use a single table format containing all products.
torachan