I have a workbook with 12 worksheets in Excel 2000. Each worksheet relates to
a department (these are to do with hours)
I want to create 12 different workbooks, one for each department, and have
the data from the relative departmental worksheet in the original workbook

I have a long column with town state and zip code appearing like this
Farmington, CT 06032
can a macro be made, or is there a command that will take the last five
characters from each of these cells and put them somewhere else?

In MSWord, formatting can easily be set so that selected text is always in
capitals by Format>Fonts>All Caps.
Can text in Excel be similarly formatted?

I am sure there is a easy answer to this, but I have not been able to find
it. Is there a startup comand option that can be used to print a worksheet
from a desktop shortcut?
Any help would be appreciated?

I would like to open file, but I do not want to people saw this.
I have a code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim szukana As Range

When copying a sheet within a workbook, I sometimes  get a warning that the
formula or sheet contains a name, do you want to proceed.  Many times, the
name is my own name.  How do I get rid of these embedded names?

I am hoping that someone here might know how to increase the width of the
cell names in the Formula Bar in Excel.
I am running Excel 2003 and have many cell references/names that are 30 or
more characters in length.  The drop-down list is only approx. 12 characters

I'm running into a problem tryin to express time values properly.
What I want to achieve seems simple:  I have various time values and I
want to add them and express the result in minutes and seconds.  For
example, in A1, I have 00:00:46, in B1 I have 00:00:20, in A2 I have

I need a routine to put numbers on a ticket.
The numbers would be from 000 to 999. There would be 4 numbers on each
ticket and the same numbers would be repeated on the ticket stub.
Obviously the numbers can't repeat from 000 to 999.

I have a spreadsheet that I would like to reverse the row order, ie. the
last row becomes the first row and the first row becomes the last row.
Is there a method to do this in excel?
cheers,

In a cell, I have the current date in format -dd/mm/yyyy-. In the cell
below, I want to automatically insert the text Yes if this is the last
day of the month or No if it isn't.
What's the simplest way to do this?

I have a column of numbers in A, and a column of numbers in B.  There
are 180 numbers in A (A1:A180) and 130 numbers in B (B1:B130).  I need
Excel to find which numbers match up between columns, e.g look down
column A and find all the matching numbers in column B, then sort the

I am stumped on how to write an EXCEL formula that will sum the values
in one column based on multiple criteria from other columns.  Here is
the example.
I have these three colummn.

I am stumped on how to write an EXCEL formula that will sum the values
in one column based on multiple criteria from other columns.  Here is
the example.
I have these three colummn.

I have 2 cells:
A1 (yes or no value)
B1 (numeric value)
I want to apply conditional formatting to cell B1 that says if A1="yes" then