I would be grateful for some help in setting out of a formula.
I have two worksheets within a spreadsheet (Excel 2000) that I want to
be able to use to record discipline actions given to pupils in a
school.

if i have a spreadsheet pulling in various numbers from another spreadsheet
which is named by dates i.e excel_06_14_06 is todays how do i get my
spreadsheet to update each various component by one day....
i.e cell g7 =excel_06_14_06(f6) how do i get it to udate tomorrow for

I am using Pivot Tables in Excel.  I am trying to group my data (which I can
do), but the Grouping dialogue box does not appear. It just groups the data -
creating a another field (column) with the grouping.  I would like to specify
the grouping range and not have to do it ...

I want to count percentages in a range of cells that are not contiques. I
have named the involved cells. When I use =countif(Janmon,">=85%") it returns
#Value.
For example the range would be D15:Q25 then D25:Q35. It's name is Janmon.

I am trying to figure out how to average a set of seconds to be used in a
graphing.  Here is the data I have.
Date           ID          Time
May-05    4223    :40

I have this chart where I need to combine the contents of 2 cells - A & C -
But if A is alphabetic I need it to combine B & D instead. Any good ideas?
A              B              C                 D              
WC1    406    20062442      93082813   

I am new to this so please be gentle:-)
Can someone help me,
I am trying to look for a value in one column in one sheet and when th
value is found to copy that row into another sheet

(this is Excel 2003)
We have a graph in BookA.
When I open BookA the format of the dates on the X axis are
01-Jan-2006.

I'm currently producing a league table for football in excel and
wanted to have column showing if a team has moved up, down or staye
the same position in the table, from the previous week.
I tried to use an IF function to say e.g. IF(A2>B2,"up","down) o

I need help to do the following thing:
1. Have a drop down list (e.g. Scenario 1, Scenario 2, Scenario 3)
2. When user select (e.g. Scenario 2) from the drop down list and click
on a "Go" Button, it will take the user to the cell that says Scenario

Sorry for cross post. This group seems to have more activity. Anyway....
Forget the values I have used in the simple example, they are there just to
show you what I need to work.
Using the code...

I want to populate a cell with a value from a pivot table on one of nine
sheets, depending on the value in another cell.  I have a list of names in a
column, each of which corresponds to a worksheet within that workbook.  
Depending on the name in that column, I want to get data ...

I am about to import data from an odbc data source into excel worksheet
using msquery. When I use a simple query from one table I can set up
parameters for the query, but when I build a query using multiple joined
tables / what I really need / the possibility of setting up a ...

I attempted to add rows in a pre-set transposed data table and was unable.  
The message shows "you cannot change part of array".  For those who have
answers, please kindly forward your advise to me, truly appreciate your help!
Regards,

I have a list of data that I wish to rank, but I do not want the gaps i
the ranking numbers created by duplicates in the data, ie.
Data       Rank Req
1                 1