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

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

Inserting symbols before and after some other text in Excel (macros?)

Is it possible to do this in Excel or Word or some other program?: I want to paste a sentence into the a text field, highlight a word or several words in that sentence, hit a keyboard shortcut, and have certain symbols inserted before and after that word or phrase. For example, in the sentence "Metafilter is the best website in the whole wide world," I might highlight "website," press the shortcut, and have it transform into the following: "Metafilter is the best {{c1::website}} in the whole wide world." I'm using OSX and Microsoft Office 2011, but I'm comfortable doing this in a webapp or Google Drive or whatever you suggest! I also have the aText text expansion software, but I can't figure out how to make it insert text at both ends of a highlighted phrase. [more inside]
posted by lizzicide on Jul 25, 2014 - 7 answers

Looking for an advanced Excel/Access crash course

VBA and Macros and VLookup, Oh My! I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start. Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
posted by firechicago on May 19, 2014 - 2 answers

Making Excel do stuff for me, automagically!

Where can I find snippets of vba macros that I can use/reuse? What are your favorite macros that you use and can't do without? [more inside]
posted by rippersid on May 18, 2014 - 3 answers

Stinky Linky!

Is there a way to define a link by the number of links into the webpage it is? [more inside]
posted by ian1977 on Apr 2, 2012 - 2 answers

Excel is the death of me!

I have about 200 separate Excel spreadsheets that I need to change one field in. There is a date in G4 that needs to be the same in each sheet. Is there way way to do this without opening, editing, and saving each sheet one at a time?
posted by keep it tight on Dec 19, 2011 - 10 answers

Excel math puzzle

Excel question. Is there a way to determine a list of all possible values from a list that add up to a given total? [more inside]
posted by xedrik on Dec 14, 2010 - 4 answers

Microsoft Excel or Substitute?

Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros. [more inside]
posted by mbarryf on Aug 11, 2010 - 6 answers

There can be only one (Excel formula I have to update)

Excel guru filter: I want to change this formula every week, and have the change cascade across 20 tabs of independent data. [more inside]
posted by deludingmyself on Jul 3, 2010 - 7 answers

Trying to find Excel VBA code for "round dot" gridline.

Excel VBA question: help me insert a "round dot" gridline in my chart. [more inside]
posted by mullacc on Apr 18, 2010 - 8 answers

Another GD excel question

Another, once again, excel question on fill colors [more inside]
posted by TheBones on Jan 5, 2010 - 11 answers

Help save me from excel hell!

Another crazy excel question- I can't promise this won't be my last one. [more inside]
posted by TheBones on Sep 2, 2009 - 8 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

Help me optimize a list in Excel.

Help me optimize a list in Excel. (Excel gurus welcome!) [more inside]
posted by pealco on Sep 28, 2006 - 3 answers

Office of OS 9 Macros not working too well in OS 10.4

When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
posted by ParisParamus on Jun 15, 2005 - 1 answer

Page: 1