How can I control the value of one cell (A15) based on which option was
selected in an optionbox on a form?
Thanks,

Is there a way that I can use one cell as a quotient for a formula in a
column without editing the formula each time?
Example:
A12= 1.04

I am using Excel 2000
Recently I was very kindly helped to to formulate an address from a linked
spreadsheet.
This worked well BUT the man who keeps the database that the spreadsheet is

I'm trying to make a vb macro for a sheet in excel. The sheet has
inventory quantities in every other column. I would like for any
quantity count under "10" to turn red. Anything "10" or greater to stay
black. I'm not a programmer really. Could anyone suggest some syntax

I am stuck on the following problem:
I want to exclude names (or give them another color) from 1 column if they
are also in another column.
To illustrate this, the result from the following data:

I have 2 columns that I want to compare.  Want column 1 to see if there is a
matching number in column 2.  Then, I want the third column to say 'Match'
so I can identify which ones match.
How would I do this?

I have 2 separate worksheets. Worksheet 1 has 780 rows; worksheet 2 has 1779
rows. All 780 rows of sheet 1 are contained within sheet 2, but not
together - they are scattered among the 1779 rows.  Column C of worksheet 1
has data for each of the 780 rows that I need to transfer ...

I have a spreadsheet sent to me and in several cells when you click into the
cell to enter the data a box appears with the instructions as to what to
enter. It does not appear to be comment as it does not show an indicator. How
do make a note as described for a cell?

When I select entire column and click Sort Ascending on a toolbar, the
heading row I have is recognized in half cases and is not recognized in
another half. When it's not recognized, header row is considered as a
data and moves to the bottom of the table. This happen even when I

Do anyone know of a way to copy a file with a URL by using Excel?
I have a system that have a WEB based filing area for work files. The
URL to these files can be "pasted" to a Excel Spreadsheet, But HOW can
I download/copy the files to a different are, like local on my C:

I have a price list that has 4 columns of pricing for each part number (we
have 4 levels of distribution). The price in column C should be less than D;
D should be less than E; E should be less than F; and F should be less than
G.  There are over 1500 rows in this price list, so ...

How do I set up a formula to copy both value and format from one worksheet to
another?
When I use the = sign, it copy the value only. How do I get the format be
copied also?

I changed from MS Works 7.0 to MS Office 2003. I had created numerous
spreadsheet documents in Works. I started to convert them from Works to
Excel. I converted the first one by opening Excel, choosing File>Open. In the
Open dialog box, I clicked on the file I wanted, and it ...

Whets the formula for rounding to the nearest 10 please?
Thanks
Bill Ridgeway

When I paste my chart into msword, the bold type on the x and y axis is lost,
though the title remains in bold.