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: https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/files

Experience in the area

Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: https://sites.google.com/a/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
Roman	05/25/12	8	3	6
ngr	05/23/12	10	10	10	ok. Thanks. Cheers, ngr.
ngr	05/22/12	10	10	10	Perfect. The error was lack of spece .....
ALBERT	05/22/12	10	10	10
ngr	05/22/12	10	10	10	Great. Though i expect a day before .....

Recent Answers from Jerry Beaucaire

2012-05-24 Data update in other file:

1) The data exists on sheet1 of the workbook that has this macro in it? 2) The macro must copy M3:M16 of this workbook's sheet1? 3) The macro must take the value in Q7 of sheet2 to open a second workbook

2012-05-22 Command button creation:

there is no ONACTION property for OLEObjects. you will have to actually turn on a reference to the Microsoft Visual Basic for Applications Extensibility library, then that will allow you to actually create

2012-05-17 How does one auto-populate multiple sheets?:

Recommend that you think of the data on your hidden sheets as a database. As much like info should be stored on one sheet as possible with a "key" piece of information in a specific column that can be

2012-05-17 automatic updating:

The code given does work. When you run it, it will delete all the current data from the sheets listed by name in the array. Then your other macro will, when you run it, will parse out all the data

2012-05-16 automatic updating:

The code you have is good. Just add another macro to "delete" the current data on your other worksheets before this code puts out the "updated" data to the same sheets. Sub ClearData() Dim ws As Worksheets

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: