Hi - I have a list of daily $Amounts for ea day of the year.
ie --Month-- --Date-- --Amount--
In a summary table, I extract the highest AMOUNT for a particular
month with {=MAX(IF(Month="Dec",'9am'!Amount))}

Is this possible?

I'd like to have specific cells change to a certain fill color when I type in
certain letters or numbers. Is there a way to set this up?
XP Pro
Thanks!

I'm trying to perform a lookup function
=LOOKUP(H8,sheet2!A:A,sheet2!C:C)
This formula only returns the first item of a list of items matching the
number in A:A  (there could be more than 10 under the catalogue number in

How do I format a cell to have a comma at the end of each number?
Thanks in advance,
Van
--

I currently have Windows XP on my computer and this contains the Microsft
Worksheet program.  I need to pull a file from a website that is in the .xls
(excel)extension, so what can I do to see that infromation?  The same thing
happens when I receive anything with .ppt ...

Is anyone using Course Technology Excel 2002 text book by parsons, Oja,
Ageloff and Carey?  I have a problem with one of the cases and really don't
know where to turn.  PLerase reply if you can help.

Is there anyway to make a cell reference in a formula be locked so that
it is not changed when copying the formula to other cells?
For example in cell E1 =sum(A1+B1+C1) and when it is copied to E2 it is
changed to =sum(A1+B1+C1). I want the reference to C1 to remain the same

Thanks, but that doesn't seem to work.  When I open the workbook file
it opens as a hidden file with multiple versions hidden.  I don't kno
how the file became hidden, or why multiple versions stay associate
with the file....but it's driving me crazy.  I'd like to have the fil

Good day,
I have a commandbutton placed in my workbook.
If you press the button sub MyDozen will be called.
Now I want this commandbutton to have two functions.

Dave, Thanks for responding.  I tried this but I could not get it t
work in conjunction with the entire module.  It dies right afte
copying and PasteSpecial Values  It does not kill the temp file or loa
the newly created sheet into an e-mail. Any Ideas

i am trying to make an invoice list. i would like it when i type in a product
or get it from a drop down list for the price of that particular item to show
in the collumn next to it.

I'm using Excel 97 on WINNT.
I use a number of toolbars linked to macros to perform a series o
functions I have automated. I have installed similar tool bars for man
of my colleagues.

I'm trying to use vba to replace all formula references to a particular
sheet with values. Can someone please point me in the right direction?
Thanks in advance
BW

When entering 2003 dates the day() feature works corrcetly.  However for 2004
it shows the wrong days.