How do I run Excel Reports?

5 pts.
Tags:
Excel 2007
Microsoft Access
Microsoft Access reports
Microsoft Excel
Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?
ASKED: July 10, 2008  4:04 PM
UPDATED: August 16, 2013  6:35 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Lysprice
    [...] Original post by unknown [...]
    0 pointsBadges:
    report
  • Findsarfaraz
    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
    1,395 pointsBadges:
    report
  • Drizzleweed
    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?
    10 pointsBadges:
    report
  • Darryn
    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.
    765 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following