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.
Bookmarks