My boss is afraid of Access, so I have to do my entire database in Excel, I
have 2 sheets that 2 different people will be entering data into, I need
these 2 sheets to become one for my boss to review but still have them
entering in their indivdual sheets and the data ...

In Column C of my spreadhseet I have a listing of elapsed days (the
difference between a date established in Column A and Column B (where column
A is a discharge date, and column B is the file closing date). Below is the
formula which exists in Column C, and it works just fine:

I want a function like =INFO() or =CELL() that returns the name of the
current worksheet, e.g. =CELL("WorkSheetName").  Is there such a function?

I have a Workbook with 10 sheets.  Each has approximately 8 or 10 Macros +
Links.  When the Workbook is opened, cell A1 is selected.  Each of the macros
listed on the left side opens an existing tab or worksheet, which is part of
the Workbook.  Each time a new sheet is opened, cell ...

Does anyone know of a Macro such as:  Auto_Open   or   On_Open.
I think there is something someplace in Excel or VB that has this command.
Please let me know where it is at, if there is one.  I can not find either in
Excel Help or VB Help.

I don’t think I expressed myself clearly.
The initial lookup formula (given below) works well and returns a value in M7.
=LOOKUP(L7,{0,15,15.1,15.4,15.5,15.9,16,16.9,17,17.9,18,18.9,19,19.9,20,20.9,21,21.9,22,22.9,23,23.9,24,24.9,25.0259},{"1.00","1.00","2.50","2.50","4.00","4.00" ...

Config - Vista Home Premium, Office 2007
I have the defaults as UK keyboard and Language to US.
The default worksheet in Excel 2007 is Right-To-Left.  How do I change
from Left-To-Right ?

Is ther a way that you can sum the totals in an unkown range based on a value
in another column? First column have values inputted by user. Second column
have a letter identifing what the value in the first column means (example
"U" means unit, "B" means branch, branch is the sum ...

Is there a way I can rank data in multiple ranges? Right now I have 4 data
sets that are a few columns apart from each other... I want to be able to
rank each sales amount in each column out of the total sales $ from ALL
Columns.

Column 1 contains the Year and Month for each currency.
Column 2 contains each currency, repeated for each year-month group.
Columns 3 through 33 contain the spot rate for each day of the month
I can set up a formula to capture two of the three above variables but run

I have 1's or 0's in row 3 , D E F G H I J
Col L sums D:J
If the sum of D3:J3 does not = 5 (col L), I want an "alert" in K3, such as:
=IF(L3<>5,"Alert","")

there used to be an MROUND function that did this but I don't think excel has
it anymore.  Any suggestions?

I need to create a PivotTable from an imported woksheet. I am having
two problems.
My Pivot Table is [Rows] Part Number [Columns] Month [Data] Order Qty
The purpose of the pivotTable is to Sum the order qty of said part

The formula below works sort of ok, but I now need to change the formula to
reflect what will be Augusts results, I'm getting the error formula too long.
Is there a way that this can be truncated at all?
The formula is as follows - the sheet contains results broken down by team

Howdy All,
I have a workbook with 6 worksheets in it that each contain the data for 6
departments.
The data format on each worksheet is identical.