Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How hard would it be to...

  1. #1
    Board Regular CDICKENS's Avatar
    Join Date
    Mar 2002
    Location
    Tarheel State
    Posts
    498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a few workbooks that I use pivot tables to "compile" different reports using essentially the same sales data. Would it be somewhat easy to create a Form page with a drop down box listing the reports that can be generated, and a box to specify a range of dates to be included in the report.

    I guess I am actually asking if you can record a macro that "compiles" a report, based on a user defined date range. I have not used any macros in a while so before I attempt this I was interested to know if it can even be done.

    Thanks for any input,

    Chuck


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    from your question i strongley recomend automation as you ask and keep piviots simple they are stroppy little things best days and make you like easy

    stay as you are..

    sorry to be negative..
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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