What are your favorite excel macros to make you more efficient at work?

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

CTRL+q to trigger activeworkbook.sheets(1).select
Simple but so handy sometimes

Another helpful one can be having a shortcut to save as the current file with the current date in the file name to version it

like

I use a macro that will clear the sample data from a template, populate several worksheets in the template with pbc data, and delete worksheets and columns that don’t apply. Then, after classifying data in the template to complete the calculations, I use another macro to delete additional worksheets and columns to create a client deliverable version of the template.

like

TTS

like

Anyone have the plug in avail?

Related Posts

Ex-New Yorkers who are now living in ATX—how was the transition? Anything you had a harder time with than you thought? Already missing all my favorite restaurants, being able to walk basically anywhere, and as shitty as it could be, public transportation.

like
like

Hey fishes,

This is my first switch and am filling up my pre-joining forms for Cognizant. Really not sure what the below 2 EPF related statements mean. My YOE is 4, not sure if that matters.
Can anyone please help me?

Post Photo
like

Hi dear LS 🐠's I recently moved from M&A Big4 to a local LATAM boutique. Could you please recommend some information sources, must read bibles, podcasts and other must reads for a noob 😚 thanks...

Do you use stock photos when building persona slides or another resource for the imagery?

like

Thoughts on summer AOTS?

In which location is Hyderabad office, I've googled it but i found multiple locations.
Also,pls suggest a good pg/society near to Amazon Hyderabad office.

like

Does anyone work in the sports industry? I'm looking for some advice. I've been working in government jobs for several years, the pay is decent and the work isn't too stressful, but I don't enjoy it or see myself here for another 20-30 years.
I'm considering doing a Master's in Sports Management. Has anyone done one? Is it worth it? Any advice on making this career pivot?

like

Federal Register confirms 2023’s 8.7% COL increase. Associate at Ogletree and my expected 2023 base salary will NOT reflect a full 8.7% increase from my 2022 salary. So I’ll effectively accept a pay cut IF I stay with OD in 2023. Also seems to mean my added yr of seniority/experience is effectively not accounted for in 2023’s salary. Is this a universal experience across comparable firms or are other firms doing across-the-board increases in light of 2023’s 8.7% COL jump? Am I overthinking this?

like

What have you done this summer for self-care so far? Share below!

Hello guys.
Moving to hyderabad this weekend. Can anyone suggest any decent Men's PG near manikonda area. How are the local PGs in hyderabad in terms of food and cleanliness?

like

Does anyone know of a good dating app? I have tried using Hinge, which I thought is designed for people to date and not to hook-up. However, everyone I chatted with is asking for pics like they would on Grindr…is that just our culture?

like

I’ve been fired two months ago. Company still haven’t picked up the office chair, computer, keyboard, etc. I’ve used to wfh. When can I start selling this stuff on marketplace?

likefunny
like

I have been offered 10.7 ctc for 3 years of experience in Deloitte, my current company (mphasis) is ready to match the offer, can you please share your views on this. What would be the pros and cons of either of the options.

like

I’ve had a first round interview with a company and am scheduled for a second round this week. The recruiter let me know that they actually won’t be hiring until a couple months down the line. Is this normal?

like

Hi Fishes,
I am working in
Citi pune currently and seeking for wfh opportunity.
Kindly clear my ambiguity as I have been told by hr that Publicis Sapient will provide permanent wfh forever. Is this true, as per my surfing this seems fishy ?
Thanks!

funny

Hi i got selected for M3BI (A Zensar company) project is Vialto partners (tech stack .net core etc) , and i got offer with valuelabs and Capgemini is in pipeline. Can anyone suggest me which is best. Any idea about M3BI they offered me high package.

like

Hi Guys. My friend cleared kpmg interview currently getting 11 lpa in 9 years exp, can he ask for 20 Lakh lpa ?

ISO Sr. IT Development Mgr.

10+ yrs in FullStack custom applications using C#, .NET, Java, Angular, Node.js and a few years engineering leadership
5+ years in SaaS solutions

ISO Sr. Software Engineer

10+ yrs in FullStack applications using C#, .NET, Java, Angular, Node.js
Extensive experience in AWS or Azure

ISO Principal Software Engineer

12-15 yrs in FullStack custom applications using C#, Java, Angular, Node.js
Designed high-availability applications in a multi-tier cloud architecture

like

Additional Posts in Excel Genius

Is there a trick to analyzing more than 1MM rows in excel?

likefunny

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

Too many format error, already tried the XLStylesTool. What next?

I rarely have to use formulas in Excel, so please be kind to me.

Apart from conditional formatting cells, what formula can be used to display a word whenever a cell contains a range of numbers? Contd

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

I have a spreadsheet that pulls data from rest APIs into power query. Is there anyway to make this sheet work for people on Mac?

likefunny

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

like

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

I have a simple formula outlining the condition that if the range of values for each row is greater than a particular cell within the same row, then highlight. Need to find a shortcut to replicate

like

why is index match superior to vlookup?

likefunny

Is there a way to easily create all the permutations of 315 possible combinations of numbers in excel?

like

Hi guys!

I need help with something: I recently started using xlookup in excel to automate recurring tasks (accounting) but I have found that my peers and supervisors have difficulties understanding how the numbers are pulled, which makes their understanding of the files difficult.

What would be the best way to convert the result of an xlookup cell to a reference to the found cell?

Is there any way that could be applied to all the xlookups in an excel file?

Thanks in advance!!

like

Hello Excel Genius!
How do I calculate the monthly average of items returned and credit return by each division in a year?
Thank you!

like

I have a big data set, which is compiled via power query. The source data gets updates every now and then. As the client isn't consistent with his organizing, I get a problem with my pivot. (Cont)

likehelpful

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

likesmart

Anyone have recommendations for a 5 year forecast model and/or template for a private company? (For a small fintech company)

like

Anybody know if you can access an older version of an excel file (like from version history) using vba?

Trying to write a script to compare old versions and list changes since a given date

like

Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client input. Sheet 2 is a summary dashboard of each of those 20 tasks. If sheet1 C3 is green, how can I get the respective sheet 2 dashboard cell to also turn green?

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