I have 13 columns of information and column A is Order Number.  What is
the best way to not enter the same order number twice, short of doing a
Find prior to entering it?  I was trying to do a conditional format
that if it equalled and other cell in column A, turn the cell

Hope you understand my terminology
I have a number of named ranges that I use a formula for in the "Refers
to" field.  The formula is actually larger than the space allowed in
this field and so the end of the formula is not visible when I want to

Hi, there. Recently, I need to copy and paste some data (with table) from the
Internet. However, the data I copied which contains value like 1-0, 2-0 etc
will change to date like Jan-00 and Feb-00 automatically. Well, even I've
tried to format the cell to text only before I paste ...

I'm stumped, I have no real idea on how to do this so any help much
appreciated!
I have a start date (no year ie, 1st December)
and an end date (again no year say 5th Jan),

I am trying to do a matrix that has real and imaginary numbers and I have no
clue how to do it. I can do a matrix with real numbers, but apparently can't
with the combination of both.

Is there any way of generating a "save as" file name from the contents of a
cell?
Jeff

Can anyone provide a VBA macro?
To compare two rows of  values, if the lower row value equals
the upper row value color both values green.
Need this across 70 columns

Say cell A1 the date is '01/09/2006' and i want to know how many days there
are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
the correct formula. thanks friends

I'm working on a program that enabled the user to insert data via forms
in VBE.
The data will then directly send to Excel worksheets as database.
Besides, the user can print the data in Excel sheets.

I have already wrote a vba routine for custom menu. It reads the level of
menu ranking level: 1, 2, 3 from my worksheet called MenuSheet. My MenuSheet
has 5 columns, namely Level, Caption, Macro, Divider and FaceID. I m trying
to add a submenu to a submenu and not sure the ...

Dear Excel Experts,
I need your help assessing whether the following project can be done
using Excel. I'm an Excel newbie and would greatly appreciate the
feedback. I just need a pointer in the right direction...

Hi, i have a column with a list of numers and letters, unsorted.  the
data in this column can be repeated, it goes like this
Col1
054T

I have a worksheet in which my data is arranged as per temp. I have
Temp in one column and the corresponding value in the other. I need to
inser
For eg.

I have an interesting problem.  I am trying to break out a quantity
number from a list of products from a cash flow.  On one row I have a
Product name, Quantity, Sales Price per Unit, and Total Sales Price
(Qty x SP per U) for my breakdown.  Also on this row I have a Beginning

Does anyone have a relatively precise method for calculating derivatives in
Excel.  There is of course the option of using the (A3-A1)/(B3-B1) to find
and approximation at B2, but does anyone have anything that is a bit more
reliable?