Hello, this is what i need to accomplish:
I have a workbook with a sheet named "template" and another sheet where
user can enter names in column A.
When button is pressed after all names entered, i want the button to

Is there a way to protect all of the worksheets at once.  When I use the
workbook protection it doesn't do what I need.
It seems the only way I can protect specific cells is to use the sheet
protection and this means one sheet at a time.

Good morning Gurus
I have a cell into which the following string is entered "14FEB2005"... This
is a value extracted from a file. This is currently being handled as a text
by Excel. What could be the formula I need to transform this value into a

I have a large spreadsheet which currently has 4000 * 12 cells in use each
with 3 calculations in nested if, hence 144,000 calc.
e.g.
If (A1 <> "",IF(SUMPRODUCT(--FRED),SUMPRODUCT(--FRED)," ")," ")

Hello,
I need some help with a multiple lookup function. I think there's a formula
that can be used as an array with either SUMIF or SUMPRODUCT but I can't
remember all the details.

I want to create a formular in a new numeric cell that removes spaces from
another cell ie 0800 123 456 result 0800123456

What formula do you need to add to the first or original cell to allow the
contents of the copied cells below in a column to change to the content of
the first or original cell?
How do you do this if only numbers are in the cell?

I am currently trying to reconfigure a dataset into something mor
managable for our regression needs.  The issue I am having is trying t
automate as much of the data transfer as possible.  The data set is se
up as follows (for example):

I have a spreadsheet of thousands of names. The names are typed in on
cell: last name, first name. Does anyone know how to split the name
into two different cells?
Thanks for your hel

I want to sort a table which contains the names of customers, dates an
transactions, such that when filtered it will contain only the lates
transaction of each customer. Customers should not be repeated.
any solutions??

I need to add nonblank cells (cells have text) in a column that equal the
criteria of another cell. So I want to add the cells in Column C that have
text but also equal the date in Column A (which is equal to the date in Cell
A1).

I have an Excel database that I'm querying. One of my fields has code
information: some are just numeric (88523) and some are alphanumeric (P5036).
When I get the results of my query, the alphanumeric fields are left blank.
The rest of the record is intact. I've tried various ...

we can sort the data entered in different rows, can we sort the data entered
in different columns ie column wise sorting.

I have 2 columns: Code and Description.
I created a drop down list allow users to select Description, How do I
display the code in cell instead of the description when users selec
from the description list?

I have a coulumn with dates:
DT
28-Jun-06
05-Jul-06