Is it possible to copy a worksheet from one workbook to another workbook
without creating a link?

Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.
[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"
The above will formatt this $1,965,532 into this $2 Mil

Complex one here I think.....
I have a coumn of strings, for example:
CPSAINSBURYSAE0401001
CPAE0401001SAINSBURYS

when using autofilter for a certain item in a column containing 80+ rows, the
filter stops at a blank row (row 15) and you can see the remaining rows below
that haven't been filtered.
appreciate any and all assistance

I'VE CREATED A WORKBOOK WITH MANY WORKSHEETS. I'M WONDERING IF THERE'S A WAY
TO ALPHABETIZE THE SHEETS AUTOMATICALLY.  HELP!!! MY EMAIL IS
RSJAAG@COMCAST.NET

I need to have Excel calculate percentages of a cell based on where it falls
between numbers...for example:
Percentage of this number: (B2) $3,500.00
0 - 2500 = 25%               $0.00 (B4)

Is it possible, without VBA, to test the “emptiness” of a cell?  For example,
a formula that will return 1 if a cell is unused (has nothing in it), 2 if
the cell has a formula returning a null string:
=IF(1=1,””,””)

I have created a huge spread sheet for monitoring times and delays which are
entered multiple times everyday, 24-7.
The problem is, most people would like to enter the times in a more simple
format such as "military time"... instead of 05:30 PM or 17:30, they would

I'm using 2007.  
The Worksheet as 6000 line and subtotal of 2000. The subtotal is base on the
product number (C column) and I would like to have not only the product
number (C column) on the sub-total line but also the description (D column)

I need help an excel function/formula
Goal is to divide a number ex (40,50,60,75,87 etc) with specific constraints
say any number between 20 & 25 ex (65/(20>=&=<25))=3 to get a whole number
within that range.

I have a worksheet where I need the cells in Column C to turn yellow if the
cell in Column B is less than a cell in Column G. I used this formula for the
conditional formatting in C2 =IF($B$2<$G$128,1,0) and it does work. However I
need the whole column to have the same ...

I have a supply request form that has a picklist for the user initials and
when that is selected I would like another cell to populate with the user's
email address as a link so that the receiver can simply click on it when
their items arrive and let them know they are in.

I'm trying to merge two rows of cells in order to create an e-mail list. The
e-mail adress is the same for all but the prefix is different.
I am having some difficulty as '@' is stupidly a function symbol in Excel,
does anyone know a way around this?

All my worksheets now appear with numbers in the column labels. e.g. instead
of a cell reference being A1 it now appears as R1C1. When developing
formulas, the cell reference counts the number of positions I've moved the
cursor. For instance if I move two columns to the right and ...

I need to create a list and then when you click on an item in the list you
will be taken to the corresponding place in the speadsheet.
1.  # of students
2.  # of teachers