My data is two values
Day           Monday
Date                  May 8, 2008
The new result it

I am currently trying to generate a table to add up all payments due to
suppliers per month, using the function  "DSUM('PAYMENT
DUE'!$B$4:$I$1073,"PAYMENT DUE",A36:C38)", with 'A36:C38' in this example
containing the criteria determining the month in which the payment is due,

Can someone tell me if you can use the CTRL drag options to keep the same
cell contents when copying, but also keep various fill colors?

How do i collapse and expand data without adding or doing any mathematical
formulae? for example:
- Countries    
Nigeria          10

I need for one cell to use the formula inputted on another cell under a
certain condition.
Here is the 1st formula:
=IF(AND($C$6=75%),'Dept acc'!H69,IF(AND($C$6=50%),'Dept

The dataset for the vllokup contains many rows with the same reference:  Ex
Coupon   #             Transaction                  Sales
1                          5                                $ 10
2                          7                                  $3

I am trying to identify if there is a way of having a worksheet unprotected
but preventing a cell from being edited (using the 'F2' button or simply
typing into it) if there is a formulae in it ('=' in the first character).
I can see how to check after the change has been made  ...

How do you turn off the long references when you linked to Pivot table cell?

Is there anyway, using a formula, to return an array of unique values
extracted from a larger array that has duplicate values.  The resulting
array would be used for further calculations in the rest of the formula?
Likewise, is there anyway to use the values (true, false) in one ...

I need to sort a daily Excel Sales Tracker with columns (Name, Customers,
Sales, Sales Value, Average Sale, Sale Conversion)  into Sheets per name for
the month.  
Example Each page report has Employee A, B, C, D (175 of them) per day going

Can someone please let me know if there is a way to copy cell contents with
the cell drag and drop option without it increasing the value, but copy what
was in the contents i.e. "F2" in fields A1 through A12. and not F2 in field
A1 F3 in filed A2.

To setup the scenario, I have 10 doctors from 15 clinics being tracked on one
spreadsheet.  There are three columns I want to count from: Doctor, Clinic,
Gender. I would like to create logic statement to count the total number of
patients a specific doctor sees in relation to a ...

This is a fun place.  I've posted two questions and have gotten timely and
amazing answers to both.  Thank you.  I'll be back.
Respectfully,
Bob Myers

Please help,
I am trying to enter a formula that will find whatever is typed in within
selected cells.
Example: I want the user to be able to type a name or number into a cell and

sorry for my ignorance.  However, below is what I have so far....where would
you suggest putting the code below and do I need to replace any of the words
in the code below with a reference to my existing code?
Sub ClearContents()