Hello Excel People!
Here’s the low down: I have a dashboard that you can select a person’s name in a drop down list and then the information will change to be the data of that person; pretty standard vlokup, hlookup and sometimes a mix of both to fill in the form, change graphs, etc.
The Problem: Then I got asked to print each person, when faced with a list of 20 selecting each name and hitting print takes awhile. Even if I use a macro to print sheet, it doesn’t actually save any more time than just using ctrl+p.
What I’m after: Is there a macro that can be used to select a person or persons to print that person sheet w/out the dashboard page being selected to that name? Sort of like this except that instead of tabs on a workbook, names on a list: http://spreadsheetpage.com/index.php/tip/displaying_a_menu_of_worksheets_to_print/
Example: I want to print out Sue, Bob and Cary. I hit the macro button a menu pops up and ask who do I want to print? I select the 3 names and then it prints those 3 people w/ their proper information.
What to consider: it’s not just simply a name change, all the information changes, so if I have a macro to select names to print, will the rest of the data print correctly?
I don’t know if this is possible. I appreciate any help/feedback/suggestions!!
Thanks for reading!
Here’s the low down: I have a dashboard that you can select a person’s name in a drop down list and then the information will change to be the data of that person; pretty standard vlokup, hlookup and sometimes a mix of both to fill in the form, change graphs, etc.
The Problem: Then I got asked to print each person, when faced with a list of 20 selecting each name and hitting print takes awhile. Even if I use a macro to print sheet, it doesn’t actually save any more time than just using ctrl+p.
What I’m after: Is there a macro that can be used to select a person or persons to print that person sheet w/out the dashboard page being selected to that name? Sort of like this except that instead of tabs on a workbook, names on a list: http://spreadsheetpage.com/index.php/tip/displaying_a_menu_of_worksheets_to_print/
Example: I want to print out Sue, Bob and Cary. I hit the macro button a menu pops up and ask who do I want to print? I select the 3 names and then it prints those 3 people w/ their proper information.
What to consider: it’s not just simply a name change, all the information changes, so if I have a macro to select names to print, will the rest of the data print correctly?
I don’t know if this is possible. I appreciate any help/feedback/suggestions!!
Thanks for reading!