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

First off, if you have been actually using VBA, then in my opinion you are a coder. Your scripts could be long or short, but you still write code.

Second, unless they completely remove VBA, I don’t think it will ever be completely replaced. I feel pretty certain in the short run you will still need it to tweak whatever code it produces. I also think there will always be those people that want to be closer to the program as it were.

Think of it this way, Dreamweaver did not replace web coding. It simplified site building for designers, but I will never forget the guy that told me, “Yes, but it leaves a bunch of unnecessary crap in there that slows down your pages.” That was the first time I bothered to look, and he was absolutely correct.

smart

Related Posts

I just stress-ate two doughnuts. How’s your day going?

likeuplifting

What do people around here do on the weekends? It seems pretty slow so far

like

Question for consultants trying to move to the buy side - would you rather take a UMM value creation role on-cycle, or wait to take an off-cycle LMM deal team role? (Assuming deal team was the originally intended goal)

like
like

Does AmEx take codility test for hiring? Anyone who can share some insights?

Hi folks- wanted to know how’s Walmart account in Coforge., I recently got an offer and said would be given Chennai Walmart. Please advise, any feedback would help- thank you

like

How is Allstate india to join as engineering manager? How is growth, WLB, are they rigid. On WFO hybrid or flexible to work remotely.?

like

Te a ching RSP/SAI. Any help on how

like

My students come to my class first every morning and are really hard to settle. They continue to carry on whatever they were doing on the bus. It takes about 20 min to get them settled down and doing the warm up and the class is only 45 min. Any tips?

like

When a company asks us to provide the offer letter we are already having , is it fine to provide it to them as it is confidential.

like

Do we get any diwali gift??

like

Any insights for KPMG Strategy - Deal Advisory within the Global Strategy Group (Experiences, Exit Opps, Salary)?

like

What is the range of annual stock refresher for Software Engineer II(62 level) at Microsoft, Bangalore?

likeuplifting

Hello Fishes,

Need your valuable suggestion here.... I am planning to pursue an MBA in marketing from a good brand however due to the fees/cost constraints not able to shortlist one. Can someone please help with a reasonable institute with good placement records?

Thanks!

like

A Tesla put is so tempting right now…
Anyone else feeling the same?

likefunny

I have heard McKinsey has a bad Work Life Balance, are there any Software Engineer 1 in this bowl who can share the ground realities ?

How many hours a day do you work in general, do you work 12+ hours including commute time.
Also how much work you do here is support and how much is development work, how are the projects that we work on and do you use new tech stack or you use old technologies.

What are the career opportunities and hikes like.

like

Hello fishes,
I have 1.8 years of experience in Manual, automation, API and AEM testing. And my current CTC is 3.97 LPA, how much can I expect while switching?

Thanks in advance

like

How Is Lowe's India for a fresher?

like

Additional Posts in Excel Genius

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Would anyone be willing to teach me vlookup?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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

Scan your QR code to download
Fishbowl app on your mobile

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