Need to copy all "values" or "constants" (not Formulas) from one sheet to
another sheet in a different workbook. I did the following:
Edit -->Go To then Special (from dialogue box) then "constants"
I see all the cells that I want are selected. Then I tried to use the copy

I have the following list - over 100 rows with 20+ columns of data --
I need a formula that will give me the data in a separate worksheet by
teacher name-subject with Lname Fname of student.
ANY help would be GREATLY appreciated --

When I try to use a different color font in Excel, all I get is black.
If I check the formatting on the cell, it says its red, but the text
appears as black.
This does not happen in Word, but it does happen in Outlook (I tried to

I have an Excel sheet created in Excel 2003 and saved as Excel 5.0/
Excel 2002... blah blah blah.   The workbook has 4 sheets and the last
2 sheets contain command buttons. When a coworker opens the workbook
using Excel 2003 everything is fine. When another coworker opens the

I managed to slowly build a code for my file and in it I used
'Application.Dialogs(xlDialogSendMail).Show.' for sending the file
from excel.
I like this as already managed to make (find and adjust to be honest)

I'm trying to figure out why there is a difference like this between
excel 2003 and 2007.  Perhaps there's a setting somewhere that I need
to change.
When I record a macro in 2003 to the personal workbook, that macro

I want to colour code certain cells in a spreadsheet according to which row
they are in: 21, 22, 75 etc etc. I have come up with the following
conditional formatting formula:
=NOT(ISERROR(FIND(RIGHT("00"&ROW(),4),"0021 0022 0075 0144 0149 0261 0262

My excel worksheet is missing rows 37-58.  There is a heavy gray gridline in
between rows 36 & 59.  Where did they go?  How do I get them back?

I have a bunch of data that came from stopwatch readings. Most of it
is under 10 minutes, but occasionally I will have a value as large as
several hours.
Is there a way in Excel, without writing a macro, to display time data

I've had those 2 little but annoying problems for quite a long time
while trying to create a graph for a business report. Any advice would
be very appreciated.
I try to report a value of an indicator over 3 different products in

I have timing data from a stopwatch.
The readout can be displayed in two ways:
1. Up to 40 minutes, the display contains mm:ss:dd, where mm =
minutes, ss = seconds, and dd = deciseconds (100ths of a second, not

I have a protected (real password... not just protection wihout
password..) template with a button who star a macro.  The macro change
some informations, use the filters and print the result. When I push
the button, the system ask for the password.

Finally figured out how to sort my information but this is my next question.
Everything is sorted alphabetically by the first column (Name)...when I
enter a new name now, will it automatically sort? Or - do I have to do this
exercise of sorting on a constant basis.

I have a column labeled date, in which some putz has typed in text, such as
"Closed", or "OnGoing". Some of the records actually have dates in them,
though. When I link to the sheet in Access, it sees that the first several
records are text and shows the field as text in Access, ...

Just need to be able to input a date in column A and B then get it to
calculate total days in column C across the columns and at the bottom of the
column