Conditional print formatting.

[Jo-Jo]

Hi all,

With an enormous amount of help from the forum, I have arrived at a position where I need to consider the formatting of the print and web page output of my pool league project. Can I ask for advice again please.

Basically, my worksheet is a variable length list that is generated from lookups and looks like the attached screen capture.

My first goal is to create two different hard copy print outs, such as:-

1.a start of season fixture list that simply shows the date of the matches (Col B) with the corresponding teams (Cols C & F). The only thing I can foresee adding is headers to each page and a fixed descriptive text on the first page.

2.a weekly results list that shows a selectable date from Col B in a title, with corresponding teams and scores for that week plus the overall score table and another descriptive text in the page body.

When I say 'descriptive text', all that means is league related info such as... 'if you can't turn up phone... blah, blah' (yet to be penned).

Could anyone tell me how to go about this please. Is the correct way to create new worksheets. Is it possible (considering they are variable length/lookup already) to group by date in the first list (i.e. perhaps a line-break between or something between date ranges to enhance readability), can I also prevent date ranges from breaking over two printed pages. Lastly (and sorry for a lot of my thoughts coming out!), as the first list (start of season fixture) could be long, would there be a way to economise on paper and have two groups of lists (side-by side) if that makes sense.

Sorry for yet another long post, mainly due to my not knowing how to describe things in brevity. Also sorry if there are multiple questions, but I am certain some must be related to each other and relevant/inter-connected as a whole (at least as an overview). I'm happy to break this down and learn one-at-a time, if best.

Thanks, as always, for any input/advice.
J.

[Huron]

You could use Custom Views. Set your sheet up to show what you want to print for the first option then View - Custom Views - Add (insert a name for this view). Then adjust your sheet to hide / show what you want for the second option and do the same for this. You can then switch between these two views for printing.

[Jo-Jo]

Hello Huron,

By views, is the same as creating additional worksheets?. If so, how do I go about conditionally formatting the print-out to accommodate the variable length lists etc.

Thanks,
J.

[Huron]

No, it's just the one worksheet. You hide any rows or columns that you don't want to see in each view. The descriptive text that you want at the beginning of the first print would be visible in the first view and hidden in the second.

[Jo-Jo]

Thanks Huron,

I've been playing with custom views, but can't seem to get the amount of functionality to , neatly, accomplish the criteria in the original description.

I'll bash away trying unless there are any alternatives.

Thanks again,
J.

[darkyam]

I used to run a spreadsheet that would have various lines show based on options a customer selected. To fix my printing problem, I had formulas off to the side (setting the printable area of the spreadsheet to not include the column), then I had formulas for each row that evaluated to "Yes" or "No". For example, in yours, I'd put a dropdown in R1 that had the options of View 1 and View 2, then in Q18, something like

Please Login or Register  to view this content.

This would seem to fit your criteria, as I understand them. You should be able to drag that down as far as you need and simply do whatever formulas are necessary above that. Of course, if you will always print a row, just type "Yes" Q for that row. Then, once you have your formulas, put a filter on Q and select "Yes". You'll have to reselect it once you change R1 and will probably have to select all to update your table, but if you are careful with your formulas, it should be dynamic as your sheet changes.

[Jo-Jo]

Hi darkyam,

I've got to admit, I'm still finding trouble in formatting like this with a view... its gotta be me not seeing/understanding somewhere. I'm going to do some more searching/reading and see if I can get my brain round it.

I've added a couple of more screen caps of what I'm trying to achieve in each list, in case I'm trying to do something impossible. Could you tell me if they seem achievable?.

Thanks,
J.

[darkyam]

My suggestion would have been an easy way to hide rows. What you're looking for is something that will change the layout of what you have as well. It would probably be better to have two linked sheets, the first with the matches as of the beginning of the year (with score columns hidden when you want to print), arranged in two columns, and the second with the overall table and the weekly results above it, which could use an Index/Match formula to derive the results from the first sheet.

[Jo-Jo]

Thanks darkyam,

Right, back to the new sheet(s) option and some studying to see if I can adapt any the the formulas I've already learnt... I 'think' they are already amongst those that Cheeky Charlie, yourself and others taught me.

Thanks again,
J.