Good evening,
how do I take a worksheet from one wookbook and insert it in a diffeent
workbook, thx in advance

If you have a string of dates in column A and numbers in column B, and the
dates cover several years,  is there a short cut way to write a formula and
have it sum or average the information in a particular month?  Thanks
Example

I have created a spreadsheet in Excel 2003. This spreadsheet lists
contractors and whether or not they have public liability or workcover
insurance. The spreadsheet shows what date their insurance expires on. I
would like to know if it is possible for the cells to change colour

I just started being unable to open excel files from "my recnet Documents"
list but they can be opened when a different user is logged on to the
machine. The excel files can be opened when I'm logged on by opening Excel
and going to file, open...

Is there any way for me to paste what visibly shows in a cell to what the
data actually is?  I have a cell that shows 1101  3/25.  It is formatted as a
fraction.  In the formula bar, the data shows 1101.12.  What I really want is
for the data to be text and show 1101  3/25.

Is it possible to set up a cell with a drop down menu selection of "Yes" and
"No" such that the selection of "yes" or "no" causes the spreadsheet to
display or hide additional cells with text.  I am trying to set up a form
that contains questions that can be answered as yes or no ...

Have a workbook with cells that are merged and wrapped.  The text in the
cells often exceed 256 characters.  I need to copy the information from one
workbook to another formatted exactly the same.  When I select the cell and
copy then paste into the equivalent cell in the other ...

Every time I perform a mail merge, the letters for those in Canada have a 0
for the zip code. How do I fix this so that their zip codes appear?
Thanks

My colleague pointed out that in excel selected menus and row / column
headers for selected cells were highlighted orange on my screen and grey on
his. I subsequently noticed this to be the case for Word (but not Access).
Anyone know why this is? Is there a way to customize this ...

 I am attempting to sort text within a cell. The text will mainly be
numbers, but the numbers may have some additional alpha characters in
front of it which do not affect the sorting order as only the numeric
values do. For instance, if I have the following

I have saved my excel file and have been able to open it until today.  The
file opens but the screen is blank.  In the toolbar, you can see and tab to
see what info is in the different cells, one at a time of course like normal
but there is no file to look at below the tool bar.  ...

can I make this function work over a number of rows, where the text is
not the same in each row? or does it work on 1 column / 1 row at the
time?
Thanks

How do I add periods to the ends of sentences in multiple cells at once?

I have two work sheets defined, Sheet1 column A contains a list of part
numbers.
Sheet 2 column A contains a list of part numbers.  
I would like to create a formula in Sheet1 column B that displays "True" if

I want to use red, yellow and green circles in a cell instead of the words
red, yellow, green.   Is there a way to do this?
Thanks,
Walter