How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas? [more inside]
posted by Bugbread on Oct 22, 2009 - 7 answers

How to automatically breakout Excel worksheets based off one "master' worksheet? [more inside]
posted by entropicamericana on Jul 9, 2009 - 9 answers

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]
posted by korres on Feb 5, 2008 - 4 answers

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted by ChasFile on Feb 1, 2008 - 8 answers