c0259621,
Welcome to the MrExcel forum.
Training / Books / Sites:
MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
http://www.mrexcel.com/forum/forumdisplay.php?f=19
How to Learn to Write Macros
http://articles.excelyogi.com/playin...ba/2008/10/27/
How to use the macro recorder
http://articles.excelyogi.com/
Click here and scroll down to Getting Started with VBA.
http://www.datapigtechnologies.com/ExcelMain.htm
If you are serious about learning VBA try
http://www.add-ins.com/vbhelp.htm
Excel Tutorials and Tips - VBA - macros - training
http://www.mrexcel.com/articles.shtml
See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Debra Dalgleish has some notes how to implement macros here:
Excel VBA -- Adding Code to a Workbook
http://www.contextures.com/xlvba01.html
David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm
Creating custom functions
http://office.microsoft.com/en-us/excel/HA011117011033.aspx
Writing Your First VBA Function in Excel
http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html
http://www.excel-vba.com/
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.exceltip.com/excel_links.html
(livelessons video)
Excel VBA and Macros with MrExcel
ISBN: 0-7897-3938-0
http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1
http://www.youtube.com/user/ExcelIsFun#g/search
http://www.xl-central.com/index.html
http://www.datapigtechnologies.com/ExcelMain.htm
Dependent validation lists. Debra has a neat little tutorial here.
http://www.contextures.com/xlDataVal02.html
Data Validation > Drop-Down Lists - Dependent
http://www.bettersolutions.com/excel/EGH188/QE229212022.htm
Cascading queries
http://www.tushar-mehta.com/excel/ne...ing_dropdowns/
http://www.contextures.com/xlDataVal05.html
Excel Data Validation - Add New Items
http://www.contextures.com/excel-data-validation-add.html
Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
http://www.cpearson.com/Excel/vbe.aspx
Locating files containing VBA
Searching Files in Subfolders for VBA code string:
http://www.dailydoseofexcel.com/arch...a-code-string/
http://www.pcreview.co.uk/forums/thread-978054.php
Excel 2003 Power Programming with VBA, by John Walkenbach
VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad
Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley
VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad
Excel 2007 Book: you can try this...there is a try before you buy ebook available at this link…
http://www.mrexcel.com/learnexcel2.shtml
DonkeyOte: My Recommended Reading:
Volatility
http://www.decisionmodels.com/calcsecretsi.htm
Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Introduction to Array Formulas
http://www.xtremevbtalk.com/showthread.php?t=296012
Using Pivot Tables and Pivot Charts in Microsoft Excel
http://peltiertech.com/Excel/Pivots/pivotstart.htm
A List of Pivot Table links at Jon Peltier's site (contributed by Debra Dalgleish) is here:
http://peltiertech.com/Excel/Pivots/pivotlinks.htm
Email from XL - VBA & Outlook VBA
http://www.rondebruin.nl/sendmail.htm
http://www.outlookcode.com/article.aspx?ID=40
Excel Function Dictionary
http://www.xlfdic.com/
Excel 2007 function name translations
http://www.piuha.fi/excel-function-name-translation/
Dynamic Named Ranges
http://www.contextures.com/xlNames01.html
Where to paste code in VBE VBA
Introducing the Excel VBA Editor
http://www.ask.com/web?qsrc=2417&o=101881&l=dis&q=Where+to+paste+code+in+the+Excel+VBA+Editor
VBA for Excel (Macros)
http://www.excel-vba.com/excel-vba-contents.htm
VBA Lesson 11: VBA Code General Tips and General Vocabulary
http://www.excel-vba.com/vba-code-2-1-tips.htm
Excel VBA -- Adding Code to a Workbook
http://www.contextures.com/xlvba01.html
Basics of array formulas
http://www.youtube.com/view_play_lis...7E7E9CA63304D3
Array formula data extract formulas
http://www.youtube.com/watch?v=Tp7I5u1MqiM
http://www.youtube.com/watch?v=R5ZWAiNJLNo
http://www.youtube.com/watch?v=132ZdpxBm1U
How to create Excel Dashboards
http://www.contextures.com/excel-dashboards.html
http://chandoo.org/wp/excel-dashboards/
Unique Record Counting and Data Extract formulas
http://www.youtube.com/watch?v=uUrI8hoj8BA
ffice
></o
