Select Multiple Ranges with Certain Data to Print

R

RyanH

I am a beginner with VBA and I am not sure how to begin with this. I have a
worksheet of product orders. Each order has its own row with 20 Columns. I
sort the worksheet by the sales peoples initials which is located in Col. B.
I built a UserForm with a checkbox by each sales persons name. I want the
user to be able to select the sales persons checkbox and then the macro will
select the ranges and then print them. For example: If Sales Person AA & CC
Checkboxs were checked then the Macro would Select Ranges: all Rows w/
AA:Columns A thru K & all Rows with CC:Columns A thru K

Col.A B C D E F G H.... K
Sales Sales
# Person

AA
AA
BB
BB
CC
CC

I think then I could just write the macro to print Selection after the
ranges where selected.
 
M

Mike H

A lot simpler and it may meet your needs is to filter the data to show what
you require and then simply print. Only visible rows will be printed.

Mike
 
R

RyanH

I think this does make since after reading a little bit about the Advanced
Filter. But I do not know how to use it proporly. Can you show me some
code? Thanks for your help so far.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top