I have a spreadsheet that I didnt create - and somewhere
it is requesting a link to another spreadsheet - but I
cannot find where.  The edit/links function only refers to
the destination file.  Im trying to delete the cell that

I'm a newbie when it comes to macros and VBA.  I'm modifying a workbook
that has all data in upper case.  The data I need to add to the sheet
must be in upper and lower case.  Reading through the archive didn't
come up with anything similiar.

I am adding every third line down a spreadsheet and I think I've done this
before...I have more than 30 cells I'm adding together.  How do I do it.
I'm sure it is easy but I can't remember how I did it.
Thanks so much for any help.

How do i count cells between a range, cells may have values or may be blank, i want to exclude cells with formulas in them, plus the range must be able to specify itself. e.g Count from cell marked S to cell mark T, Include blanks and exclude formulas

Good morning all,
Been working on this for about a week and have run out of ideas.
I have a column of data set numbers (currency), variable in value and
in length, let's say [A1:Ax] and a set extra value [B1]. I need to find

I am trying to create an equation that will allow Excel to
look at one cell and then make a calculation based on
whether there is one of three entries placed in that
cell.  Either it will be blank, have a '1', or have

What I am attempting to do is sort a column in my excel spreadsheet i
numeric order (descending).  I go to the Data Menu/Select Sort.  I
sorts the numbers, however, it sorts it in the following manner:
Ex:

I have been trying his for ages and cant seem to work it out.
I need a formula that sums on more than one condition. Sumif only
appears to include 1 criteria.
For example:

I'm creating a time sheet for which I do not want to have to manuall
enter the next days date, OK to start with a date but then use
formula to do the next cells sourcing from the previous cell.
To look something like this:

Win98se
Office 2000 pro'
My newbie layout in excel s/s:
A        B                 C        D    E

I have a work sheet which has a date column.
I want to use just m/d as the format with no year but excel 2003 is all
ways putting in the current year by its self.
I have set the cells as custom d/m but excell still puts in the current

If I have a list of employees and their hire dates, what
function would I use to determine if the employee has been
employed for at least 12 months?

I was wondering if anyone knew how to link named items in
a combo box to a list of numbers (i.e. each item in the
combo box relates to a list of say 15 numbers.) Each of
the names in the combo box would have different values for

First off, I am not an accounting pro or an Excel daily user so please adjust your answers accordingly
I keep a monthly expense sheet for my business based on the date of the expense not the vendor.  Headers are as follows
date   vendor   itemized item purchased    cost/item   item ...

I have an application that is used the track products by type. All related data to the pruduct is entered taking up one row and up to between 20 to 30 columns. The products are Column C and as follows: Horn, Switch, Resistor, Navigation, Headlights and so forth.
What I want to ...