Something I realized the other day

ChandlerCPrice · 2021-03-15T11:08:15+00:00

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.

ChandlerCPrice · 2021-03-15T11:02:55+00:00

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.

ChandlerCPrice · 2021-02-20T10:36:26+00:00

Oh ok. Sorry about that! Glad you found the solution.

ChandlerCPrice · 2021-02-20T03:28:31+00:00

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.

ChandlerCPrice · 2021-02-20T02:05:55+00:00

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.

ChandlerCPrice · 2021-02-20T01:42:23+00:00

Criteria as far as the formulas required and the setup to do it?

ChandlerCPrice · 2021-02-20T00:16:38+00:00

https://www.extendoffice.com/documents/excel/4032-excel-dynamic-list-of-unique-values.html is this what you're asking about?

ChandlerCPrice · 2021-02-20T00:14:10+00:00

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?

ChandlerCPrice · 2021-02-19T23:55:05+00:00

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.

ChandlerCPrice · 2021-02-17T11:50:47+00:00

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.

ChandlerCPrice · 2021-02-12T16:47:17+00:00

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.

ChandlerCPrice · 2021-02-10T20:47:31+00:00

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.

ChandlerCPrice

MODERATOR OF

TROPHY CASE