Join 3,433 readers in helping fund MetaFilter (Hide)

9 posts tagged with excel and visualbasic. (View popular tags)
Displaying 1 through 9 of 9. Subscribe:

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 answers

I have too many conditions for Excel

Using Excel 2000, I need to do conditional formatting with 5 options. This isn't possible with actual conditional formatting, but it is possible using Visual Basic. Unfortunately, I know nothing about Visual Basic. Specifics inside. [more inside]
posted by jeather on Jul 22, 2011 - 23 answers

MacgyverFilter: link sharing using MS Office

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

Help me make sense of excel and VB

I want to take a small worksheet I created in excel and turn it into a standalone application. How? [more inside]
posted by icarus on Jun 5, 2009 - 5 answers

Decimal seconds, please.

Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
posted by dondiego87 on Jun 10, 2008 - 5 answers

Can't calculate paired T-value in Visual Basic

Visual Basic and Excel: How do I replicate the results of excel’s internal function for paired dual tailed t-test in Visual Basic. I tried and failed, where did I go wrong? [more inside]
posted by JeNeSaisQuoi on May 16, 2008 - 8 answers

VB in the tree

vbFilter: Outputting results to a treeview object in Excel. [more inside]
posted by dnthomps on Oct 21, 2007 - 1 answer

Carriage Returns in Excel

It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
posted by godawful on Feb 10, 2006 - 9 answers

Is there any way to make Excel macros less stupid?

Is there any way to make Excel macros less stupid? [MI] [more inside]
posted by squidlarkin on Jan 5, 2005 - 15 answers

Page: 1