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
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
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
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
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
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
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
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
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
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
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
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
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
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 firstname.lastname@example.org 000123 1ST GRADE United Kingdom email@example.com 000321 2D GRADE United Kingdom firstname.lastname@example.org 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