Validation Cell Andrew C 22.11.2005 14:36:02 On my Worksheet Cell A1 is a validate cell. Its a drop down box listing all bowlers who participated in the bowling tournament. The worksheet lists all personal scores and averages and a graph of there scores. At the end of the tournament i wish to be able to print all bowlers sheets off. I am looking for a quick way of doing it. Rather than having to select each bowler and clicking print i wish to click a button and print them all out. Hope someone can help Cheers Andrew C

Re: Validation Cell Gord Dibben <gorddibbATshawDOTca> 22.11.2005 18:46:06 Andrew Does each bowler have their own worksheet with graph? If so, just select first sheet then SHIFT plus click on last sheet to select all sheets(or right-click on a sheet tab and "select all sheets") File>Print You can record a macro while doing this and assign it to a button. If a different layout, give more details please. Gord Dibben Excel MVP On Tue, 22 Nov 2005 06:36:02 -0800, "Andrew C" <AndrewC[ at ]discussions.microsoft.com> wrote: [Quoted Text] >On my Worksheet Cell A1 is a validate cell. Its a drop down box listing all >bowlers who participated in the bowling tournament. > >The worksheet lists all personal scores and averages and a graph of there >scores. At the end of the tournament i wish to be able to print all bowlers >sheets off. > >I am looking for a quick way of doing it. Rather than having to select each >bowler and clicking print i wish to click a button and print them all out. > >Hope someone can help > >Cheers > >Andrew C

Re: Validation Cell Andrew C 24.11.2005 02:31:03 No. There is only one worksheet. I just select a different name in the drop down and it calls up there information. Through a number of Vlookup functions. "Gord Dibben" wrote: [Quoted Text] > Andrew > > Does each bowler have their own worksheet with graph? > > If so, just select first sheet then SHIFT plus click on last sheet to select > all sheets(or right-click on a sheet tab and "select all sheets") > > File>Print > > You can record a macro while doing this and assign it to a button. > > If a different layout, give more details please. > > > Gord Dibben Excel MVP > > On Tue, 22 Nov 2005 06:36:02 -0800, "Andrew C" > <AndrewC[ at ]discussions.microsoft.com> wrote: > > >On my Worksheet Cell A1 is a validate cell. Its a drop down box listing all > >bowlers who participated in the bowling tournament. > > > >The worksheet lists all personal scores and averages and a graph of there > >scores. At the end of the tournament i wish to be able to print all bowlers > >sheets off. > > > >I am looking for a quick way of doing it. Rather than having to select each > >bowler and clicking print i wish to click a button and print them all out. > > > >Hope someone can help > > > >Cheers > > > >Andrew C > >

Re: Validation Cell Gord Dibben <gorddibbATshawDOTca> 24.11.2005 18:26:54 One method......... Autofilter each bowler then create a custom view for each. Add these views to the Report Manager(Tools>Add-ins) under a name. The views will expand as the bowlers' stats expand. You can print that named report with the included views. Note: the graph will have to be based upon a Dynamic Range to update as stats increase. For Dynamic Range Charting see Tushar Mehta's site. http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html Gord Dibben Excel MVP On Wed, 23 Nov 2005 18:31:03 -0800, "Andrew C" <AndrewC[ at ]discussions.microsoft.com> wrote: [Quoted Text] >No. There is only one worksheet. I just select a different name in the drop >down and it calls up there information. Through a number of Vlookup >functions. > >"Gord Dibben" wrote: > >> Andrew >> >> Does each bowler have their own worksheet with graph? >> >> If so, just select first sheet then SHIFT plus click on last sheet to select >> all sheets(or right-click on a sheet tab and "select all sheets") >> >> File>Print >> >> You can record a macro while doing this and assign it to a button. >> >> If a different layout, give more details please. >> >> >> Gord Dibben Excel MVP >> >> On Tue, 22 Nov 2005 06:36:02 -0800, "Andrew C" >> <AndrewC[ at ]discussions.microsoft.com> wrote: >> >> >On my Worksheet Cell A1 is a validate cell. Its a drop down box listing all >> >bowlers who participated in the bowling tournament. >> > >> >The worksheet lists all personal scores and averages and a graph of there >> >scores. At the end of the tournament i wish to be able to print all bowlers >> >sheets off. >> > >> >I am looking for a quick way of doing it. Rather than having to select each >> >bowler and clicking print i wish to click a button and print them all out. >> > >> >Hope someone can help >> > >> >Cheers >> > >> >Andrew C >> >>