Anyone familiar with VB and macros
Options
pilotgirl2007
Posts: 368 Member
in Chit-Chat
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
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 391.4K Introduce Yourself
- 43.5K Getting Started
- 259.7K Health and Weight Loss
- 175.6K Food and Nutrition
- 47.3K Recipes
- 232.3K Fitness and Exercise
- 387 Sleep, Mindfulness and Overall Wellness
- 6.4K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.7K Motivation and Support
- 7.8K Challenges
- 1.3K Debate Club
- 96.2K Chit-Chat
- 2.5K Fun and Games
- 3.2K MyFitnessPal Information
- 22 News and Announcements
- 916 Feature Suggestions and Ideas
- 2.3K MyFitnessPal Tech Support Questions