Excel/Expert Profile


Ask A Question

Expertise

I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards

Experience in the area

My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

Education/Credentials

I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Chris11/08/0910101010Thank you Aidan for your quick and .....
Joe11/07/0910101010Very helpful, answered questions other Volunteers could .....
Adrian11/07/0910101010 
Adnan11/07/0910101010It is working good. Thanks
JAYE11/06/0910101010 

Recent Answers from Aidan Heritage

2009-11-07 VBA Formula:

use the CHANGE event of the worksheet to handle the macro (vba editor, click the worksheet, change the dropdown from GENERAL to Worksheet - you should the see the change event. It is possible to restrict

2009-11-07 Insertion point:

technically none of them as it needs round not square brackets, also not a method I use myself, but a simple process of trial and error would reveal the answer - I mention this to help wih future assignments

2009-11-07 Error with looping macros:

There isn't a limit for looping as such, but there IS a limit for variables - you haven't included any DIM statements but possibly one of the variables is declared as an integer which has a maximum size

2009-11-06 VBA Formula:

As a function, it should have something stored in a variable called FF, and to VB you have a lot of undeclared variables - which SEEM to relate to fixed cells - so I THINK this should be a macro - but

2009-11-06 Cross Referencing with Conditions:

I think it's PROBABLY easiest to do it with a combination of a COUNTIF worksheet function - this would count the name on the contact sheet against all entries on the graduation sheet - so you would get

 

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

All Answers

Answers by Expert:


Ask Experts

Volunteer


©2009 About.com, a part of The New York Times Company. All rights reserved.