Anyone familiar with VB and macros
pilotgirl2007
Posts: 368 Member
I need some help so I thought I would reach out to my fellow MFP-ers
Long story short I am trying to write a macro to filter the column area of a pivot table but the item I want to show is not always available in every workbook that I am running the macro on.
I would like to figure out how to tell my macro to check the pivot fields for "text" and if it exists then show only this and if it does not exist add a worksheet.
Anyone out there able to help out?? Thanks a bunch!
Long story short I am trying to write a macro to filter the column area of a pivot table but the item I want to show is not always available in every workbook that I am running the macro on.
I would like to figure out how to tell my macro to check the pivot fields for "text" and if it exists then show only this and if it does not exist add a worksheet.
Anyone out there able to help out?? Thanks a bunch!
0
Replies
-
I am a master of excel. Friend me and I will help you.0
This discussion has been closed.
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 393.6K Introduce Yourself
- 43.8K Getting Started
- 260.3K Health and Weight Loss
- 176K Food and Nutrition
- 47.5K Recipes
- 232.6K Fitness and Exercise
- 431 Sleep, Mindfulness and Overall Wellness
- 6.5K Goal: Maintaining Weight
- 8.6K Goal: Gaining Weight and Body Building
- 153K Motivation and Support
- 8K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.8K MyFitnessPal Information
- 24 News and Announcements
- 1.1K Feature Suggestions and Ideas
- 2.6K MyFitnessPal Tech Support Questions