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

Automated PDF modification

Is there an automated way of placing elements from one PDF file into another? Open to coding this via Python if a relevant module exists. [more inside]
posted by mnemonic on Dec 17, 2012 - 4 answers

 

Using Table data to automatically (re)name worksheets in Excel 2007?

In Excel 2007 can I use data in a column on one spreadsheet to automatically change the name of another spreadsheet in the same workbook? [more inside]
posted by Lentrohamsanin on May 10, 2011 - 2 answers

Type, copy, click, paste, type, copy, click...

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

Is there a sane way to batch-convert a year of expenses from one currency to another in Excel?

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

I don't want to do this anymore - help me automate it!

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

Automating monkeywork in Excel and Word

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

Is there an easy way to break pivot table rows or pages down into non-linked workbooks

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

A little knowledge is a dangerous thing

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

Page: 1