Results 1 to 10 of 10

Print sheets based on filtered results from multiple workbooks

Threaded View

  1. #1
    Registered User
    Join Date
    09-18-2008
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    66

    Print sheets based on filtered results from multiple workbooks

    Hi everyone, I'm trying to add another feature to a macro that I have adapted. The base code comes from Ron De Bruin (with the necessary Mods) and works very well for what it is intended to do.
    I would like to add a new feature to the code and have little success, in working it out, from numerous searches on the net.

    Basically, the code searches workbooks in a folder and returns filtered results for every row that meets the criteria, Copying all those filtered results to a new workbook.

    Each of these results has an associated "Detailed List" which contains more detailed information of the actual job.
    As the filter pulls a result from a workbook, i would like the associated "Detailed List" to be printed.

    The workbooks are all structured the same way:
    Sheets that are being filtered are called "CHECKLIST". The checklist contains 17 rows of info (ie. different jobs).
    The rest of the work book has sheets numbered 1-17 with more detailed info on each of these jobs.

    At the moment I have a Print Button in each row, of the "CHECKLIST" that will print the desired sheet (1-17).

    Is there a way, thru VBA, to link the main sheet cells with the respective detail sheet and then print the detail sheet when the "Filter Macro" produces/finds a result?
    Maybe the code could activate the associated Print Sheet Macro when a positive result is found by the filter?????

    I've attached a sample workbook with the macro code/s in it:


    Regards,
    Martin
    Attached Files Attached Files
    Last edited by Lungfish; 08-10-2011 at 04:01 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1