Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print Macro w/drop down list
Hey guys,
Searched a bunch of previous posts on this subject but am still not getting it correct. Here is my issue....btw excel 2010 I have an employee compensation report setup that is linked to a dropped down list of all employees (data validation). I have it setup with two print options, one button just prints an individual report as you see it on the page, pick any employee on the drop down and the report is populated and you hit print (I know just a lazy way of hitting the print button at the top but you know how executives can be) Now, he also wants a second button that prints a separate report for every employee in the drop down with just one click of the created print button. Any help would be greatly appreciated. The names of the sheets a Base Report to print: 'Report Print' Cell containing drop down: 'Report Print'!C4 Cell that the report fields vlookup to is 'Report Print'!G10 (not sure you need this. It just references the the drop down to make a clean report) Sheet containing drop down data: 'Employee list'!C1:C107 Thanks again for any insight and please let me know if you need anything else. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print Macro w/drop down list
On Wednesday, October 10, 2012 4:20:24 PM UTC-5, kicker127 wrote:
Hey guys, Searched a bunch of previous posts on this subject but am still not getting it correct. Here is my issue....btw excel 2010 I have an employee compensation report setup that is linked to a dropped down list of all employees (data validation). I have it setup with two print options, one button just prints an individual report as you see it on the page, pick any employee on the drop down and the report is populated and you hit print (I know just a lazy way of hitting the print button at the top but you know how executives can be) Now, he also wants a second button that prints a separate report for every employee in the drop down with just one click of the created print button. Any help would be greatly appreciated. The names of the sheets a Base Report to print: 'Report Print' Cell containing drop down: 'Report Print'!C4 Cell that the report fields vlookup to is 'Report Print'!G10 (not sure you need this. It just references the the drop down to make a clean report) Sheet containing drop down data: 'Employee list'!C1:C107 Thanks again for any insight and please let me know if you need anything else. -- kicker127 Send this msg and file to dguillett @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Items in Drop Down Filter List | Excel Discussion (Misc queries) | |||
Print Drop Down List | Excel Discussion (Misc queries) | |||
Macro button to print sheets populated from drop-down list | Excel Discussion (Misc queries) | |||
Print each drop-down list selection | Excel Discussion (Misc queries) | |||
How can I print a drop down list | Excel Worksheet Functions |