Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic printing by filter?
Hi guys,
I have a spreadsheet with a column named "Group" and was wondering if I could print the spreadsheet by group automatically rather than selecting each group individually with the filter and pressing print. Is this possible? Thanks, Alan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic printing by filter?
On Monday, March 18, 2013 6:15:38 AM UTC-5, AlanJCarr wrote:
Hi guys, I have a spreadsheet with a column named "Group" and was wondering if I could print the spreadsheet by group automatically rather than selecting each group individually with the filter and pressing print. Is this possible? Thanks, Alan -- AlanJCarr Alan, Yes you can - however, you will need a vba script to do it. Put the group names into an array and loop thru the array. at each loop you would set the filter IAW the select group and and call print hope this helps Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic filter ? | New Users to Excel | |||
Extract filter items from Drop-Down Automatic Filter | Excel Programming | |||
automatic printing | Excel Worksheet Functions | |||
automatic printing | New Users to Excel | |||
automatic printing | Excel Worksheet Functions |