I have a data validation which uses a (dynamic) drop-down list of up to 1500
names.  Those names will not be entered alphabetically, and the worksheet is
protected and thus prevents the user from executing any sort to correct this.
But if it's not alphabeticized, it becomes ...

Can any1 help please...
How do I automatically copy information from one cell to another      i.e.  
I want a total in cell A1 to automatically appear in cell C1
Hope this makes sense.

i have excel 2007 ,i am trying to open files created in excel 2003 and these
files have macros in them but when i open them in 2007 i get an error message
"security warning Macros have been dissabled" even though i have set the
trust centre to Enable all macros .... Any ideas on ...

I have a table like the following and I need to look up the 3rd column
based on the first 2. Anybody has a simple solution? Thanks a lot!
A a 3
  b 5

When I retrieve a column of dates from a web query into Excel, it
returns the following:
2007-02-16 15:31:26
2007-02-16 15:39:18

I have a column of dates formatted as m/d/yyyy and another column of
times formatted as hh:mm:ss.  I would like to merge them into one
column.  When I concatenate to do this the format of the date changes
to a serial number and I can't get it to be formatted in m/d/yyyy.

I have a spread sheet with conditioanl formatting adding color to specific
data. I would like to sort by this fomat so all this data is together. Is
there a way to sort by formats?

All invoices are allocated a job number of which I have a different tab.
Is there a way I can sort these tabs into numerical order

I'm trying to set up a spreadsheet that tracks equipment being checked out,
and how much is left on a given day.  I was planning to do a sheet with a
calendar - months across the top, dates 1-31 down the side.  On the second
sheet, I have a info about who is checking out what on ...

I have a spreadsheet with 2 columns like this:-
Incident            Cause
Door Open         Tech Fault
Door Open         Public Error

I'm down loading a pivot table from portfolio analyzer and want the time
fields to cacluate weeks instead of days. Is there a way to do this.

Currently I have 10 pivot reports in one Excel spreadsheet.  I built in one
macro to go through and format all 10 reports for printing at one time ...
with the first tab report being the last report that's formatted.  The
problem is that if someone is on tab 4 and runs the macro, ...

My employer provides a database that I converted to excel with the following
values for dates...  example... 01/01/2006.
I need some help to build a formula to count the namber of cells that fall
within a range of dates... for example 01/01/1955 to 12/31/1977. How do I do

I want to maintain a database with list of issues, their severity and their
status...i have three columns.
On the top i'need to sum up all the issues with the severity "Critical" and
the status is "Open" similarly "Critical" and "Closed" status - i'm unable to

Hello everyone. I need help! What I need is a VLookup formula to insert a
letter grade into the last column on the second worksheet. Thank you!
Elizabeth
The following is on worksheet 1