Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Brainstorm: Reports

    Okay guys, brainstorm, debate, do what you will! ) [img]/w3timages/icons/thinks.gif[/img]

    I have a userform built into a worksheet. I would like to print reports based on the data from cells A,1 to cells AD,68. What is the most effective way to go about this?

    Thanks! [img]/w3timages/icons/thinks.gif[/img]
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Brainstorm: Reports

    Highlight the cells; then File, PrintArea, Set PrintArea
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Brainstorm: Reports

    I don't suppose there's a way to do "Access Style" reporting in Excel? Is there? )

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Brainstorm: Reports

    What do you meean by Access-style reporting?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Brainstorm: Reports

    You could import the data into Access or link to it and then do an access report.

    I tend to do things the other way round. That is I use the database as a database and then use Excel to do the reporting!
    David Grugeon
    Brisbane Australia

  6. #6
    Lounger
    Join Date
    Jan 2001
    Location
    Tallinn, Harjumaa, Estonia
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Brainstorm: Reports

    Hi!

    There is very effective Excel-way reporting. That includes Auto Filter, Subtotals, Grouping and Pivot Table. All the features need to have correctly set (so-called) Excel-list.

    Anu

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Brainstorm: Reports

    Access Style Reporting:
    In access, you are able to set 'fields' in your report design, which return results from a table or query. I'm curious as to whether or not there are features in excel which could have the same effect.

    This question spawns as I am attempting to make Excel look/work like Access. Our MIS dept. doesn't see it fit to supply each computer with Excel, therefore, i'm jumping through hoops to provide what I want to the end users.

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •