I have a spreadsheet with about 20 columns in it.  I want to take the dollar
amounts of column T that have the same batch number in Column R and make a
sum of the numbers in Column T that have the same batch number in Column R.  
Does anyone have any idea how I can do this?

I would like to print Excel file properties like it is possible to do for
Word documents to show date created, saved, etc.  Is there a way to do this?  
Thanks for the help.

When I try to open a *.wk4 file in Excel 2003, I get the following message
"You are attempting to open a file type that is blocked by your registry
polici setting".
I used to be ble to open these before.

My boss needs me to do an IF statment on a spreadsheet. Here is what I need:
In the Column "Interest Rate" the cells are percentages 0.00%, 5.50%, 2.25%
and so on. In the Loan Type Column are the loan types depending on the
Percentage Rate.

I have two columns where there is a value in one of them ( column for
negative & the other one is positive ) I want to have a third column shows
the values of the 2 columns before, as I have 500 rows to look at. Can any
one help on this.

When I select a range of cells on my sheet I see the SUM in the status bar.  
Is there any way to transfer that sum into my spreadsheet (eg Paste) rather
than writing a formula explicitly?
Thanks

A pdf file can be embedded into a work sheet by the Insert/Object menu.
When the icon/control so produced is clicked the file opens with Acrobat
Reader which is fine.
There seems to be no way to prevent the user from moving or even removing

My stock of products are in four stores, for each store either I am over
stock or I am having a lower stock than the needed qty. I need a formula that
can transfer the products from the stores were I am over stock to the stores
that needs this stock. Can any one help with this.

I've created one dynamic named range to hold all values from cell D2
to last cell in column (so if user adds another value to bottom, named
range extends automatically to include that value).
Now, I'd like to create another named range which is a subset of the

I have the following data. I need to get the first set of data, then the 2nd
set and then 3rd. The problem is that the data will not be consistent, as you
can see below. Now, the data is gather with a formula, (1st formula)
=OFFSET(A1, MATCH("Line#Number  AmountReason For ...

In an Excel 2007 PivotTable, I want the dropdown list of Departments to match
the chosen Faculty (Faculty is the report filter).  In the default PivotTable
I have a listing of all the Departments at the institution.
I know I can separate the data and make several PivotTables but I ...

I already have a contact list made out that has 3 rows and I print it out
when I'm done adding/deleting. Everytime I add a new contact it moves the
list down off the page and I have to manually move each contact to the top of
each list. I want it to automatically move it to the ...

Greetings,
Can I get feed back on how to link information on two excell sheets.  
I have information on two sheets.  The information basis is the ID number,
but I need certain information to be included in both sheets or make a new

Dear
for Excel 2007. how can i add the following commands to Quick access toolbar:
Home>Font> Superscript
and

Does anyone know if there is a way to use the Grand Total column of a pivot
table to sort data in decending order?