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

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

Excel VBA Introduction by WiseOwlTutorials on youtube is pretty helpful.

like

Awesome! The r/Excel community on Reddit can be a great resource as well.

like

Reposition and resize comment boxes ... but I cheated and found it on google and then played with the code to work for me It’s a start!

like

Well, what does it do, good sir?!?!?

likefunny

It's a great feeling isn't it?! What does it do?

like

As EY3 said and also the vbaisfun YouTube channel. Not as structured as WiseOwl but good for small bites.

like

Congrats! And here's to many more

Thank you for the tip, PwC1!

Congratulations!! Any good sources of material for someone trying to learn macros?

Well done!!

Related Posts

Tata Consultancy not giving anniversary hike new joners?

like

I am looking to buy my first property soon - preferably new constructions (anything except condos) anywhere in Ontario/Canada. Any suggestions where I can turn to find new construction projects? I understand I need an agent. Until I find a good one, I am looking at the houses myself. Any suggestions where I can get information about new projects happening in the province?

like

Anyone who has started up a side hustle whilst working in consulting - is it generally a good idea to let your employer know or will they make your life difficult/try to push you out if they know?

(Context - I need the extra income to have a shot at affording grad school, I work for a small boutique, job contract was ambiguous on the issue. Side hustle is selling stuff I make as a hobby on Amazon)

Thanks!

like

Have you ever been blocked from a promotion or internal transfer by your manager?

like

I am a clinical research coordinator working in Austin, Texas. I have my Masters in Cell & Molecular Biology and have a year of laboratory research experience.

I’ve been in my position for 5 months now. I make $27 hourly which amounts to about $51,000 yearly. Am I being under paid? Are all coordinator positions hourly? As a laboratory researcher I was salary :(

How do I go about asking for a raise or should I explore other companies or medical schools that have clinical research?

like

How much of a hike can one expect at Brillio on promotion from Engineer( Level 8) to Senior Engineer ( Level 7) ?

How many of you go to networking events mostly to date?

funnylikesmart

Chocking down a way too dirty martini, reached in bag to grab headphones & felt this. Inbound me coming in clutch for outbound me.

Post Photo
likefunnyupliftingsmart

Anybody else noticed recruiters are only proactively reaching out about hybrid/on-site roles nowadays?

It's almost as if people don't want to be in offices anymore so that's why it's difficult for them to fill those roles.
Sidenote: recruiters, you can see on my LI profile that I'm remote. In the "What jobs are you interested in" field you can see I'm only interested in remote roles.
So, why are you reaching out to me about jobs in a city 3 hours away that's 100% onsite and w/out even a ReLo?

like

Hi all, I need SAP ABAP Notes for interview preparation, can anyone please help me if you have good notes of SAP ABAP which will be helpful. Please help me. I will be grateful. TIA

like

Does anyone have a good psychologist/counselor recommendation in NYC? One that accepts United and doesn’t charge $130 “for the first six sessions”? I just want someone I can pay $35 weekly.

like

Anyone participating in biketoberfest on Sunday?

Hi - Is Security specialist II same as Security Engineer at Amazon? What’s the compensation range?

like

Moving from Asia to London, and just received an offer for a corporate strategy role. Do UK companies typically offer signing bonus? Wondering if it’s something viable to nego for. 4 YoE

like

Found a good looking Herman Miller Aeron, used on CL. Worth the 400 bucks? Do not have a proper office chair at the moment

like

Hi all, has anyone temporarily transferred to the Canadian office of their firm and done the Canadian PR application while they were there on work visa?

like

Does PwC revoke your I-140 petition if you leave the firm within couple of months after the approval?

You know how when you do something bad to someone else you get bad karma w that person? Who decided who was in the wrong? What if you both think you’re right? Who gets the karmic debt?

like

Planning on getting married in a temple in the US. Does anyone know what all paperwork (eg marriage license, certificate, registration) I should be thinking about and how to get it done?

like

Additional Posts in Excel Genius

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

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 compare two sheets to make sure they are identical?

like

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

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

How do I create a formula that creates a “cutoff”? For example, let’s say I have 1000 hours. I have a list of activities in a tab that take up 15,20,50 hours etc. I want to highlight the cutoff as soon as that 1000 hour limit is reached.

like

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

like

Any book recommendations on excel modeling for real world business applications?

like

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

likehelpful

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

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

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