troubleshooting Question

Filtering - Visible Rows

Avatar of Cook09
Cook09Flag for United States of America asked on
Microsoft OfficeMicrosoft ExcelVBA
21 Comments2 Solutions105 ViewsLast Modified:
Attached is a Workbook where Column B (Table1 Worksheet) is filtered and the results for Col A can be recorded in P1, Q1, R1, etc.  Currently, it's a bit of a work around to display the values of Col A, C, and F (from a filtered Col B) to be displayed on the Main worksheet.

Is there a better way to display the filtered rows in the Main worksheet?

Cook09
Filtering.xlsx
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 2 Answers and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros