I have 31 cases. from 1 to 31 and i need to optimize the following code. how
do i do it either using for stmt or other loops
Select Case (x)
              Case 1:

Excell document is overlayed by an exact dupelicate. How can I delete it ?

I have a list of dates just over 1000 lines long.  Dates range from
01/01/1993 to 12/31/2003.  When I attempt to convert the column from
01/01/1993 to January 1, 1993 only some of them (about 30) will convert.  The
rest don't change at all.  I've tried going to other formats and ...

I can't make sense of this and I need help see the error.
I have defined two dynamic names.
NewCall uses =OFFSET(Data!$AB$3,0,0,COUNTA(Data!$AB:$AB),1)
ExistingCall uses =OFFSET(Data!$AC$3,0,0,COUNTA(Data!$AC:$AC),1)

I need help with a formula (not necessarily "IF") which will help me display
the following results:
Analyst    Remarks
A    ON PROBATION

Hi, I had to take out of my file a lot of cells and therefore my
formula now looks like this:
=con7!K8+con8!K8+#REF!K71+con10!K8+#REF!K71
I need a macro that removes all #REF!*** so that it can calculate the

I'm using MS Excel 2003 on Win XP.  I have a very large file and when
I open it I only see 65,536 rows.  I want to save it to CSV (text) but
I'm afraid if I do "Save As..." I'll only be saving out the first
65,536 rows.

If I want one cell to display the contents of another cell based on a value
input in a third cell, I am unable to get it done.
If cell  A1 is the input cell, and I type in 25, I would like cell A100 to
display the value of cell A25.

please help

I need a table which reflects the total number of cases each analyst has in a
column, and the total amount of fee each analyst has achieved in a column
next to it. How can I do that?
Case Number    Fee    Analyst

Its that time of year when i need to work the teams annual leave entitlement
and i was wondering if i could set up an excel template to do this.

I currently have two columns:
Column A is Countries
Column B is Cities associated with those countries in Column A
I have the data validation set up so that when you select Australia, for

I am trying to create a project reporting report in excel, should be easy
for my group to understand the report without any problems.  I have searched
a lot all over but can't find any resource.  Is there any templates that
explains clearly on how to establigh project plan in ...

I am trying to compare two columns in two different worksheets.  If the cell
in column model and serial  worksheet #2 matches the cell in column Model and
serial worksheet #1, then I want to pull data from column A, B, C, and D from
worksheet #1 into a separate sheet.  Help ...

I have an excel file that started off at about 143K.
It is an employee appraisal form, and it needed a redesign, with the
constraint that it stay in excel (argh).
Anyway, each question was moved to a separate tab, so that I have 8