Thread
:
Printing selected Data
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Printing selected Data
this idea should get you started. You will be using autofilterprinting the
pagefiltering the next age
Sub printages()
For i = 22 To 25
Range("A1:D20").AutoFilter Field:=1, _
Criteria1:=i, Operator:=xlAnd
ActiveSheet.PrintPreview
Next i
Range("A1:D20").AutoFilter
End Sub
--
Don Guillett
SalesAid Software
"laurie g" wrote in message
...
My worksheet contains data such as Name, Address, Tel, Age etc.
I would like to run a macro that would sort and print all the relevant
rows
by Col I being Age
I would then have a printed page of all the names address etc who are aged
25yrs and a new page for the next age group and so on. My Data is
constantly
being edited and new names Addresses etc added. My data starts at Row 6.
So
at any time I can run a macro that will sort and print pages based on
their
Age. I am stumped as to how I can achieve this. Please advise Detail on
how I
do this as I am limited in my
VB
knowledge.
Many thanks
Laurie g
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett