I am trying to protect a worksheet, but still allow the users to "sort". I
have gone to the Protection dialog box and selected the select locked and
unlocked cells (where they can enter their data) and then I selected the the
Sort and the Use AutoFilter. I did put on a password.

I’m using the TransferSpreadsheet Action in my access macro db to
automatically transfer data to an Excel spreadsheet.  The data gets
transferred to the worksheet “qryRequirement _Status_NotComp_b” (Sheet 1).  
In my adjacent worksheet “Not Completed Requirement” (Sheet 2), have

In Excel...My rows are still numbers, but somehow columns are also numbers.  
So cell A1 is now cell R1C1.  How do I revert back?
Version 2003

I have a worksheet which is used solely for entering data, that data is then
moved to a list via a macro attached to a button. The data entry cell ranges
are as follows, (there are no formulas in any of these cells and the cells
are merged) "D2:I2,J2:O2,C3:F3,L3:M3,S3:T3,.etc..".

Hallo everyone,
I have 6000 data points, which is too much. The data points are aligned with
a time line. It measures 10 times a second. I want to take the average of
each second (so ten data points) how do I do that?

I was wondering if anyone can tell be a better way to do this. I am working
with financial information in Excel. I have roughly 50 locations and 5 years
history. The locations run done column A with the year in column B. I grouped
them so I only can see 2007 information, but and ...

Is there a function that will change the font color based on a value in a
field?

I am currently producing a worksheet which presents the number of
outstanding errors that are produced by a group of around 200 people. The
data is in a pivot table, but this is hidden as the layout is too rigid in a
pivot table. From the drop down I can select any area of the ...

I am currently producing a worksheet which presents the number of
outstanding errors that are produced by a group of around 200 people. The
data is in a pivot table, but this is hidden as the layout is too rigid in a
pivot table. From the drop down I can select any area of the ...

I use the Vlookup function in Excel to extract information from different
parts of a csv file imported from another program. The problem that I have is
that I need to change the cell range in the  Vlookup function each time I
import an updated file as the data will have moved ...

In my workbook I want to construct a formula that looks for matching data in
two tables, on two different pages and returns a value, as below.
Table 1
A1                   A2            A3

I would like to do a sum or count formula between a specific range for column
totals. If I use for eg sum(A2:A10) or Sum(A2:$A$10) they are both affected
when a row is inserted and the 10 is now changed to 11.
Is there a formula that can be used so in A1 I have my start row value ...

Looking to join within the same cell the contents of two cells, and
have lets say B1, display as is formatted in the originating cell?
A1=Happy
B1=Birthday (bolded)

I have this whole spreadsheet which i had to subtracted sum of YEAR 2 figures
from sum of YEAR 1 in the corresponding period.  
For example:
Pdt 1 Result = (Year 2 M3+M2)-(Year 1 M3+M2)

I need to calculated the TAT (Turn Around Time):
We receive particular task, which is needed to be completed in 06 working
hours. otherwise we need to give reasons for the delay. To find out
manually it takes lot of time for each task. That is the reasons i need this