This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Apologies if this was likely done before. My background for the last 5 years has been mainly in supply chain. A security guard gig where I got my feet wet in the field, then several warehouses and last April landed at a major North American brokerage where I received accomodations highlighting my ability to collaborate and communicate with others departments on tasks whether they were large or small in scale. After a YOE there I left this past May for a promotion/pay raise at a start up brokerage that unfortunately lost funding in July thus resulting in a layoff. I did a lot of customer facing tasks during my two months however and as a defacto department head got to collaborate on some projects and even spearhead one too (it was mainly cold calling carriers for networking purposes then working with our IT guy to create an Excel spreadsheet to house them). Severance and unemployment will keep me afloat for a while and I bought a Maven Analytics subscription as they've got very helpful and immersive content. I'm learning XLookup and Pivot Tables ASAP but what else do you think I should highlight that I know when I craft a new resume?
The fact that VBA can both send and receive email has been gamechanging for me. My desk now processes hundreds of requests a day with no human interaction required whatsoever, and it’s all tied to email. This accounts for over 90% of all the activity my desk does (including everything done by people).
VBA really opens things up when you get creative.
Post Details
- Posted
- 1 year ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...
I manage a Survivor NFL pool that’s entirely automated with VBA. It downloads schedules and odds; it keeps track of everyone’s picks, sends emails with simple spreadsheets to make your submission, a reminder to those who don’t submit in time, and automatically picks your best option if you miss the deadline.
I even incorporated a one rebuy option. :)
Everyone loves it. 117 players this year.