I'm trying to get a very simple DATADIF formula to work.  I subtracted the
start date from the end date of each employee to get the total number of days
they were employed.  This works fine for dates after 1900, but anything from
the 1700 or 1800's results in a value error.  Is ...

I protected my worksheet with only B1 to be editable.  In B1 I created
datavalidation|list.  What i want is to use Keyboard ie. arrow keys instead
of mouse.  Is it possible.   My worksheet contains Worksheet_change macro.
Thanks to all

I need to gather some info regarding our vehicle maintenance.
I have a worksheet which include the following details under seven columns
and details will be keyed in when vehicle sent for servicing.
A1, B1, C1, D1, E1, F1, G1,

I need to create a macro that can insert sheets from 01DEC to 31DEC
Each Sheet should be named with each day.
Thanks
JPG

I am trying to do a macro wich works with sumif in a range selected and
after that look for the next active cell, select the range and work again
with the sumif formula.
This is what I have so far:

how to filter a column that some cells are numbers, some cells are English
word, some cells content non-English word. thank you

the content automatically update?

MyList has has several columns showing the stock codes, their closing
prices, etc. The macro program I use runs down MyList and checks off
the codes line by line against the ExchangeList. If the codes are
found, indicating there were trading for them, it then updates the

example (this would be in column f)
=SUM(c1*1230+(d1*234)+(e2*567)
ok for each row I am having to input each cell number.  Is there a way to
make it so that the formula in column f would know to use the numbers in

Does anyone know how to fix this error short of reformatting and starting
over?

I am creating a quote sheet in excel that will need to be filled out quickly
while on the phone with my customers. There is basic info that will be needed
for each quote. The first thing will be the customer name. What would be the
best way to set up a cell to auto select from a ...

Friends,
While i am trying to hide the columns in excel worksheet, i am getting the
pop up message "Cannot shift objects off sheet" due to which i can't hide the
columns.

We have an excel spread sheet that has one column which contains zip codes.
About 60% of them are Zip +4 but the rest of them are only 5 digit zip codes.
When we want them to sort so they sort by the first five digits only.  It
would be nice if the next 4 were in ascending order ...

How do I get the default workbook page to come up without the Help/Task
Pane?
Dave

I have a PivotTable with a list of projects and the monthly cost for each
project. At the bottom of the table is several rows of non-project costs.
For example:
Project ID    Jan     Feb     March   etc. SubTotals