I'm having a problem with the criteria for a DSUM formual on a worksheet;
the workbook is a budget worksheet I got from a large non-profit that I'm
learnign and (hopefully) going to adapt for our use.
The worksheet in question is named Cash Budget.  One of the expense items is

I have the below code in use (thanks, L. Howard Kittle ) and noticed
that while my navigation is correct, every time I hit the enter key in
subsequent cells, I am annoyingly navigated to the RFP worksheet (which
I only need to do so once).  The code is below:

I have a file that contains carriage returns in some of the fields.  I would
like to get rid of the carriage returns and replace them with a different
character of some sort (a pipe or back-slash).  I have tried the replace
tool, but haven't had any luck with that -- even after ...

How do I divide one number by another and then multiply answer by the cot?
Example 896.96/115.74 *cot

I am new to the forum. I am wondering if it is possible to search for
multiple numbers in Excel at once. Lets say I have a very large spread
sheet with part numbers and I want to find 200 specific part numbers.
Is there a way to search for all 200 part numbers at once, an have

I have loads of data in excel of which I would like to plot on a map. I have
MapPoint and it is possible to embed a Map using the mapping icon which
appears after downloading the MapPoint SDK. The problem I have is it will
only embed a european map, i can't get it to open a ...

I want to subtract Column A from Column B and Column C be the result.  I've
been doing each row calculation and I know there is an easier way.

I have very little knowledge of Excel but am trying to rank a list of
numbers in a row (in the row below).
I want the highest number to be 1, the second highest to be 2, etc. each
number is in a different column.

Let's see if I can explain this. I have two sheets, the first sheet is
labeled 2005 and the second one is 2006.  In A1 thru A12 on both sheets is
Jan, Feb, Mar, etc.  On 2005 B1 thru B12 we have monthly values. On 2006 B1
thru B7 (as we are just now going into Aug.) we have ...

I've a column with a date written as follows 20060801. (first of august
2006)
I want to transform this date into 01-08-2006
Does anyone know how to do this?

Hello all!!,
how could spawn data on double-click on a new sheet over a pivottable in
Excel 2000?.
In Excel 2003 it's possible, but are there any options in Excel 2000?

I know that if you "paste special" an Excel worksheet object into a Wor
doc, the pasted sheet will mirror the data that is input in the sourc
document - however, I was wondering if anyone knows if it is possibl
to link such documents whereby you create formulas that link across th

Okay I have a spread sheet with the follwing columns:
Item           Warehouse           Last Sale
A                1                         50129
A                1                         60625

Excel and Powerpoint (even in Office 2007) make it ludicrously hard
(impossible?) to view two documents on multiple monitors. Even seeing them
side by side is unintuitive (compared to Word).
Will this be finally addressed in Office 2007? It wasn't as of the last beta

hi does anybody know of good websites for excel macros or vb