I've been manually sending out emails about test results and then entering them into a database - is there a way to automate so part of this process? [more inside]
posted by SNWidget on Dec 2, 2009 - 10 answers

Excel n00b filter: Is there a way to automatically convert an expense sheet from one currency to another by matching the date the cost was incurred with the exchange rate applicable on that specific day? [more inside]
posted by doctorpiorno on May 29, 2009 - 6 answers

In Excel, is there an easy (i.e. free) way to cross-reference new spreadsheet entries with another workbook to ensure there are no duplicates? [more inside]
posted by downing street memo on Apr 20, 2009 - 8 answers

Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template? [more inside]
posted by McBearclaw on Jan 6, 2009 - 8 answers

I have an Excel pivot table for sales performance data. I want to break that down for regional managers so that they only have access to their own offices' data while preserving the nice formatting that the pivot table provides. Is there an easy way to do that? [more inside]
posted by willnot on Aug 20, 2008 - 3 answers

Help me automate this task involving USB-disks, Excel, HTML and maybe a batch file. [more inside]
posted by Iteki on Mar 5, 2008 - 5 answers