# 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

This expert accepts donations:

### Recent Reviews from Users

K = Knowledgeability    C = Clarity of Response    P = Politeness
Rachael05/22/13101010
Andy04/17/13101010Thank you so very much for your .....
roy 04/15/13101010Thank you. But they are not merged .....
Parantapkumar04/12/13101010Run time Error 1004. No cells were .....
Prashant S Akerkar04/09/13101010Dear 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")