I am creating an expense worksheet for sales reps.  Beginning and ending
mileage for company cars are entered each week.  Is there a way that Excel
can "flag" me once a vehicle reaches a certain mileage, i.e. 40,000 miles ???

Let me begin by saying I'm not a programmer (any more), I'm a Spanish
interpreter at a Court. I have done all of the following using the "macro
record" and "customize toolbar" features from the Excel menus - I do not do
any VB programming.

I have software that creates a data dump of a bunch of information; pivot
tables work great for helping us sort information.  Our customer has seen and
now requested similar reports.  The pop down feature makes it nice to isolate
a particular group or all of them.  

Our little cabana club uses Excel for our a photo id system.  Each member
household has a folder that contains photos for their family members.  One
column of the spreadsheet contains a hyperlink to each folder.  i am trying
to do something that requires me to know which folders ...

is there a formula for displaying the last non-empty cell or the last used
cell in a column or row? if there is kindly notify me at
donald_dick13@yahoo.com. i needed it badly.

I have  a row of 5 cells. I want to format them so that when two of the 5
cells are >0 the whole set of cells change color. I used the countif function
to do this and it works fine.
I now want to copy this conditional format for all 5 cells down the other 50

I am in need of some help or guidance with a spread sheet I am making that
will subtract and add daily #2 Fuel oil usage for my plant. I can not seem to
come up with a formula that will add gallons and inches of fuel back in to
the row should I receive a oil delivery during the ...

How can you find the compatibility issues with a prior verison of excell when
using excell 2007 particularly formulas linked to closed workbooks

My formula is =LEN(A1) and copied down.
Is there a variation of this formula to count just the letters in each cell
without counting the spaces between words ?
Thanks for the reply.

How do I copy the content of multiple cell in excel.
(instead of entering the edit line of every cell, copy the text and pasting)

I want to run a macro only:
if Field E10 = "WO ID" and AB10 = "Spec Sizing"
if field are different then it must show a message saying that the file is
not the correct one.

Below is a macro I am testing.  I am trying to create 26 command buttons,
starting with Commandbutton6, but a caption starting with number 1.  
Something is wrong with the "Activesheet.OLEObject" line and I don't know
what.

I have a =sum formula:
=SUM('C:\Documents and Settings\Andrew\Desktop\CHK2
minaturisation\[03_Dec07_0243.txt]03_Dec07_0243'!$B$119:$M$126)
that totals the values of an 12 by 8 range.

=FIND("/",C30)
If the above formula does not find the slash #VALUE! is returned. How do I
eliminate that result and obtain a number?
I am attempting to setup a telephone directory for a condominium

I am created a file to keep track of marks.  I want every other line to have
the back ground fill in.  Sometimes students names will be added or deleted.  
I don't want to have to change the format for each line when a student is
added or deleted.  Is there a way to do this?