Hyperlink Printing

[Guest]

I have a list on one sheet of 100 names. On a second sheet I have the
addresses of these people in a envelope sized space. Instead of going to
print and printing the specific pages can I not when I click on their name
get it to print that page automatically? Thanks, this would save me so much
time.

 

[Otto Moehrbach]

Are you saying that you have 100 block ranges on another sheet with the name
and addresses of these 100 people, and when you want to print one envelope
for say, John Smith, you have to print that one range that contains his name
and address?
Certainly, that can be automated like you ask. But I don't think that what
you appear to have said you have is really what you have. Please post back
and clarify what you have in this "other" sheet. Provide some addresses for
a sample of a few addresses. HTH Otto

 

[Guest]

Hey Otto,

On Sheet 1 is a list of all names of my contacts. On Sheet 2, there is over
300 page break sections with a address on each page, and its hyperlinked from
sheet1 to sheet 2.

Example:

Sheet 1: List of names
B
2 Brad Myatt <--Hyperlinked to Sheet2!d105
3 John Smith
4 Julie Roberts
-----------------------------------------------

Sheet 2:
D
105 Brad Myatt
14th Ave New York City
-----------------------------------------------

Then I have to press control print and print that specific page. I want it
so that when I click, it doesnt go to sheet 2 but just print that envelope
for me.

Hope this helps you so that you can help me.

 

[Otto Moehrbach]

I don't know your business so there might be a very good reason why you
choose to do this the way you did. What is usually done when you have a
list of people and addresses and you want to print an envelope for one of
them, is that you have a single range previously selected (your envelope
range) and when you select a name in some list, that person's name and
address and whatever else you want is automatically placed in that envelope
range, and the range is printed. That way, you don't have 100 separate
print ranges to choose from when you want to print. You always print the
same range.
Having said all that, let me answer your question. Yes, you can use a
Worksheet_SelectionChange event macro to do what you want. With such a
macro, you would simply click on a name. The macro would then determine the
range to print and print it.
Now let me recommend another way. As I said above, you have one sheet
in which you have the names and address of those 100 people. In some cell
of your choosing, you have Data Validation set up with the names of the 100
people. You would select (click) on the name you want. In another sheet,
you would have the one range to print. You would have VLookup formulas in
the cells for the name, street, city, etc. When you click on the name,
those cells would automatically fill with the proper name and address and
all. You would then print that range.
Another way would be to have the same Data Validation cell in which you
select a name. You would have the same VLookup formulas in the same places.
But you would have a macro that runs automatically when you select the name
and that macro would do the printing part. So all you would do is click on
the name.
Please post back and tell me what you want to do and I'll work it up for
you. HTH Otto

 

[Guest]

I am confused about the data validation adn your way does sound easier.
Could you possibly put a template together for me and email it to me?

(e-mail address removed)

It sounds like you know what I want to do. I could send you my file as well
and see if it is fiaxable.

I appreciate it.