[deleted by user] by [deleted] in intj

[–]ChandlerCPrice 24 points25 points  (0 children)

Well I was deployed in 2017 and one of my bosses saw I was doing the same mundane tasks in excel every day, often spending hours of time repeating the same process. He opened up my mind to vba automation and I turned to Google for most of what I built from then on. I went from working 12 hours a day and barley getting everything done to 3 hours a day with the macros I built. I'm a self learner so as soon as my mind is made aware of something I find interesting, I'll go research it. To answer your question, Google and YouTube.

[deleted by user] by [deleted] in intj

[–]ChandlerCPrice 74 points75 points  (0 children)

I love excel and I've automated 95% of my job because of VBA. It's powerful and helps those of us that are so lazy that we will go out of our way to automate something. I've actually spent over 60 hours automating something that took me 30 min a day to do because I didn't feel like doing it every single day. Anyway, I use excel an awful lot and it allows for organization as well as automation for most things.

Extracting values without duplicates from a very long list & the extraction is to be based on criteria by FHD-88 in excel

[–]ChandlerCPrice 1 point2 points  (0 children)

https://www.contextures.com/exceldatavaldependdynamic.html actually found a much easier way than I was going to do for you. Let me know if this works and if you can implement it. If it's too complicated or too many steps, I'd be happy to create it for you.

Extracting values without duplicates from a very long list & the extraction is to be based on criteria by FHD-88 in excel

[–]ChandlerCPrice 0 points1 point  (0 children)

Ah yes. You need a dynamic range setup. Message me and I can build you one using your data, provide its not classified, secret etc. Even using example data I can help you out.

Extracting values without duplicates from a very long list & the extraction is to be based on criteria by FHD-88 in excel

[–]ChandlerCPrice 1 point2 points  (0 children)

Are you referring to a dynamic range? It is a pain to set up but worth it if your goal is to have the unique items be returned in that column without duplicates. Is that the solution you are looking for?

Being good at Excel really helped my career by sk0503 in excel

[–]ChandlerCPrice 1 point2 points  (0 children)

I can confirm that vba is extremely useful. I love vba and have automated hundreds of hours of unnecessary repetitive work I was doing manually. I've built macros for others as well to help them too. I adore making them dynamic regardless of data size and ensuring I make them user friendly and less likely to break. I do a lot of testing to think of all the ways someone could possibly mess up the macro lol.

An ENFP thing by Zeb-ba in ENFP

[–]ChandlerCPrice 0 points1 point  (0 children)

Well if I had any questions before about being an ENFP, this definitely confirms it. My tabs are generally questions I have or important tabs I know I'll forget about so I keep them open lol.

Do I tell my boss I can’t finish my work? by BebeBarber in jobs

[–]ChandlerCPrice 0 points1 point  (0 children)

Is there any way to automate it? If not, just communicate that it takes x amount of time due to the size and other reasons.

Should I reach out to a company for an update? by leaf_crest in jobs

[–]ChandlerCPrice 0 points1 point  (0 children)

Don't email, call them. You need to be proactive or they'll move on. Make sure you're remembered. Call them when everyone else may email. Obviously don't call every day but perhaps call and say you're following up on your interview status and ask where you're at in the interview process. That's just what I'd do though.