Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2004
    Location
    San Diego, California, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with VBA Approach for Report (2000 SP3)

    I would appreciate anyone's help with pointing me in the right direction for the following (generic) report that I would like to generate using VBA for Excel:

    Currently I have one report that I end up distributing to multiple groups, but use Autofilter to select just the data for each group prior to printing or PDFing and distributing (i.e., I manually use the drop down and select each group's name, and then click on the Print icon for each entry in the Autofilter list for the team field).

    I have the potential for creating additional reports that might need to be distributed in this manner, also, and would like to automate in VBA code. Is there a way to capture the Autofilter list for a field (i.e., unique entries), and then apply in a loop, printing each?

    Thank you in advance!

    Don
    Don Liebman
    San Diego, CA 92115

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with VBA Approach for Report (2000 SP3)

    See if the replies in the thread starting at <post#=320628>post 320628</post#> help you on your way.

  3. #3
    Star Lounger
    Join Date
    Nov 2004
    Location
    San Diego, California, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with VBA Approach for Report (2000 SP3)

    It looks like the Advanced Filter is what I am looking to use programmatically. I will give it a try and post any issues that might arrise.

    Thank you!
    Don Liebman
    San Diego, CA 92115

Posting Permissions

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