You are here:

Excel/Expert Profile

Bob Umlas

U.S.

Available

Expertise

I`m a Microsoft Excel MVP (Most Valuable Professional) and have been since the inception of the program in 1995. I can answer every kind of Excel question except: API, Importing/exporting to other programs (powerpoint, word,...)

Experience in the area

Worked with MS Excel since version 0.99 (on the Mac!). Was contributing editor to Excellence Magazine, having written >300 articles. John Walkenbach said of me "I finally met someone who knows as much about Excel as I do."

Publications

Excellence, The Expert, Microsoft

Awards and Honors

MVP
Led sessions for the Convergence 2004-2006 seminar on Excel tips & tricks

What do you still hope to achieve/learn in this field?

XML

Something interesting about this subject that others may not know:

See my book, This isn't Excel, it's Magic! at http://www.iil.com/iil/excelmagic

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Nicholas	02/09/12	10	10	10	Great. Thanks
Eduardo	02/08/12	10	10	10
Jayendran	02/08/12	10	10	10	Superb!!!!
Shawn	02/07/12	10	10	10	Absolutely awesome. Quick response and accurate. Thanks .....
Carry	02/07/12	10	10	10	Thank you Bob, the macro works just .....

Recent Answers from Bob Umlas

2012-02-08 Number to Words:

Right-click the sheet tab, select View Code, enter this: Private Sub Worksheet_Change(ByVal Target As Range) Dim Ch As String * 1, Ans As String If Not IsNumeric(Target.Value) Then Exit Sub

2012-02-07 Macro to sort columns:

Sub Shawn() Range("A:C,F:F,J:K").Copy Worksheets.Add.Name="ENTER NEW NAME HERE" '<====answer #2 Activewindow.Pagesetup.Orientation = xlLandscape '<====answer #1 ActiveSheet.Pastespecial

2012-02-07 Conditional Format:

Can easily be done with conditional formatting. If you don't know how to do that, it's pretty hard to explain without a physical workbook -- send one (or a sample with not so many rows) and I'll be able

2012-02-07 Macro to sort columns:

This macro assumes you want to copu columns A:C,F,J:K -- adjust to suit. It will put them together, so the original 6 columns copied will be in A:F Also assumes the print area will be A1:F50 (arbitrary)

2012-02-04 Copy values from non-adjacent cells to a new workbook:

Sub MyVersion() For each x in Array("A1","B2","C3","D4","E5") sheets("Sheet1").Range(x).value = Sheets("Sheet2").Range(x).Value Next End Sub If that gives an error, then you either don't

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Encyclopedia

Browse Answers: