Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Printing
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Printing
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 "Confused at Work" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Printing
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" wrote: 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 "Confused at Work" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Printing
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 "Confused at Work" wrote in message ... 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" wrote: 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 "Confused at Work" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Printing
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? 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. "Confused at Work" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"paste special" a hyperlink to another worksheet... | Excel Worksheet Functions | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions |