Home > IT Answers > Microsoft Windows > How do I run Excel Reports?
Lysprice
5 pts.
 How do I run Excel Reports?
Excel 2007, Microsoft Access, Reports
Is is possible to run reports similar to how you run reports in Access in Excel 2007?? If so, How?

Software/Hardware used:
ASKED: July 10, 2008  4:04 PM
UPDATED: November 8, 2010  2:29 PM
RELATED QUESTIONS
Answer Wiki:
Excel doesn't run reports like Access. I create my own reports on a separate worksheet by linking between the two sheets. The information needed, automatically transfers to the report. Good luck.
Last Wiki Answer Submitted:  July 19, 2008  12:56 pm  by  OBI Girl   85 pts.
All Answer Wiki Contributors:  OBI Girl   85 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Can you clarify if the data is lying in MS Access? if yes, there is an option to export the data from MS Access to MS Excel using macro.

Regards,
Sarfaraz Ahmed
MS Excel help

Findsarfaraz
 1,395 pts.
 

I am trying to figure out if I can run this type of report using Excel?
For example, I have a worksheet with a list of names, but I want to pull or find out all the names on that list who has a birthday in June. Am I able to run a report some how to show all the people in that list who’s DOB is in a specific month?

Drizzleweed
 10 pts.
 

Easiest way to do this is to add a formula i.e. =month(dob), copy the formula down the entire list and then use the Filter functionality.

Darryn
 765 pts.