MS Excel Support - MS Excel Help from MS Excel Experts

Improved? Move/Copy Add-in Replacement

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which alre...

2142 Views

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille)

Intro Over this past Fall, I've had ...

642 Views

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so ...

559 Views

Here’s the scenario: on our worksheet, we want to choose a Country and the corresponding City. We want to limit the countries available to the use...

774 Views

Introduction You may want to add a horizontal line in an Excel 2003 chart to indicate a constant, such as an average, median or threshold value. ...

1238 Views

Date	Title	Author
02/03/12	Excel VBA: how to get RGB value of cell with conditional formatting?	DatGuyDub
02/03/12	Can a userlist in MS Excel be used to query Active Directory for user mailbo…	Techie77
02/03/12	Delete duplicate date rows	Billa7
02/03/12	Grid Lines Disappear in Excel 2007	vdaigle
02/03/12	Excel 2007 Worksheet linking not updating cells	TechSteward
02/03/12	Need help with syntax to check for a value in a field (Excel) and return a …	DMKetcher
02/03/12	Help with Macro to copy data from multiple tabs in multiple workbooks to one…	DMKetcher
02/03/12	How to pull data from the Archive sheet?	cssc1
02/03/12	Assistance with record macro in Excel	rtod2
02/03/12	How do I suppress the pop-up asking if I want to Update Links to other wor…	newparadigmz
02/03/12	Simplify Reference to Imbedded ActiveX ListBox	kgerb
02/03/12	Saving from Excel 2007 as Excel 2003 (.XLS)	gabrielPennyback
02/03/12	convert row data into columns in excel	olmuser
02/03/12	Excel 2010 letterhead insertion	HemisFear
02/03/12	Excel names issue	dealstrike

Date

Title

Author

02/03/12

Date	Title	Author
02/03/12	Sort Date	Billa7
02/03/12	Add new Function	Billa7
02/03/12	Finding number of days in a month using start_date and end_date	morinia
02/03/12	I need an excel formula	wrt1mea
02/03/12	using dates in case function	JJINFM
02/03/12	How to indicate a specific sheet as the destination in this macro?	Anthony6890
02/03/12	How to auto-highlight current selected row in Excel 2007?	pdering
02/03/12	Custom sorting in vba	lsalvucci
02/03/12	How do I remove the sheet selection in the bottom of Excel	Jorgen
02/03/12	Update Charts values from a sum range	BajanPaul
02/03/12	Conditional Formatting To Highlight Cells Without Formulas	lucasd1973
02/03/12	How do I use already existing Named Ranges with VBA in Excel 2007?	newparadigmz
02/03/12	Referencing Outlook 14.0 Object Library on PC with Outlook 12.0	Yaroslavl
02/03/12	Printing Excel Userforms	JoelM
02/02/12	Number of characters in excel column	morinia

Date	Title	Author
01/27/12	How to quickly and accurately populate Word documents with Excel data, …	dlmille
01/24/12	Improved? Move/Copy Add-in Replacement	dlmille
12/21/11	Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/w…	dlmille
02/01/12	Excel performance - approximate matching with MATCH and VLOOKUP	andrewssd3
11/07/11	A Better Concatenate Function	aikimark
01/26/12	Using XLM with Range Names and Conditional Formatting to automatically for…	brettdj
12/10/11	An overview of using NPV and IRR in Excel for evaluating investment decisi…	brettdj
01/27/12	Part II - Drop Down List with Unique/Distinct Values (ComboBox, ListBo…	dlmille
10/19/11	Excel: Using INDEX and MATCH	Funinig_Stroll
10/19/11	Dealing with unintended Excel Active-X resizing quirks (VBA code simulat…	dlmille
11/08/11	Drop Down List with Unique/Distinct Values (enhancing the ComboBox wi…	dlmille
10/19/11	Stacked Column and Combination Charts with Excel 2010 Sparklines	teylyn
10/19/11	Cascading Validation Lists	jppinto
10/19/11	Adding a horizontal line to an Excel chart	pdoelle
10/19/11	Quickly creating a summary differential sheet or linked output sheet - ignori…	brettdj