Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
printing a report
I have a course development spreadsheet with several courses. I would like to
print a report that lists the courses that are new to development (in the sheet "Development" in Column I, which means a course developer was hired to develop the course for spring 2010) but is also pinpointed for being offered through registration (the "Courses" sheet Column N). I want the report to list the courses with "SP2010" in Column I on the "Development" sheet and "YES" in Column N of the "Courses" sheet. There is over 350 courses in the spreadsheet, and the report would list maybe 10 to 15. I have never printed "reports" in Excel 2007, so I am no sure if it's even possible to "query" a spreadsheet (even across sheets in a single spreadsheet)...and how to create the report. Furthermore, I would love to create the report as a template per se, so all I would have to do each quarter is change the columns to check. Finally, is there a way to take the results of the "query" and copy and paste them into a new sheet, which would make it easier to update my Development sheet, rather than copying/pasting the courses from my main Courses sheet. Thank you so much!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing multiple report based on a list | Excel Discussion (Misc queries) | |||
Printing multiple graphs on a report | Charts and Charting in Excel | |||
Printing a report | Excel Discussion (Misc queries) | |||
Printing report that is portrait and landscape | Excel Discussion (Misc queries) | |||
How do I auto-save multipage report printing to Acrobat Distiller | Excel Discussion (Misc queries) |