You are here:

Excel/Expert Profile

Jerry Beaucaire

U.S.

Available

Expertise

Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files

Experience in the area

Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files ===================== I have been offering free assistance as an Excel aid on many web sites for many years: (http://www.excelforum.com - JBeaucaire) ======== (http://www.askmehelpdesk.com/spreadsheets - JBeaucaire) ======= (http://www.mrexcel.com/forum - jbeaucaire)

Education/Credentials

Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors

Microsoft Excel MVP 2010

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
Rachael	05/22/13	10	10	10
Andy	04/17/13	10	10	10	Thank you so very much for your .....
roy	04/15/13	10	10	10	Thank you. But they are not merged .....
Parantapkumar	04/12/13	10	10	10	Run time Error 1004. No cells were .....
Prashant S Akerkar	04/09/13	10	10	10	Dear Jerry Thank you. Thanks & Regards .....

Recent Answers from Jerry Beaucaire

2013-05-17 macro:

If all the data were stored in a single database sheet, then it would be simple to extract reports from that data in any way you want.. by employee/daterange, by departments, by $ values. Once you start

2013-05-10 percetage amount:

If your value has an extra 10% added in, that means there are 11 parts to that number. 10 parts = the 100% original value, then 1 part that is the 10%. So if this value is in A1, to get the original

2013-05-07 Excel formula criteria for SUMIFS statement:

I would suggest the third criterion be a cell and that cell be a date that is formatted exactly the same as the column I values. If that doesn't work for some reason, I'd suspect the dates might not

2013-04-19 Macro to Auto Sum & Auto Print Unique Values:

My friend, Brevity can read harshly, can't it? I'll be more verbal in this message. It's is a known truth that many times the answer to one's own questions are revealed when a well-worded question

2013-04-18 Macro to Auto Sum & Auto Print Unique Values:

The line of code with the word COPY in it is the clue. The second half indicates the target: ws.Range("A" & TitleRow & ":A" & LR).EntireRow.Copy _ Sheets(MyArr(Itm) & "").Range("A1")

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

Browse Answers: