Anyone have any interesting or fun macros they want to share? I like to do as much as I can without writing any VBA, but I bet there’s a ton of people in this bowl that have no idea what’s even possible when you break out the editor. I’ll drop a description of one I did recently in the comments.

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

A macro that copies content directly from excel into PPT and then makes minor formatting tweaks. This thing probably saved me and my team hundreds of hours over the years for about ~12 types of deliverables that were laid out in a manner conducive to this working. Now piloting Gen AI to see if it can generate the content as well.

like

Definitely would have been useful in my consulting days. Recently, I’ve been going the opposite direction. People keep sending me data in PowerPoint slides with tables, so I wrote a macro to scrape all the tables and copy into excel where I can actually use it.

like

Made some macros that autoformat to accounting w/out decimal places, change font color, change cell highlighting on 1 keystroke because Im too lazy to do alt + 4 keystrokes

We had created a macro to analyze the progress done on construction site for stormwater drains, compare with already billed progress and officially approved progress length and spills out the invoiceable lengths and check for missing documents and flags them as well.
We had a guy doing that manually and it took him every month 2-3 days, this macro reduced the time to 1-2hrs and 100% accuracy given input data is accurate.
It goes through more than 100k line entries and takes about 15-20mins to run the computation.
I am not from computer background but we pulled it off.

Related Posts

Interviewing at so many places and often get dinged at final rounds. Hoping and praying for the right one to work out.

like
like

Tux budget NYC?

like

What is the one thing you would change about your firm if you could?

like

I applied for a job within my unit that I do not qualify for. Now, I have an interview for this job. Me knowing I do not meet most of the qualifications for this position has my imposter syndrome thinking I shouldn’t even do this interview because it would be a waste of time. Has anyone felt this way?

like

Given an interview for Chief Minister -2 ,(YOE 17 Years,Skill- Mobile App development).How much CTC I can expect . Thanks in advance.

Is CitiusTech a worth joining? I have heard they have long and late night working hours? I am looking for a wlb and better learning prospects.
Please suggest.

like
like

Need a sanity check here.

When I joined my current company, we were on a quarterly bonus structure with guaranteed payouts each quarter. This was, in fact, how the recruiter said he could meet my salary request.

The company just announced we are moving to annual payouts only, with no payments for 2023 until May 2024. There are no raises happening.

This amounts to 12% less money in my pocket in 2023 plus inflation.

Is this standard, or should I be looking for opportunities elsewhere?

like

Any walk-in interviews in Pune? Please Help

like

My natural instinct is to assume rejection if I have conflict with a partner or don’t think my feelings are reciprocated. I’ll try to bring it up with them, but I’ll say “if you want to end this feel free” so it doesn’t hurt me (and they can say what they really mean instead of sugarcoating). Someone told me today that they just assume I’m not interested because I always seem to “run” but I’m not sure how to bring up problems/feelings otherwise. How do you approach these hard questions?

like

I am sorry, is this LinkedIn or some dating blog?

Post Photo
funnylike

“There are so many layers of Daddy. Book coming soon. How to get one, how to be one, how to keep one!”

funnylike

Working for a senior who is beyond horrible. She talks to you like you’re stupid and makes it sound like you’re absolutely terrible at what you’re doing. She’s made 5 other associates cry during her 5 year career. Got someone fired and made another person quit. It’s known around the office that she can no longer have a female associate, because she talks down to females more than she does males. I came along and thought I could deal with it but she literally makes me want to not log on tomorrow.

like

Hey fishes!

What according to you is a decent as well as average package (current market standards) for analytics associate with 4yrs of experience? Your response will be highly appreciated. Thanks!

like

Hi! can anyone please refer me in ZS? I’ve the job Id.

like

Favorite halal restaurant in Boston? Help a Muslim brother out 😅

likesmart

I see Uncommon saying the new Nic Cave doco is their first feature film but I can’t find their names on credits anywhere. What role did they play in it? Genuine question.

like

I want to support our medical assistants- they do so much to help us! How do you make sure they feel our appreciation?

like

Additional Posts in Excel Genius

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

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

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

Post Photo
likehelpful

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

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

How long did it take you to become good at excel? Like fast?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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!

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

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

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