what is meant by a reference area in an Excel worksheet ?

i have a list of deduction codes from 2 different systems on the same
spreadsheet.  i'm trying to compare the deduction codes from both lists to
see which employees had the deduction come out.  i know how to use
=isna(match(    to compare the deduction codes, but how can i ...

I need to calculate the difference between two dates/times.  The date/time
is entered in this format:
12/12/07 3:52 PM
When I simply subtract the end date from the start date, it gives me a

i have created a new Add-in in excel2003 with two new functions. What I
require is functions should return vlookup values from a particular table
which already there as a worksheet in Add-In. Can somebody help me please...
Thanks & Cheers -

I can't tell if another post is the same question or not - I guess I'm that
stupid.
Here's what I got:
CLIENT         INDUSTRY       SALES PERSON        COUNTRY     Q1      Q2    

Thanks for helping Roger, I realise I now have the reverse problem.( Sorry, I
realise I should have thought through this before but just learning now)
I think for my purpose, it will be better to move the data from spreadsheet
1 to spreadsheet 2.

How would I use a formula on work sheet 2 to automatically pull data from
worksheet 1 if a word in column 5 is ..............?

I have a spreadsheet that goes from a1 to gg150.  I need to print it out on a
wide carriage printer that has a roll of paper 36" wide.  I don't know how to
rotate the output 90 degrees so that the rows are along the 36" side and the
column are pinting out on the long side of the ...

I have some data in one spreadsheet which needs to be updated from another
spreadsheet, just in two columns out of 6. How can I do that ?
For examle the top rows of Spreasheet1 are Name of Site, PV's, UU's,
category, audience. The other spreadsheet has just Name of Site,PV's, UU's ...

Using answer below for Cell A1.
How can I alter the formula for as many cells as I like, say 100 cells
vertically?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

When I create a pivot table with two fields as row groupings (e.g., state and
county) the state is included in the output only when there's a change in the
state value.  Also, there's a subtotal for each state.  I want the state to
be on every row and I don't want subtotals.  By ...

Hi, anyone know the formula for below situation ?
1.I got two excel file => 1.xls & 2.xls
2.both of the file in column A have the customer name,but 2.xls got more few
customers name tat 1..xls dont have.

Within the pivot field i want to see the sum of a field (external list), but
the function returns "0".  "Count of" works fine and correct. The field is
formatted to number format. Any suggestions ?

I would also like to have a formula that would go into the "Grade Point
Average" column to give me the top student – then formula for the 2nd top
student, then the 3rd, on down to ten.  Thanks

I have a macro that list all the sheets i have and this listing will
hyperlink to all the sheets automatically. What i want instead is to have the
macro list alternate sheets instead, for ex, i have the following sheets:
Main           (Listing of all sheets)