I would like to know how I can have an Invoice number change from say 7200 to
7201 after the doc is saved so I don't have to do it manually every time I
write an invoice.

ok heres what I have.
in cell D6 I have formula of =AVERAGE(D7:D10) which its at #div/0!
in cell D11                          = AVERAGE(D12:D15) which its at 85
in cell D16                          =AVERAGE(D17:D210) which its at 50

I have a number in column B of Worksheet A.  I'm trying to locate that same
number from Worksheet B, column A.  Once I have found corresponding numbers,
I want to pull the information from column C, Worksheet B into Column C
Worksheet A. And then repeat for mulitple rows.  Can ...

I'm trying to add the values in a column if the row includes two different
criteria:
2800650    1  30200028
2800650    1  30200028

Ok so I got help earlier with this situation:
Is there any way to format a column so that if any info is entered into a
cell then its highlighted but if there is no info then nothing happens
ex. (INFO BLAH BLAH) would be black text w gold background

I am using the follwoing code,
For rwIndex 4 to 100
If Month(Worksheets("Sheet1").Cells(rwIndex, 12).Value) > _
  Month(Mydate) Then .Interior.Color = RGB(255, 0, 0)

I've got a worksheet with some drop down boxes.  I would like for the chosen
option to spawn other drop down boxes elsewhere in the worksheet.
For example, if I have a box with:
- Red

I have linked cells from 2 different workbooks.
Since the absolute reference of the cell I linked changes (I add rows above
it and it re-calculates a sum), I named it and linked it with its name
instead of its reference to workbook 1.

I have searched Contextures.com, Excel help online, and this community and I
am baffled (been staring at this too long). I know the answer is simple, it
just escapes me.
Excel 2007-

I am a teacher and wish to enter a tick in a row next to a set of speadsheet
cell entries but cannot find one to insert. How can this be done please?

My data table is like this:
Date    BOX
3-Jan    6.16%
4-Jan    5.87%

I have another formula question for excel users.  What i am doing is making a
spread sheet.  On the first sheet i have the names of people on staff with
their sales.  i copied those names and sales over to the next sheet.  But on
the first sheet i want to put those names and ...

I am trying to use a cell to show one of two different inputs from two
different cells into one using vlookup.  I used 'or' did not work I used :
=IF(D10="","",IF(D10="",(VLOOKUP(D10,A228:F320,6)),IF(D11="","",IF(D11,"",(VLOOKUP(D11,A323:F391,6))))))
excell accepted but it does ...

I have an area for user input on sheet1. This area is 7 rows by 3 columns
(G15:I21). This area is not usually fully populated, but it could be. It
also could be populated vertically or horizontally:
input1 input2 input3

I have a need to format cells as currency, but have to do it in-cell. This is
just like =DOLLAR() except I need it to be a currency so that it can be
summed. I have tried a lot of different steps, but cannot get the cell to
format like currency without turning it into text. I ...