katkth7533
New member
- Joined
- Jul 29, 2014
- Messages
- 17
- Reaction score
- 0
- Points
- 0
Hi everyone! Here is what I am looking to do: I have an Excel Workbook with 10 Worksheets in it named "P1", "P2", thru "P10". Each worksheet has the same format for collecting information for 10 different projects. I need to write VBA code to attach to a button so that I can first filter information on all 10 worksheets then printout this filtered information then take the filter off so all rows of information are available. There are 2 pieces of information that I need to filter in rows P5625: "ProjName" and "Development". For Filtering, I thought the following code could work:
, continuing this for each worksheet but then I get stuck as to how to print out the information and then "unfilter it". Ideally, I would like this information to print out without pagebreaks. In essence, 1 report. I haven't started this because I'd like a clear way to start. Any suggestions? Thanks!
Code:
Sheets("P1").Range("P5:P625").Autofilter Field:=1,Criteria1:="Development", criteria2:="ProjName"