Quote Workbook Help

[JonnyMFP]

Hi All,

I am new here so if I ask a question that has been posted before please feel free to point me in the right direction.

I have reached a point in my workbook where I am going to be needing some serious help, non of this google searching, saying that it has lead me here many a time and I appreciate everyone's input which is why I have joined.

Current hurdle is: (Trying to avoid VBA if possible)

I have a standard layout for my quote for a single site which has 3 columns and 6 rows before the total that will repeat for multiple sites. I have copied and pasted this information for multiple sites/sheets but this has become confusing for others for various reasons, so I would like to have it do necessary amendments automatically. Was thinking something along the lines of:

=if(cell=x, copy from source and insert, if(cell=y,copy from another source and insert, if(cell=y,copy from another source and insert,copy from another source and insert)))

Unless there is an easier way of doing this would this be possible?

Also is it possible to have the print areas adjust accordingly too?

 

[BarryL]

can you post sample data and sample output please.

 

[Roderick_E]

Your description is not detailed enough but looks like it would require VBA, especially the print part.

 

[JonnyMFP]

Sorry, was in a bit of a rush at the end of the day...

currently we have the quote set to print over 5/6 pages (quote sheet)
the last 4 pages pretty much stay the same and depending on the number of sites we are quoting on will determine if we have 1 or 2 pages before these.
lets call pages 1 & 2 (quote pages)
pages 3-6 (T's & C's pages)

so i thought to have this information in hidden cells below the print area ready to be copied and pasted/ inserted into the printable area.

All the data is collected from the (info sheet)
so if there are 1 or 2 sites then the quote will be 5 pages
if there are 3-6 sites then the quote will be 6 pages

the first thought i had was like mentioned above:
have the full quote setup in hidden cells and then
if info/multisite=2 then copy hidden cell
keep doing this for each individual line of information from the hidden cells to the last page
then the problem came with merged cells
then another with if info/multisite=3...

I get that I will have to probably get into VBA for the print part but, if i can, i would like to stay away from it for the above.

thanks in advance