Good Website to learn Excel Macros
Please suggest a good website for a beginner to learn Macros.

Answer Question   |  March 11, 2013  11:43 AM
Excel macros

Excel macro – create a chart
I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and [...]

Answer Question   |  January 26, 2011  5:05 PM
Excel 2007, Excel Charts, Excel macros, Macros

Message Alert Box in Excel 2003
I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they’ve done everyday…for the whole week. [...]

Answer Question   |  December 25, 2010  10:30 AM
Excel 2003, Excel 2003 functions, Excel 2003 macros, Excel macros

Excel 2003 Macros with Org Chart Parent
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]

Answer Question   |  March 11, 2011  3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros

Cell Automated Population using Excel macro
Hi, is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you [...]

Answer Question   |  December 8, 2010  8:33 AM
Excel 2003, Excel macros, Excel VBA, Visual Basic

Excel and Access integration and auto-population
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]

Answer Question   |  December 7, 2010  2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros

Date Range in Excel Macro
Hi, I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is [...]

Answer Question   |  December 2, 2010  4:18 PM
Agents, excel, Excel macros, Macros

Sending Email in Excel using Macro
Hi, I want to create a button in excel wherein once you click that button a message will pop-up and ask “Are you sure you want to send notification to your supervisor?” Yes/No. If yes is selected a New Outlook Message will appear where recipient’s email address is already given and the subject is already available [...]

Answer Question   |  November 22, 2010  6:34 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000

Search for column header in Excel 2007
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]

Answer Question   |  November 25, 2010  3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros

Macro to Email an Excel file with an Outlook Template
I have an Excel macro that creates a PDF file from Excel. I want to set up the macro to eMail the PDF using a template rather than a blank Outlook eMail so that I can use a standard message and format.

Answer Question   |  November 2, 2010  10:51 AM
excel, Excel macros, Outlook template, PDF Files

Excel 2007 macros
In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?

Answer Question   |  October 14, 2010  7:41 PM
Excel 2007, Excel 2007 macros, Excel macros, Office 2007, VBA, Visual Basic

Operating DOS through excel(VB or macro).
Cheers. I m new to IT.I wish 2 operate DOS through excel. For example , in DOS we write some command and then press enter, then dos displays the information concerned with that command. Is this possible to do this, i.e writing command in DOS and pressing enter jst by writing a programme in excel.Plz [...]

Answer Question   |  September 30, 2010  3:04 PM
Access multi-table reports, DOS, DOS program, excel, Excel macros, Visual Basic

Proper Excel 2007 macros to identify table
dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;" width="84">[/cOLIST] [col style="width: 62pt;" width="83">[/cOLIST] [col style="width: 48pt;" width="64">[/cOLIST] [col style="width: 66pt;" width="88">[/cOLIST] [...]

Answer Question   |  August 25, 2010  7:30 AM
excel, Excel 2007, Excel 2007 macros, Excel macros, Excel Tables

Enabling xlmacro help in Excel 2003
Excel 2003 includes the file Xlmacro.chm linked to “Help on this function.” When I click on “Help on this function” the XlMacro.chm file is not loaded – actually nothing at all happens, not even an error message.

Answer Question   |  June 9, 2010  1:42 PM
Excel 2003, Excel error messages, Excel macros

Need loop to cut rows that meet criteria and paste to another sheet.
I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.

Answer Question   |  March 3, 2010  9:55 PM
Excel 2003, Excel macros, Microsoft Excel, VBA, VBA/VB

One macro to systematically run F5 key on up to 20 other macros
I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination Ctrl+Shift+(?)

Answer Question   |  February 25, 2010  2:31 AM
Excel macros, Microsoft Excel

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

Run a Macro in Excel 2007 spreadsheet located on a file server
When I run the macro located on the local drive it works, but when I put the document out on a shared file server I get an error. The server folder is in my trusted locations.

Answer Question   |  June 22, 2009  2:09 PM
Excel 2007, Excel macros, Microsoft Excel

email macro
create amacro to send an email with Excelattachment

Answer Question   |  February 15, 2010  5:19 PM
Excel macros, Microsoft Excel, Outlook

Macro to Open Crystal Reports
I have an excel spreadsheet that I’ve used to create a crystal report. The excel file has multiple employee id’s on it. The crystal report has a parameter that uses the employee id to only show that employee’s information. I’m trying to set up a macro to loop through the employee ID column, pass one [...]

Answer Question   |  May 4, 2009  2:27 PM
Crystal Reports, Excel macros, Microsoft Excel