Somehow I turned off my sort button in excel 2007. Actually, all my options
in Data tab are disabled now and I want 'em back on. Any idea of how can I
make it?

What I want to do is have a drop down list of names.  After selected I would
like the macro to sort the various other sheets for the variable selected.  
Is there a way to build a macro like this?  Thank you.

I need to average a list of minutes and seconds in mm:[ss] format (the only
format that would display them properly):
0:35
0:40

I have a workbook that performs financial calculations on information
provided from another department. The calculations work wonderfully and the
formatting is good. However, in order to keep the workbook flexible, it is
preset to calculate up to 50 years worth of information. We ...

I have a spreadsheet with 2 columns. The first column is the start time and
the second is the end time. They are shown in military time. I want to
calculate the difference between the two so I can get hours worked but when
the time overlaps days I get no result. For example if a ...

When I select cells to copy with:    
Selection.Copy
What I must do to remove this selection?
I think it's easy but I cannot find how I remove this selection.

Ok, I've set up multiple work sheets in a work book and have referenced cells
from, we'll call it worksheet 1, on worksheet three.  I have them showing up
in the cell, however I am referencing three different cells from worksheet 1
into one cell in worksheet three and I am not ...

Is there a way to copy validation notes to a comment.
When you right click a high lightd text it doesn't give you a copy option
oldjay

I can not get the Control tab in the Format Control dialog box of a combo
box. How do I get my missing Control tab?

Hi,  
As  mentioned in subject.... I have to remove from one of my worksheets the
text Page 1 ,Page 2 etc... which are appearing in background over the content
in the sheet.

Hi there,
Sometimes the formula in the cell dissapears eg
=890/1000
I get 0.89 instead. but I would like to see the formula so I can refer to in

I have two worksheets that will be holding the same information, but in a
different order.  I would like to be able to type the data into worksheet1
next a specific heading and on worksheet2 it copies next to the same heading
(although its on a different row).  Hope ya can help!

I have results in random days. This next formula works perfectly when i have
a maximum "hole" of  7 days. The problem is when i have gaps of more than 7
days.
E157=IF(D157=0;"";IF(D157-D156<D157;D157-D156;IF(D157-D155<D157;D157-D155;SE(D157-D154<D157;D157-D154;IF(D157-D153<D157 ...

I have a workbook with two worksheets.
Worksheet 01 is the summary
Worksheet 02 is the form template.
I have a form button on Worksheet 02, I have tried to record a macro for the

I have been setting up a spreadsheet using validation list boxes and for some
reason the validation is being set up but it does not give you usual dropdown
list. It was working first of all, but I have since set up check boxes and a
combobutton and now my validation boxes do not ...