I am working with a meteorology professor. If you are not a weather
person, please don't stop reading! The data he's collected is
analogous to all sort of other data I'm sure. Here is a sample:
Wind Speed    Solar Radiation

I do many Vlookups and I copy this formula over 20 columns. Can the
Col_Index_num increment automatically. Currently I have to modify each
cell.

Hoping that there is someone out there that has seen this issue because I am
in a real pickle with e-mails, calenders and tasks that may have been
corrupted.  So here is some background
Computer: Dell Inspiron 6400 Laptop

My workbook has several sheets.  One of them doesn't allow me to add
or delete rows.  This means when I right-click on a row,  the
"insert", "delete", "clear content" is grey out.
This only happens to this sheet, as the other ones don't have such

I have been asked to put a timesheet togther for wafes caluulation in a
small business.  There are night shifts involved and whilst i can get one
column to subtract from the adjacent column (start time / finish time) i
cannot make it do it when the start time is say 19:00 hours ...

When a user opens a excel spreadsheet I need a dialog box to open to ask the
user to fill in the box with today's date and then that information is
transferred into a cell. Can anyone explain how this can be done.
I'm using excel 2003.

I have been seething and searching in 'super' frustration at MS
recently. I need to copy worksheets (within a workbook) with numerous
equations and charts, all referenced within the sheet itself, and to
no other sheet.

Excel 2003. File on server 2003.  Shared file.
Occasionally the file loses its brains and thinks it's in use by a user who
isn't in it. Then other users can't get in it. Is there a fast way to fix
this without rebooting my server? (which does fix it)

In Excel 2003, I'm having an odd problem.  I built the spreadsheet myself,
and didn't do anything funny, as far as I know.  The numbers consist of
dollars and cents, and I'm doing nothing more than adding and subtracting.  
I'm subtracting two numbers that look identical in the ...

I have to copy the sum formula from one column to the next
I used (the range of second coloumn)=range of first column.formula
The reason is I would like to roll forward the formula of month to
another month

I have a summary table looking at rows in another table
i.e.
=a13,=a14,=a15 etc etc
When the corresponding cells are empty I am left with blank rows on my

I am attempting to write a formula using the countif function.  The
formula needs to evaluate a list of ages and determine the quantity
meeting the range and a certain race.  For example, column a has a
list of ages and column b has the letter b or w, denoting black or

I have a formula in a sheet
=IF(OR(A36="",A36<=0),"",VLOOKUP(A36,'CoO table'!$B$6:$G$999,5,0))
this returns a blank if a 0 or blank is in the corresponding cell and
does a VLOOKUP routine if other.

I'm finding this challenge, well, challenging...I want to borrow funds from
my 401(k), and the basic parameters are:
1) interest rate is 7%
2) loan period is 5 years

When I open a file (.xls)  it automatically opens in Excel 2007. How can I
force it to open in Excel 2003?
Sandy