Here is a snip from an e-mail from one of my clients...
Our nurses have an excel folder that has one file for every resident.  Each
file for each resident is updated one time a month.  It is 728kb in size.
The files have quite a few check boxes.  The files are on our network drive.

I have 12 tables each consisting of 2 rows and 31 columns max.  Each
table details the date in the top row and number of staff at work in
the bottom row. So all 12 cover number of staff at work for year.
I need to identify the dates where staff numbers fall below 4 and

Upon openeing a new worksheet I would like to have the celformat of the
entire worksheet to have following default value:
Number
negative values in red

Is there a way to use the title of the spreadsheet as a cell value?
I asked this before in another topic, but there was no reply.
My sheet get's it's title from a database and is variable.
So if i can use the title i can strip several characters from the

Is there a way to use the title of the spreadsheet as a cell value?
I asked this before in another topic, but there was no reply.
My sheet get's it's title from a database and is variable.
So if i can use the title i can strip several characters from the

I just tried to open a Pocket Excel file on my Windows XP desktop and the
file could not be opened. Has anyone had any luck opening Pocket excel files
on a desktop PC without converting them?
Pocket Excel I believe is the .pxl format that the Handheld PC and the

I have a sheet that I am entering data into cells B:B
I have an event macro set up to auto time and date in adjacent cells A:A
I would like C:C to calculate the difference between cell b5-b4, b6-b5,
b7-b6 etc. etc.

Is there an easy way to accomplish the following?
Over the past 6 months I have made modification to an Excel Workbook that
resides on the File Server.  I have added Field Names in the Final Version
(which coincide with Field Names on SQL Server) that don't exist in earlier

Using 2003 - I need to count values in one row based on the value in
another row.
Example
I have row 2 that shows C G C G C G etc (stands for Contractor,

I have a column with email addresses. I'd like them grouped and sorted
by email address.
test@domain.com
smith@help.com

I am trying to populate a table based upon revenue from a closed
project.  I need the revenue to be divided by the number of quarters
in a year and have that revenue populate the apporpriate cell.
Furthermore, the formula needs to determine which quarters based upon

I have a series of data in rows (eg. in cells B2, C2, D2, E2...). I want to
pick these values up and use them else where in a table arranged in columns.
Therefore the formula in the first row (cell B2) will be =Sheet1!B2, the
second row (cell B3) will be =Sheet1!C2, the third row ...

When I copy and paste from Excel to Outlook I also get the gridlines
appearing,
How can I copy and paste my selection without having the gridlines
appear?

I have a column with times in the format 8:20am.
I tried to change the format for the column to military time ( which is
shows in the choices )but nothing happens.
I've tried changing individual cells and that didn't work either.

Here is a snip from an e-mail from one of my clients...
Our nurses have an excel folder that has one file for every resident.  Each
file for each resident is updated one time a month.  It is 728kb in size.
The files have quite a few check boxes.  The files are on our network drive.