anyone here write vba or create macros with Hyperion smartview?

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

Nope.

The secret to VBA is to find some crappy code on GitHub and copy/paste it. Starting from scratch is for chumps.

Related Posts

My mom was diagnosed positive for Covid and she’s been feeling progressively worse over the last week. I can barely focus on work right now but taking time off seems pointless since we’re remote

like

How much WIPRO pays to B3 band on H1B for tech lead in US onsite for city Minneapolis.

like
like
like

What has your marketing goal been for this month? How far along are you to meeting your goal?

like

Best techstack to earn high?

like

Hi Fishes 🐟,

Could you please tell what would be my in-hand?

Yoe: ~2 yrs
Role: SDE
Company: Startup
Techstack: Spring & React

Post Photo
like

Do you feel that the job you doing is actually helping patients?

P.S: My job is to estimate what's maximum we could charge for a drug. Doesn't seem to help them/us.

funny

Creative Director or Product Design Director. Which one would you pick for the next 10 years?

like

How many miles are appropriate for a 12 hour delay and one day missed of work as a result? This was international travel, delay wasn’t weather related.

like
like
like

Any other managers having a hard time transitioning out of audit and into an interesting role with a fair salary and a 40-hour work week? I receive the daily influx of blanket messages from recruiters on LinkedIn but it’s exhausting trying to sort through them.

Open to staying within an accounting and/or advisory firm, just bored with audit at this point.

like

Can anyone help me out with a KPMG referral?

like
like

I'm seeking information about salary or pay rates for office manager and or office lead in Duluth Georgia.
Job tasks and duties such as parts ordering, service coordinating, inventory, pick ups, routing service vehicles, onboarding and training new employees,
Reconciling cash drawers and deposits, AR report,tax exempt report, billing disputes, de-escalation.
All things customer related and I'm fluent in all rolls of leadership.

like

What consulting firm has the strongest rep in medtech DDs?

like

Got offer from BCG for ECT. Read numerous comments about ECT being not attractive compared to Generalist track. Also heard challenges about billability/utilization. Any views/ guidance appreciated!
I am not super keen to become a partner (selling) and main reason to join will be working with different clients, smart talented people and a good brand. End goal (at the moment atleast) is to stay for few years and return to the industry. 15 YOE

like

My current ctc is 14 lpa + 10 lpa as freelance. Shall I accept 22 lpa? Yoe: 7.8. Considering I won't be able to get time for freelancing due to daily travelling

Also please like the post

Additional Posts in Excel Genius

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

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

What are the most typical models you all build

likehelpful

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

Post Photo
like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

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

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

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

What's the F4 analogy in Office 365?

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

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

likehelpful

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 I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

What’s the best way to become a good excel modeller in a short time? Coursera course? Something else?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Index match question! Is there any way to add a sum function? Index match pulls the first value in the table, but I want the sum of all values in a row with the same header.

like

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