I have column A populated with Stock Market trading dates in ascending
order. Dates ignore weekends and holidays.
eg
Col A

Suppose that one has a list with a field containing dates. Can the
automatic filter be used to filter all records whose date is in March?
With the advanced filter it is easy to do that with the function MONTH.
However, I suspect that the automatic filter is not useful here.

Is there any way to change the look of the active cell. ie have a re
border round it or the fill be in colour
--
grahamma

I have a problem of using named ranges.
Replicate the problem.
Create a name, say. "Test", which refers to
"=Sheet1!$A$1,Sheet2!$B$2,Sheet3!$C$3".

I have information in Excel that I want to use for a label. I copied it to
Word and have tried to copy it to a label in word but it does not transpose
in the same text. Is this possible to do? Or is there somewhere else besides
word that I could make the label?

For each of 10 items, I have input from three people, for example:
1 Bob
1 Rob
1 Cob

I'm experiencing an interesting problem with my excel since a few days
ago.
By default when you want to save a document with another name in Excel,
then after you select save as, Excel wants to save it in the same

If I have one cell - d32, and when the value becomes negative I want cell E32
to say "Over Budget", would this be possible?

I haave a drop down list which is in a table. When I change the selection (on
the list) I want another cell in my "price column" to change value with it.
Is this possible?

Help, my cursor or pointer turned to a black square - does anyone know
why or how to fix this? Thanks.

I want to RANK students' position in class according to their "Total Mark"
in Column AN.
I use the following formula to do the ranking.
=RANK($AN$7:$AN$56,$AN$7:$AN$56)

HI, I am new to excel and this group so treat me kindly :-)
I want to add some VB code to transfer the cell location on one sheet to
another.
That is on sheet1 in cell A1 via VB code I want to insert in that cell

I developped some Excel XP macros in vbscript. Now it's time to deploy them
to a unique client (only one computer). Those macros are made to be executed
in many excel files, then for maintenance purpose it would be nice not to
repeat those macros in each file. What are the ...

I am trying to get the sum of hrs worked using hr:min:sec format.  My cell
is formatted for time.  After entering for example 8:40:51, 8:06:35 and
8:18:35  I enter the formula for example =SUM(A1:A3). I get a sum of
1:06:01. I was expecting a sum of 25:06:01.  What am I doing ...

I'm working on and have been forever a quote sheet. Many of the values
change based on certain criteria.  I have a disclaimer sentence at the
bottom of the page and I would to have it set up that when I change the
criteria in the work sheets it would also change it in the sentence.  ...