Dear All,

I'm new to this forum and a very basic user of Excel... so I make my apologies now before I hack anyone off!

So down to the nitty-gritty and don't berate me too much if you think this is essentially impossible Imagine if you will, a quote for a new kitchen that includes company and client details at the top then subheadings for cabinets, worktop, accessories, appliances and finally a cost total. Under each of those subheadings the products will be listed with various column headings providing information as to the size, colour, brand and price.

The quote needs to be printed out onto minimal sheets of A4 (Save the Planet!) i.e. if there are only several items being quoted to a client, I would want to only print off one page... a large quote may need to expand up to 4 or 5 pages.

Issue: Each subheading can have anything between 1-100 products... how to auto adjust the categories/subheadings so they directly arrive after one another?

I have a software that creates a excel spreadsheet for me, however all the information that it creates is very basic and jumbled. The challenge is to extract that information and organize it so it creates a quote for a client.

I would be grateful for any light someone could shed on my situation and sorry in advance if this reads as gobbledygook.

Thanks in advance!