You are here:

Excel/Expert Profile

Bob Umlas

U.S.

On Vacation
returns 11/08/2009

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	T	P	Comments
vrunda	11/05/09	10	10	10	10	Thanx bob... but there is some Prob .....
Sami	11/04/09	10	10	10	10	Thanks bob for your kind responds. i .....
SURANJANA	11/03/09	9	8	10	10	Hi, Thanks for Your reply.It is .....
chris	11/02/09	10	10	10	10	Thankyou! Works great! Chris
Gary	10/29/09	10	10	10	10	Hi Bob, Yes... Finally it did work .....

Recent Answers from Bob Umlas

2009-11-03 follow up que..:

Sub vrunda() Dim N As Integer, M As Integer On Error Resume Next For each SH in array("Sale","Tax","Retail") For i = 2 To Sheets("Soda").Range("B50000").End(xlUp).Row M = 1 orderno

2009-11-03 How to four columns where data is in Credit:

I don't understand - can you give what this would look like AFTER said sort? Are you saying you want a normal sort by column 1, then each row sorted by the 4 columns so the result is Col 1 Col 2

2009-11-03 follow up que..:

1 - I didn't (don't) keep previous solutions, so I don't have any macro to modify 2 - I get TONS of email from allexperts so I have no recollection of this issue or solution 3 - I don't understand what

2009-11-03 Macro to sort position based on a list:

Sorry, but I have no idea what you're saying - first, what does it mean to "remove or set a cross mark"? Second, the image is way too small to be useful to me, third, I don't understand "...area code 88298

2009-11-01 Macro:

Sub InsertVac() Dim n as Long Set WB2=Workbooks("WB2.xls").Sheets(1) Set WB1=Workbooks("WB1.xls").Sheets(1) On Error Resume Next For i=1 to WB2.range("F65536").end(xlup).row

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: