Results 1 to 6 of 6

Print Worksheet(s) from selection on Drop Down

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2007
    Posts
    90

    Print Worksheet(s) from selection on Drop Down

    I have a drop down in sheetQUOTE that selects rows from sheetSUMMARY- ( each row in sheetSUMMARY is the grand totals from a separate specific worksheet.)

    Thanks to NBVC and Dean England for their help with the drop down.

    MY ISSUE:
    After sheetQUOTE is completed I would like a command button to push and
    print

    a) sheetQUOTE
    b) each worksheet that is represented by a selection from the drop down.

    I added a column in sheetSUMMARY and entered the worsksheet name for each row. I can get it selected in the drop down, but no success after that.

    AND it would be great to have another command button to do same basic thing, except to save as one pdf (a) sheetQUOTE and each worksheet represented by a selection in the dropdown)

    I have attached a scaled down XLs, just deleted all the detail on each worksheet- but grand totals still link to sheetSUMMARY

    Thanks,
    Attached Files Attached Files

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