I have a problem that I'm sure can be easily fixed, but I don't know
how to do it.  I have a spreadsheet that we have to review each month,
with several columns of data.  In one column are vehicle numbers, and
a few columns over is mileage for that vehicle.  I need to check the

I have a spreadsheet with two sheets - a vendor sheet, listing the vendor
number, name and location, and a cost expended sheet including date, vendor
name, dollar amt, etc.  I've created a vlookup formula to match the vendor
names from both sheets and give me the location in ...

I have several workbooks and within these workbooks I have pivot tables. How
can I get all the pivot tables into one big "Pivot table"? I need all of the
data of the different pivot tables into 1 master pivot table...
Thanks!

I want to pull information from a list of data, but only the data that is
greater than 500,000.  In c1:c30 i have data and c13, c16, c28, c29 are less
than 500,000.  I i want to create a new list adjacent to the existing one
using only the values greater than 500,000 what ...

I know that it is possible to Name a formula, such that placing that Name in
a given location will cause that formula to run relative to that cell.  
Obviously, this is nice if one wishes to use the same formula throughout a
workbook/worksheet, while retaining the ability to ...

How can I create a box in excel which would apply to an entire row. What I
mean is I want to create an excel sheet for my sales team where they can give
discounts. I want to have a box to enter to discount % and the whole row
changes. Can anyone help me on this?

I want to run a macro after a specific cell value changes.
Cell A5 has a dropdown menu from which you have to choose one value.
After selecting I'd like a macro to start.
Have tried Event Workbook_Change but I'm doing something wrong because

I currently have the following formula :
=SUMPRODUCT(--(LEFT(Xfers!C:C,6)="834097"),(Xfers!H:H))
which this works great for items occurring in column c, but i also need it
to sum column H when column E's first 6 characters = 834097 but i don't want

When I go to Excel list to merge with form letter I am receiving a message
that says "dialog or data engine failure please try again later".  I cannot
get addresses to download nor get by this message. . . Help?

I have a 4 column worksheet sorted by column A (product name).  there are
3000 records in the worksheet. I need to create a page break based on a
change of the value in Collumn A.  The ultimate destination of the results
will be insertion into a word document with a page break ...

In Excel 2003, is there a way to keep, hold, lock the last row I have on page
1? I want to have the ability continue to add rows after that last row onto
the next page but keep the last row on page 1 exactly where it is.

Can anyone tell me why this piece of code is taking over five minutes to
execute. I actually don't know the total time it takes because I keep giving
up after waiting about five minutes...
   For Each cell In Range("B7:K500")

The numbers I want to total are in Column M
=SUMPRODUCT((Data!D$1:D$2550>=Lists!A13)*(Data!D$1:D$2550<Lists!B13)*(Data!J$1:J$2550="Saint Paul")*(Data!M$1:M$2550>0))
What I am trying to say is-
Look at the data in column D of the "Lists" worksheet.  When the value of

I am wanting to just e-mail one sheet out of my Excel spreadsheet how can I
do that?