I am doing nested if statements but need to have more than 7 nested if
statements. What does one do to get more?
Formula is attached and it won't work and I think this is due to too many if
statements

I have an excel sheet with dates in a row of cells (example 06/14/2004)
when i click on the any cell with a date; as you know the data is also
displayed up in the formula bar. But the date up in the formula bar has
a ' before it. (example '06/24/2004). That doesn't show up on the

I get outputs from a program into a text files (*.lis) containing
values I am interested in and text I would like to erase (to create
graphs).  After converting the .lis file to an excel I get the file
where the data is organized in groups of rows such that each group has

I pasted in several worksheet pages into my current worksheet. I want to be
able to paste all pages into an overall view. However when I go into those
pages the
cursor turns into a pointed star and I cannot copy the data. Any ideas.

Hi all,,
Hope someone can help me with the following problem.
I would like to look up Column C for a specific value (i.e. 19) and then
sum the values in Column A that relates directly to the value of 19 in

How can I do the following with a macro?:
{Sheet 1}
Copy A1:Z10
Paste at A11

I have a cell that is a pick list of items from a column. Those items are
not values in themselves, but references to cells in various unpredictable
locations on other sheets in the workbook.
Example list column values:

I would like to count the Lottery position as a total per number .
Such as Sheet2 would have the base data:
Date                 1        2         3         4         5        6
12/22/2006     40      3        38       22       25     48

Hi again,
This is related to the question below.
Dave Peterson has kindly responded to that and it works.
Thanks, Dave.

I'vve have recieved from a friend falconer a sheet to hold the date of my
birds like dayly weight, training results, food given, prey taken ect.
Difference in weight between days. My problem is that I use metric values for
weight and the table is set up for imperial weight. I ...

Can anybody help me? When I created group ( menu "<Data>" -> " Group and
structure"=>"grouping") then the button "Detail" automatically positioned at
the bottom of the group, but I need this button on the top. How I can make
it?

I have a strange problem with one of my spreadshteets.  I am not able
to access or see any rows 1 to 31.  It is as if the "hide" function is
in effect.  I  have tried the "unhide" function, but no use.  It is as
if I am locked out of these rows!  I don't have any "freeze" function

Does anyone know if they have improved text handling in Excel 2007 -
things like word wrap and auto fit working for larger text amounts in a
cell, etc.?
Thanks!

As I am about to begin partaking in an exorbitant amount of adult beverages,
I would like to wish you all a great and prosperous NEW YEAR, since I don't
believe I will be able to see the keys for too much longer, so no use
fighting it.

I have undermentioned code in the Private Sub Worksheet_Change(ByVal
Target As Range)
If Not Intersect(Target, Me.Range("C07")) Is Nothing Then
 If Target.Count > 1 Then Exit Sub