I am not very sussed on the higher functionings of Excel so would appreciate
help with the following:
I have a lot of info to input into very wide table (about 50 columns which
fall under about 5 subheadings). This data will need to be sorted according

Hi Frank,
- BEFORE entering the formula in the data validation dialog, I?v
selected the cells from A1 to A25
- which values? well ... I?ve tried numbers (2,3, ..) just to certif

hello out there,
does anyone know in excel.
how do insert a row in a protected sheet without unprotecting the sheet.
i have a document where i do not want the formula to be touched in no

Sorry Frank,
But I made a mistake when posting the formula.
I?ve used the formula that you?ve mentioned, i.e.:
=COUNTIF($A$1:$A$25,A1)=1 ... & does not work  :confused:

I've done a vlookup but instead of the formula calculating, it just shows
what was typed in the formula bar in the cell on the spreadsheet. Why might
it do that? I've used vlookups lots of times before and don't see my error.

Can anyone help
Win 2000, Office 2000 - Office XP Professional
I had Excel 2000 running OK in office 2000 and had autosave enabled b
add-in.

I'm building a Database of UK Chart Singles.
This there a way of entering a number which
refers to the Last Week postion and Excel
fills in the rest from another List of

Thanks Frank ... but  :(
I?ve tried the following and does not work ...
On "Data Validation" I?ve set the following validation criteria:
Allow: Custom

My pivot table contains two fields I need grouped: "Fiscal Year" and
"Fiscal Month." Both field are numeric, not dates. The grouping would
be like this:
Fiscal Year (2003) and Fiscal Months (9-12)

I have a workbook that has multiple sheets with different information in each
sheet that needs to move to new results sheet contained in the same workbook.
I need to take the following cells c9 e9 g9 i9 c10 e10 etc from the all of
the

How can I save an excel SPREAD SHEET to a cd

2 Questions.
(1) I would like to set up the row so that ALL LETTERS in that ro
would become Capital letter auromatically.
(2) In the second row, I would like excel to capitalize the FIRS

What's the best way to enable a PivotTable to address a data set containing
more than 65, 536 rows of data?
My one stipulation is that I must be able to hide the source data from the
clients that are using the PivotTable. I've been able to do this to date by

How can you insert a enter in your MsgBox?
Fe.
---------------------------------------------------------------------------
  MsgBox prompt:="Please note, there a no files in this directory."

This is a request from a primary school headteacher and a good friend of
mine.
They use an excel sheet that shows the lesson plan for each teacher. Nothing
special on it. But lately they needed some summerizing figures on the