I have a dependent list of 4 levels: Dept, Office, Division, Branch.
Each selection starting with department will provide lists based on
the previous selection.  This is perfectly straightforward and
functions flawlessly.  I am using named ranges and then using the

I try to get this formula or someting like it to work.
     =SUMPRODUCT((M17:M1115="245-B")*(R17:R1115="Not OK")*(H17:H1115=F2))
The problem is in  the H-Column. It contains Dates and times like for
instance 26-04-2007 11:36:34

i am opening the file that "has" macros, so excel asks i want to enable,
disable, etc, but i cannot see it on the list of macros (Tools -> Macro ->
Macros..., or Alt-F8). it is blank... how should i check/delete the macros
that are hidden somehow so i dont' get this annoying ...

I feel stupid asking this but there is a point. How can I type content
in one cell and it comes up in another cell without the 0 showing up.
e.g  If I type something in A1 to be copyed to C3 I would type in C3
"=A1" right... But then this 0 pops up. I just want it blank in the

i have a sheet with 1000 row but some of row is repeated and i want delete
repeaterd row
for example one of row reapeated 4 times and i want keep one of them and
delete  others

Here is an example of a report I run every month, What I do is once I get the
Data Listed Below, I add in the 1-5, 6-12, & the 13+ columns, Then I Sort the
Data by RESPAR then by DAYS, then I manually Count the Days 1-5 to get a
Count of Days between 0 & 5 days, then the same for ...

I would like to copy data from one worksheet to another but every time I do
that, I need the data highlighted to show it has been copied. Is there a way
of doing this automatically?

I am keeping a list of account numbers and sort codes, but every time i type
a number beginning with a 0 it is auto removed!!

Gaurav Raveshia, Jim Thomlinson and Dave Peterson (Thank you!) helped
me to use the INDIRECT function in order to use the contents of a cell
as part of a reference to another cell:
=INDIRECT("'" & A2 & "'!C7")

I have a text box with the default date in ("dd/mm/yyyy") format.
The user can then type over this date or leave it alone, and exits the text
box by means of the TAB key.
Within the exit code all the date validation takes place (See below).

Is there a way in excel where I have 10 questions and can click on one
question and get the answer to pop up in my spreadsheet?
thank you,
Felicia

I've been trying to fiqure out how to have other's make and save changes to
my exsiting excel document that I have created?

I have never had the need for this, but I am trying to help my wife at
work. Whenever we go on the menu, this command is "grayed out". Same
at work and at home, so that tells me we are simply missing something
obvious. Does anyone know what we need to do? Thanks.

A friend is organizing a secret present interchange and I need a formula
that would tell me who gives who but duplicates not allowed. I tried using
randombetween but I get dups. How can YOu do it  ? Also CAn I have
exceptions like guy A never gives to guy C ?

Being new to Excell
I am trying to transfer a range of e mail address from Excell to M/Soft
Outlook address book
I have tried to name my list of selections but not having any luck at