Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]
posted by complience on Nov 25, 2009 - 4 answers

Please help me create an excel macro to hide rows given a certain criteria. [more inside]
posted by onich on Nov 17, 2009 - 9 answers

How can I set up Excel 2003 to automatically include the file name and path on every spreadsheet when printed? [more inside]
posted by Wroksie on Oct 20, 2009 - 7 answers

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

Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...] [more inside]
posted by The Deej on Aug 11, 2009 - 14 answers

ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
posted by cholly on Jul 30, 2009 - 4 answers

Excel 2003 says I have macros in one workbook. I want to delete them, but Excel won't let me. NeoOffice (for the Mac) also won't let me. When I look for them using the Macro Dialog box or the VB editor, I can't find them. Can I delete these macros, or do I have a serious problem? [more inside]
posted by CancerMan on Jul 10, 2009 - 9 answers

I'm using Windows 2000 professional. I'm copying data from excel to the forms on separate pages of a website, and have to repeat a string of keyboard controls several times. Is there an application I can download to do this automatically? Does the computer come with a tool that allows you you type a series of keys into the computer, then just "repeat" 83 times? [more inside]
posted by omnigut on Jun 16, 2009 - 9 answers

ExcelMacroFilter: Am I screwed? I need a macro in a pre-formatted Excel template that will open the Open File dialog box and then, once a file is opened will copy/Paste Special...Values into the template. [more inside]
posted by bluejayway on May 29, 2009 - 12 answers

Code Execution has been interrupted:
Continue - End - Debug - Help
*Click Continue*

*Repeat Indefinitely*
Help?! [more inside]
posted by johnstein on Jan 19, 2009 - 6 answers

How can I have Excel generate a new column with the data I need using certain conditions and pulling data from a pivot table? [more inside]
posted by ttyn on Jan 6, 2009 - 5 answers

How can I close DDE connections? [more inside]
posted by slavlin on Dec 18, 2008 - 1 answer

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

Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]
posted by johnstein on May 21, 2008 - 8 answers

How to "text to column" a cell with multiple lines in Excel? [more inside]
posted by keasby on Jan 24, 2008 - 7 answers

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]
posted by moocheen on Jan 15, 2007 - 10 answers

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]
posted by chrisamiller on Dec 27, 2006 - 3 answers

I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted by michaelkuznet on Sep 1, 2005 - 5 answers

I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted by synecdoche on May 4, 2005 - 31 answers

Is there a plug-in or macro for Excel v.X or Excel 2004 for Macintosh that adds PivotChart (from Excel 2003 for Windows) functionality or compatibility?
posted by AlexReynolds on Jan 13, 2005 - 2 answers

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