I try to copy/write excel files from a 3 1/2 floppy to disk and when i open
the file on disk it is "read"only.  I want to be able to woke with these
files and save changes.  The 3 1/2 floppy files are not "read" only.  What am
I doing wrong.

Access 2002, converting data from Access to Excel, numeric data shows
up with the horrid green arrows.  
I can change these one by one, but is there some way to change a whole
column of these entries at once? Changing them one by one is way

Hi. I am trying to build the following type of data and report...
In sheet1 I want to have an array where I have labels across row 1 and down
column a. Then in the associated fields, I will place an X if there is a
match.

The company I work for have a small majority of users who utilise Excel
2003's Routing Recipient feature for an expense reporting workflow process.
I've recently heard that this feature (Routing Recipient) has been removed
from Excel 2007... is this true??

How do I calculate the z factor automatically by trial & error
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Hi, The file has date formate as MM/DD/YYYY and I want to keep it that
way. Is there anyway the file can be sorted by only MM? I am trying to
sort by Jan, Feb, March...... November, December together.
Thanks,

I want to put a IF formula from a Macro. IE. cell= "=IF(a=b,"yes","no")"
However this give an error on the " sign. How to proceed?
regards,
Just

can you install watermark behind words on pages in excel?

I want to transpose a row of cells (containing a formula) from one worksheet
into a column of cells in another worksheet. How do I do this?

Hi Group,
Is it possible to have a 'something or other' which does the
following.....
I need to create a new worksheet every week which I enter data into. The

Having a few issues with VLOOKUP, basically if Part Numbers (ColumnD)
contains text and numbers it is okay, hoever, rows that just contain
numbers only or numbers and slashes or dots are showing as #N/A in
ColumnE, have searched on here (http://www.contextures.com/

In cel B1 a user has the posibility to choose from a dropdownmenu between
YES and NO.
In cel B2, I want Excel to look what have been choosen in cel B1.
If cel B1 is NO then i want that the user will be able to choose in a

Excel 2007 I had three very large sheet 70,000 plus rows. I arranged and
subtotaled these as needed and then copied only the subtotals by using
Find and Select > Go To special > visible cells only then copy and
pasted this info to a new sheet. When I save these in the 97-2003 ...

I have tried to find the right formulah, but failed.
I have three column
Amount A   Amount B    Amount C
30

I'm looking for some help. I'm trying to calculate the productivity of my
team via excel. What I need is to set an average so that if they complete 12
tasks within an hour this is 100% performance.
My two columns are Productive time (in minutes) and forms complete. If it