How does one locate the cell in which the MAX number appears?

I have a workbook with several worksheets. Each worksheet is an numbered
invoice. As I add worksheets, is it possible to have the invoice number
automatically displayed in consecutive order?

Any help with this is greatly appreciated.
Bob was graceous enough to provide the vba script below, however I now need
to make a minor change in it. It extracts part of a string in column A1 and
puts the results after the last row in col B. I have approx 200 rows that do

Does anyone know of an easy way to do calculations with feet and inches?
Are there routines for adding and subtracting, converting feet & inches to
decimal feet, decimal feet to feet & inches.
Thanks for any help,

I need some help (obviously).  I have a calculation that gives me a
total number of hours between two dates and times (ex. 11:30 hours)
This is all fine.  I need to convert that "summed" cell into a decimal
value (i.e. 11.5) to be able to use it as a divisor for another cell to

I need to make four sets of three otion buttons. Xcel help is not very
helpfull as to how to use the group box.
Thanks Brujolito

I am using Office 2003 Professional on Windows Media Center
I just did a complete System restore on my computer for other reasons,
and now that I am re-installing Office, I am not able to access any
controls. In other words, I cannot edit any document, because the

I have a bunch of names defined on my worksheet.  When entering a formula,
I'd like to be able to see a list of the defined names, and select a name
from the dropdown list.   For example, when entering SUM(Sales, Commissions),
I'd like to be able to select Sales and Commissions ...

XL 2002 SP3
Win XP HE SP1
*Follow-up to: microsoft.public.excel*
hi,

Not being an experienced user of Excel, I have a problem thats drivin
me crazy.  I have built a budget sheet which shows total spending fo
the month.  The next cell shows the expected spending for the month.
The third cell will show the difference between the other two.  Th

I have a list of integer numbers in a single column. They are in no
particular order, and I cannot sort them (it would upset the rest of the
spreadsheet). Some of the integers are repeated more than once, & I want to
increase the repeats by 1, then 2, 3 ... so that I end up with a ...

I wrote this code in the General Declaration part of my Excel workbook (in
the VB environment):
Public Function jvdADD(Word1, Word2)
   jvdADD = Word1 & Word2

Good morning,
I am fairly new to this, have been using 2003 a little, but keep hitting
blocks that I don't know how to handle, can you recomend any good books that
offer a tutorial to work through, from beginning to advance, thx in advance

In my daily job, I need to flash some new data into my excel and use the
excel result to send out mails to report daily result. Is all numbers I need
to report in mails. Wonder if you can tell me if there is any tools to make
the data into text on my outllook.

everyday I enter the cheques we receive and all the relevant info about the
including what department bill it was to pay
I need to find a way create a Totals for the month" sheet, table, something
but I want it to be updated as I add the info to the daily worksheets