 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / November 2005Validation Cell
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 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 my Worksheet Cell A1 is a validate cell. Its a drop down box listing all >bowlers who participated in the bowling tournament. [quoted text clipped - 11 lines] > >Andrew C 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. > Andrew > [quoted text clipped - 26 lines] > > > >Andrew C 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 >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 [quoted text clipped - 30 lines] >> > >> >Andrew C |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.