I am wanting to put together an equation that will do the following. I
buy sheet metal to be stamped into various parts and the sheets come
in 3 widths, 30", 36" and 48". They also come in different lengths of
96" and 120".

I have worked with pivot table for a long time now and i admit i can never
figure out how to get this part to work right. This is what my pivot table
looks like
Example

i have office 2008 for mac. in excel my active cell is a very light blue
making it difficult to see the it when navigating through my sheet. is there
any way to change this color? i have looked everywhere in prefs and even
looked thru help and online help. any suggestions?

I have two list of products in the following format:
LIST 1
PROD ID   PRICE
0998552    £1.04

I would like to have a drop down box which looks at a list on another sheet
[list name could be 'spell' OR 'math'] which is dependant upon the value in
another cell. i.e.
A1 has a drop box with values 'spelling' and 'maths'

I have constructed a large data base of material samples and use the VLOOKUP
function to generate various forms and reports.  I wish to include a bitmap
image on the form that changes with one of the variables.  Simply put, if the
form is describing an apple, I'd like a picture ...

The following macro i recorded to replace a value in sheet1 and sheet2.
Sub replas()
   Sheets(Array("Sheet1", "Sheet2")).Select
   Sheets("Sheet2").Activate

copy cell from D4361 and E4361 to paste in active selected cell

hi all! i'm experiencing problems writing a macro and hope that someone will
be able to help me out.
basically, i want to paste 2 cells which are side by side onto the relevant
empty cells. the 2 cells that i want to paste are filled with colors too.

Hi I have a formula below that I want to expand to more than one worksheet.
I've played with indirect from other examples but I just don't get it right.
In a summary worksheet I want to bring this total in for all worksheets.
=SUMIF('23050'!B2:B166,"*3220*",'23050'!C2:C166)

I would like certain text to appear (only once) in a cell in column A, three
rows after the last value is entered in that column.
i.e if the last value entered by a user appears in a3, I would like text
(say "Warning:") to appear in cell a6. If the user enters a value in a4, the

I have a spreadsheet with a 15 columns of text data.  
Ideally, when you hover over/click on a name in a cell in a column, say
column K.  I want it to look up the surname in the full list and display data
in that's in columns H, I,J in a box like a "pop ups" - a bit like a comment ...

What I am trying to do is count the number of days an employee works in a
row. Below is a sample of my data, it is exported from a discoverer query.
****Sample Data****
A         B                 C              D              E              F

i wrote a macro for formatting a spreadsheet. is there a way to add a button
to excel like in a menu or button on the shortcut menu bar that when you
click on it from ANY workbook it will run this macro?

I have a value range that I would like to return a single number for.  This
is the table I have in excel.
    A    B    C
1    10    21    15