Hey VBA fish, I have a loop (for each pivot table in the worlsheet) but I need to run the loop in a certain order as it sets a filter. Those filter values are taken from a list. Right now (cont)

like
Posting as :
works at
You are currently posting as works at

the first filter is set in a pivot in the middle of the sheet, the the last one then one at the beginning and so on. I need to tell the macro on which order to set the filters (from left to right). Is there a way?
Thanks in advance!

Related Posts

When did those of you who got a divorce know it was finally time?

like

Hello fishes.. any openings in JP Morgan Hyderabad in the analytics space?

like

Closing in 11 days. Excited to get the house but I hate moving.

like

What's the play on updating LinkedIn when accepting a new job? Keep everything as is until the trial period is over or update right away?

like

Feeling discouraged about my career path. A year into this job and I feel like I’ve taken a step down in terms of growth and responsibility from my last job. I used to be in a position where (cont...)

like

SFF: Sarasota Florida Fishies. I’m an AD / Brand / Designer. Does anyone know anyone in Sarasota area with radius of 20 miles? Other than my family, I don’t know anyone. Anyone? ;)

Hi everyone! Heading to Barbados in March for the cricket. Any good recommendations for things to see, do, eat etc?

like

Any recommendations for bars or restaurants open in DTLA area? Thanks!

like

Is anyone open to giving a referral at Deloitte? I have 3 jobs I'm interested in.

like

Thread: France v Australia

like

Anyone worked at multiple FAANG companies? I’m trying to choose between 2 and can’t decide.

like

What is your ytd utilization and Company? Mine is 98% as of the end of june. @ Kroll

like

Anyone out here who works for Emera or NS Power?

like

Any recommendations for an ob-gyn or tips for finding one on short notice in Vancouver? Friend who is trying to get pregnant just moved there from the US and is having a hard time finding someone! TIA!

like

Just had a serious come to Jesus in a meeting. It was entertaining and will lead to one of two things: a much better work environment/structure or it will solidify my decision to leave. Here we go!

likefunny

Who else has a dog and where do you like to take them to socialize/play?

like

I got a dog and realised I am allergic. What should I do now?

like

Hi, I have an offer with ZS Associates for Gurgaon location, but I don't want to move to gurgaon.
Can i ask zs to change my location to Bangalore?
I have offers from Bangalore.

likesmart

Tell me about a patient you'll never forget.

like

It's been a long week and we deserve a reward. What are you having?

like

Additional Posts in Excel Genius

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

I need to write a macro that goes into a cell, and essentially appends a "*$A$1" to the existing formula in the cell. Does anyone know how to do this? Currently I end up overwriting the existing cell

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Excel Fact Of The Day:

An apostrophe before a cell value forces Excel to interpret the value as text. (Continued on next post).

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

What are your top Excel ninja tricks? Ones that few people know...

like

Best pdf to excel converter?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

What's the F4 analogy in Office 365?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal