Macro for multiple worksheets
I have a couple of macros I want to run on several worksheets in a workbook. I want to make a copy of the worksheet and use the same macro with in a given workbook. I do not want to supply the macros in a separate file if I email the workbook to someone.

Answer Question   |  March 21, 2013  6:39 PM
Microsoft Excel 2010, Microsoft Excel macros

How to get weekly chart updates
In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to [...]

Answer Question   |  February 28, 2013  8:25 PM
Microsoft Excel, Microsoft Excel macros

Create a macro for populating cells.
I get raw data and need to clean it up. The data is a bunch of different products and the spreadsheet tracks the time it takes to process each individual product. The spreadsheet had about 100 different products. The first column is the product name, then the rest of the columns are subcategories and ways [...]

Answer Question   |  June 15, 2012  6:09 PM
Microsoft Excel 2003, Microsoft Excel macros

Excel Macro
I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro – they do not need to modify it.

Answer Question   |  May 25, 2010  12:11 PM
Excel 2007, Microsoft Excel macros, User access, XLS

Hide macro
I want to use a macro that will hide rows in the range of 17 to 61 where a value in column B is 0 on a protected sheet.  This has to be automatic (multi-user friendly) rather than using advanced filtering.

Answer Question   |  March 16, 2010  5:58 PM
Excel macros, Macros, Microsoft Excel macros

Microsoft Excel macro to access other applications
Hi, Could you please help me to get informations from other applications to excel using macros?

Answer Question   |  April 28, 2009  8:38 AM
Exchange 2000, Microsoft Excel, Microsoft Excel import/export, Microsoft Excel macros

Picking values in the intersection of row and column values
In row 1(column 2-column11) i have location”<NAMES>”(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded. I m giving the picking values for customer codes and locations from user defined data. The problem is how to get the Values lying in [...]

Answer Question   |  April 23, 2009  4:40 AM
Microsoft Excel, Microsoft Excel macros, VBA, Visual Basic for Applications

ComboBox in Microsoft Excel VBA
HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?

Answer Question   |  April 24, 2009  8:16 AM
ComboBox, Microsoft Excel, Microsoft Excel ComboBox, Microsoft Excel macros, VBA, Visual Basic for Applications

Paste values over a formula on condition of a column in same sheet
Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 [...]

Answer Question   |  April 21, 2009  9:49 AM
Excel VBA, Microsoft Excel formulas, Microsoft Excel macros, VBA, Visual Basic for Applications

Excel Macro to extract substrings from a comma-separated string.
How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

Answer Question   |  April 13, 2009  6:17 AM
Microsoft Excel, Microsoft Excel formulas, Microsoft Excel macros, String manipulation

How do I write this Microsoft Excel macro?
Hi, I’m trying to create a macro that will move rows in my spread sheet. I am working with orders that are keyed into excel, once the orders ship or are canceled; the rows are highlighted green or red. I want these shipped/canceled (green/red) rows to cut from the first page and paste into another [...]

Answer Question   |  March 25, 2009  9:56 PM
Microsoft Excel, Microsoft Excel macros

Help with a macro for linking a data entry form spreadsheet to the results spreadsheet
I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have “ranked” them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display [...]

Answer Question   |  February 27, 2009  10:06 PM
Excel macros, Excel VLOOKUP function, Microsoft Excel macros, VLOOKUP function

How to send a mail to multiple recipients from Microsoft Excel sheet?
I have an excel sheet . This excel sheet has data for many receipnts. every row has an email address(lotus/outlook) and then the next four cell in the saem row has the data for the same recipant. I want a macro to be created so that when i run this marco a new mail is [...]

Answer Question   |  February 23, 2009  4:40 PM
Excel macros, Microsoft Excel, Microsoft Excel macros

Macro to select a range in Microsoft Excel and paste in Lotus Notes
HI ALL, I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below Recipients Email Address STUDENT # GRADE COUNTRY 123@dd.com 000123 1ST GRADE United Kingdom 321@dd.com 000321 2D GRADE United Kingdom 213@dd.com 000213 3RD GRADE United Kingdom For each mail id it has to paste [...]

Answer Question   |  February 16, 2009  11:27 AM
Lotus Notes, Lotus Notes email, Microsoft Excel, Microsoft Excel macros