Is there any way to compare data in two Excel spreadsheets? Let's say
I've got 10000 line items in one file and 9000 in another. I'd like to
find out which 1000 items are missing from the one file. Assuming that
I have a column with a primary key, is it possible to compare the two

You have values 1 to 10 in 10 cells. You then apply 2 tone formatting cells
based on highest and lowest value with the highest value color being grey
and the lowest value white. When doing this the cells will be colored in the
various tones of grey to white based on the values of ...

I have a file I created in Excel 2003, but in Excel 2000 when some of
the macros are run they give a Debug error....However, when you open
the debug window the line of code being referred to is in a different
macro to the on that should be running....

I need to add the columns from one Excel file to another Excel file. The
problem is that file A has 2506 rows and file B has 1825. The "missing"
681 rows in file B are spread out throughout the file, so if I just
paste everything from file B into file A, the rows don't align.

I have a list where columns B - H are totaled in column I, and columns J - P
totaled in column Q. In column R, I want to show the difference between I
and Q, but only if there is at least one entry in cols B - H, AND at least
one entry in cols J - P.

Hi everbody. I have a problem. There is a worksheet that sent
to me. I want to change the properties of cells or I want to make
operations( like summing cells). However I cant. It cant sum teh
values. And I want change the properties of the cells. If someone help

I know this is a perennial topic of discussion around here, but is
running multiple instances of Excel (using up multiples of the amount
of system resources Excel normally would) still the only way to get
Excel to run in two separate screens?

Hello, I work in an office where I do a lot of data entry. I recently
received a mess load of work to do where the data has to be calculated,
processed and recorded into Excel and then has to be put into a paragraph
form and recorded in a separate database.

My vb code is mysteriously aborting without any error or warning.
It's got me puzzled in the extreme.  The following code copies values
from cells from one sheet into the columns of a row on a second sheet
(with debugging stuff added):

I have a very large spreadsheet that I'd like to break down into multiple
worksheets. I have only three columns that I need repeated on each worksheet.
When I add new data to these columns on sheet one, I'd like that data to be
inserted into sheets 2 and 3 and so on.  I know I ...

I am using MROUND to the nearest 5.  And I need it to only round up.
Is this possible?
(this is a formula for sizing a container, so if the item's width is
22" for example, my container needs to be 25").

sometimes excel gives me the cell data I input already.
sometimes it doesn't.
How can I enforce the feature?
thanks.

i  that to design a macro in excel file such that when i open the excel file
the macro should read the names of all the folders present in 'my document'
folder and paste those read folder names on workbook sheet.
please help me out.

in Excel 2003, is there a way to set a cell, or a column, in a way
that a user can only enter a limited number of character in it?
For instance, I want a user cannot enter more than 10 character into
any cell of column C.

I have a worksheet with data on store sales:
StoreLoc        Date                  Sales$
A              10/28/2005             $100
A              11/04/2005             $150