andrewexcel.blogspot.com
Andrew's Excel Tips: 04/17/15
http://andrewexcel.blogspot.com/2015_04_17_archive.html
Making Excel do the work for you. Friday, 17 April 2015. AET Data Checker v1.1. A while back I promised a new version of my AET Data Checker addin. and I just uploaded it! 1 Dropdown lists to select columns. This enables you to use your keyboard arrow keys to scroll across columns without having to type them in like before. The benefit is that you can just "scroll" across columns and watch the values change. 2 You can show percentages, including to the number of decimal places you like. See you next time.
andrewexcel.blogspot.com
Andrew's Excel Tips: 12/03/14
http://andrewexcel.blogspot.com/2014_12_03_archive.html
Making Excel do the work for you. Wednesday, 3 December 2014. Excel 2013 and the Ribbon. I've recently started using Excel 2013, and soon noticed the Ribbon doesn't act the same way as it did with Excel 2007 and Excel 2010. Addins that add menu items to "what used to be" (still is) the Top Menu (Menu Commands on the Add-Ins tab) and toolbars (Custom Toolbars also on the Add-Ins tab) are affected. After a quick look on the Internet, I found this. Well now, that changes things a bit. If you have already do...
andrewexcel.blogspot.com
Andrew's Excel Tips: 10/30/14
http://andrewexcel.blogspot.com/2014_10_30_archive.html
Making Excel do the work for you. Thursday, 30 October 2014. If you work with data from various sources, it's possible you will come across numbers formatted as Text. Depending on what you plan to do with these numbers, it's possible that the Text formatting will cause problems. For example, let's see how many "numbers" there are in the picture below. Look at the formula I've entered in cell B1. Let's set things right. Select Text from the Number tab, then click OK. Treat yourself to a well-earned cup of...
andrewexcel.blogspot.com
Andrew's Excel Tips: 11/21/14
http://andrewexcel.blogspot.com/2014_11_21_archive.html
Making Excel do the work for you. Friday, 21 November 2014. In 2004 I met someone who would change my life and give me inspiration to start blogging. That person was my friend and mentor, Masaru Kaji, more commonly known in Excel circles as Colo, of Colo's Junk Room fame. Please welcome him back. You can find his new site here. Links to this post. Subscribe to: Posts (Atom). Subscribe in a reader. For any enquiries, please contact. Me at the email address below. Code for Excel and Outlook.
antonio.beyah.net
VBA Merged Cell Value in Excel — Beyah’s World
http://antonio.beyah.net/blog/2008/04/08/vba-merged-cell-information
Welcome to Beyah’s World. 8220;Street Kings” Review. VBA Merged Cell Value in Excel. April 8th, 2008 Programming. Today, I was attempting to use VBA to read the value of a merged cell. Let me say that this task sucked for multiple reasons. Let me preface this by stating that I am familiar with programming, including VB and C#. Without further adieu (spelling credit goes to Erik Hess):. Function GetMergedCellValue(iRow as Integer, iColumn As Integer) As String. Dim mRange As Excel.Range. Set mRange = Acti...
excelempresas.com
Excel práctico para empresas: Automatización en Excel. Buenos trucos.
http://www.excelempresas.com/2013/11/automatizacion-en-excel-buenos-trucos.html
Excel práctico para empresas. Excel, Macros, Funciones, intercambio de ideas, administración, empresas. Jueves, 21 de noviembre de 2013. Automatización en Excel. Buenos trucos. Dejó acá un enlace que me pareció interesante con varios trucos de macros y automatización, siempre útiles y muy bien organizados. Si bien muchos son básicos, son muy buenos para los que recién comienzan en esto de las macros y la programación en Excel. RECOMENDADO. Ir al sitio Click. Rodrigo Lorenzo García Apeceche.
excelempresas.com
Excel práctico para empresas: Privado
http://www.excelempresas.com/p/privado.html
Excel práctico para empresas. Excel, Macros, Funciones, intercambio de ideas, administración, empresas. Sector privado. Registrarse. Enviar por correo electrónico. Publicar un comentario en la entrada. Suscribirse a: Entradas (Atom). Hojas en Excel Blogspot. Code For Excel and Outlook. Busqueda en una matriz. Comparar dos listas en Excel. Extraer número de legajo. Gráfico animado en excel. Macro para Botón derecho. Selección por rangos Macro. Sicoss Version 36 release 5. Tips y Trucos Excel.
excelempresas.com
Excel práctico para empresas: BUSCARV en varias hojas de Excel
http://www.excelempresas.com/2013/02/buscarv-en-varias-hojas-de-excel.html
Excel práctico para empresas. Excel, Macros, Funciones, intercambio de ideas, administración, empresas. Martes, 26 de febrero de 2013. BUSCARV en varias hojas de Excel. Excelente post del sitio http:/ exceltotal.com/. Rodrigo Lorenzo García Apeceche. Enviar por correo electrónico. Publicar un comentario en la entrada. Suscribirse a: Enviar comentarios (Atom). Hojas en Excel Blogspot. Code For Excel and Outlook. Busqueda en una matriz. Comparar dos listas en Excel. Extraer número de legajo.
excelempresas.com
Excel práctico para empresas: Obtener días de la semana en Excel.
http://www.excelempresas.com/2013/11/obtener-dias-de-la-semana-en-excel.html
Excel práctico para empresas. Excel, Macros, Funciones, intercambio de ideas, administración, empresas. Viernes, 15 de noviembre de 2013. Obtener días de la semana en Excel. En el sitio Excel Total encontramos estos tips con varias maneras de obtener el día de la semana (lunes, martes, . , viernes.) dada una fecha determinada. Lo útil es que ofrece varias alternativas con lo que se puede adaptar a los requerimientos de distintos usuarios. Recomendado! Rodrigo Lorenzo García Apeceche. Tips y Trucos Excel.