I have a workbook to record employees mileage in company vehicles.
I have validated the mileage so that it is greater than the previous days,
but not greater than a later value.
Cell D19

I have a row of cells that will have the date (cell formatted for date)
and also a qty ordered cell. How often we make entries within a mont
will vary. I help in creating a formula that will produce the followin
results: Monthly Total of Qty Ordered, Monthly Average. Any tips on ho

In Excel 2002
After clicking on File/Send To/Mail Recipient (as Attachment)
You get the mail toolbar with the captions To, CC, Subject.
If you decide to get rid of this toolbar, how does one go about that.

I have a workbook with a number of named ranges.  I would like to list and
print the names and the assigned ranges.  Is there a good way of doing this?
--

Say I have a column containing dates as below:
               A                    B                  C
1    27 May 2003
2     03 Jun 2003

2 questions.
1) When referencing to cells, if you cut and paste, it will reorder the
references to match the moved cells.  Which if the cell you have moved the
data into is also Referenced then it casues a #REF error.  Is there anyway

I frequently need to take my spreadsheets with me in a PDA
and work on them using a package available in the market.
However, any macro and multi sheets are lost from the
spreadsheets and not avialble when it is opened on the

Does anyone know if you can change the actual color on the tabs of th
worksheets, I remember I could do this in Lotus 123.
I have several worksheets with 10 to 15 tabs and I want them toi stan
out

I have a database with two tables (class and book) that are joined by a link
table (class_book) such that a class has many books and the same book can be
used in many classes.
How might I go about pulling this data into Excel and showing the classes

While running VBA code on the .open event I get the
following error: Automation Error the specified procedure
could not be found.  -Z147024769.  Can you let me know
what causes this.

I have forgotten how to make a row static, so that when scrolling dow
the spreadsheet that certain header does not move
--
Message posted from http://www.ExcelForum.com

I'm BRAND-NEW, and wanting to design something that has drop down windows, and I want to have my values in these windows. I want to be able to pick from the values, and basicly weed out the other choices in this way. Is this possible? I am getting more fluent with excel, is it ...

Thanks to all for the SUPER informative answers on the questions!
I have found most solutions to the questions that make me chase coffee all day. But I have a new one.
I have created a spreadsheet , and included the drop down menus by using the data-validation-settings method I ...

I tried to open a 276K spreadsheet created in Excel 2002 sp2.
The spreadsheet will not open.  Hourglass stays on the screen
until I close Excel in Task Manager.
Any suggestion how I can open the spreadsheet?

i am trying to open a excel 2000 worksheet but it says the file i
corrupt , is there anyway i can open it
--
Message posted from http://www.ExcelForum.com