I have to convert Excel worksheets into format readable by Access. My only
problem now is between the two worksheets. When pulling data from one, using
formulas, when there is a blank instead of a number the spreadsheet pulling
the data places a "0" instead of leaving blank. I ...

Not sure to go about this.
I need a formula that states....
If in the range of A1:A1424 there is "Baltimore" AND if in the range of
D1:D1424 there is "physician"......then add the contents of the cell in that

The following snippet of code is suppose to loop through all the
CommandButton controls on a Multipage control on a form and change the
Enabled property of those CommandButton to True if there is a Value in the
ComboBox "cmbDrive". Otherwise the CommadButton controls should be ...

I have a workbook that I open in the morning and leave open all day.  I
always open the original copy, not a read-only version.  However, in the
middle of the day I tried to save the workbook and it asked me if I wanted to
save a copy, as if my version suddenly became read only.  ...

Can anyone tell me what is wrong with this code. I keep getting "Object
doesn't support this property or method" error message and I can't figure out
wish object.
If TypeName(ctl) = "TextBox" And Left(ctl.Text, 2) = cmbDrive.Text Then

I am having problems sorting my spreadsheet, I have never seen Excel act like
this before.  I have a spreadsheet listing Building and Department Name.  I
want to sort by building then Department name.
Excel is keeping the buildings together East and West but the Department

If someone is staying in a hotel for two nights @ €80 per night.I go
=sum(d4*f4)enter and get €160 how do i then give a 10% discount ?.

I am a teacher needing help sorting a list of student's names alphabetically,
but I want to keep the information that is in line horizontally with the
student's name.
If I just hi-light the names and click sort, it only sorts those names, and

All -
I am using the following formula:
=OFFSET('Sheet 1'!A2,MATCH(C8,'Sheet 1'!A3:A229,0),MATCH(E4,'Sheet 1'!
B1:IV1,0))

Can we have a combination chart of colume type with a stacke column? Would
anyone please let me know how this could be done? Everytime when I change the
chart type, the whole chart (Three columes) change to one stacked colume, how
can I have one colume and one stacked ...

I have three rows of financial (three scenarios) data for 5 years. I would
like to compare a chart of column for first scenarios vs. a stack column(for
the total of second scenario and third scenario together). I know I need to
set up a combination chart...can anyone explain to ...

I am trying to create a pivot table by importing data from an external
source. It is essentially a list of thousands of products and their
respective prices. However, when I try to add the column 'products', I
receive an error message that states: "A field in your data has more ...

I am running Microsoft Excel 2007 (Office 2007 Business) with XP Pro
When I open an Excel 2007 workbook....the bottom left indicates.........
"Running Virus Scan"
This results in the Workbook taking a long time to open.

Howdy,
I use a database that contains an id field that is a 5 letter "code".  So
the first item in the database is AAAAA, the second is AAAAB, the third is
AAAAC and so on until item 26 is AAAAZ.  Item 27 is AAABA, then 28 is AAABB,

Can Excel perform multiple selections from a drop down list? I know in HTML
you can hold down a key and select multiple items. Also, if it is the case
that Excel can do this, how would the relative values be stored in a cell?
Thanks