I want to have a column that will populate another column in another sheet
only IF a criteria is met. Is that possible?

I want a cell to have a drop down list of options.  Do I have to create a
combo box for each cell I want this in, or is there a way to get the cell to
popup a few options when it's clicked?

This formula works correctly:
=SUMPRODUCT(--(AMS!$C$4:$C$60000="InitialOrderEntry");--(AMS!$Z$4:AMS!$Z$60000=17);--(AMS!$AB$4:$AB$60000=226);--(AMS!$AS$4:$AS$60000=$A$1))
When I add another condition --(AMS!$B$4:$B$60000=Summary!C3) the formula
returns zero - should return a number ...

I'm trying to highlight a cell if a certian condition is true.  I've done it
in the past, but forgot how.

In a sheet a have the following function :
Public Function feetAndInchToMeters(feet, inch) As Single
 Dim sngFeet As Single
 Dim sngInches As Single

I have the following formula in a cell =A4*$A$1 and when I try to sum the
column and maker it to 2 decimal places it rounds my total down and so I get
the incorrect total.  What do I need to add to the formula so it will not
round?

How do you reference a defined range (dynamic) on another sheet?
This doesn't work and several other variations I have tried. . . [
I]=LOOKUP(Sheetname!A1, RangeName) [/I
--

I have a Windows Excel program which calls a DLL. I'd like to add th
capability for Mac users to call shared libraries to do the same thing
MS says that you can do it, but offers no hints.
Any advice

I thnk part of my problem is that I'm not sure what type of financial
valuation I'm trying to find, but here is the basic scope:
1. My customer wants to buyout my contract with them early.
2. The contract is 36 months, with 7 months left (29 payments have been made)

How long, about, should it take to get a reply on this site?  I have had my
question up here for a couple of days and the only response I got was that it
needed to be more detailed.  I replied with more detail and nothing happened.
Thoughts?

I am comparing 3 columns and trying to find the maximum value of the columns.
But instead of just displaying the maximum value I would like it to show
which column the value is from.
OBS_ID    CLASS1    CLASS2    CLASS3

I need to use data in column A in one worksheet to match against columns B-H
in another worksheet to give me the value in column A of worksheet 2...is
this possible?
Thank you!!

is there any program that will help me,?

I tried but cannot get a formula to give me the result.
I am looking for a formula for ColH (Calc) that will do the following:
If Name1 OR Name2 is Fred And Type is A, For Side=Sell (PriceB-Price), For
Side=Buy (Price-PriceB)

I am exporting a database from access that contains more that 66000 rows. How
can I get excel to accept the entire database?