I have a mainframe job that creates a .csv file and ftp's it to an NT server.
It runs daily. The new file overlays the previous one.  I would like to
format the current file , then have each new file that is created have the
same format as the previous one.  We are using Excel ...

I copy a sheet from another workbook and paste it in the target workbook. I
then close the source and get a message about a large amount of data on the
clipboard.
Is there a way to supress this message or clear the clipboard?

I'm trying to use this formula, but its not working, what am I doing wrong?
=SUMPRODUCT(--('The Worker Be!'!A3:A99=C9),--('The Worker
Be'!d3:d99)=E7),'The Worker Be'!aa3:aa99)

I have a bunch of tabs in my spreadsheet and each one is named after a team
(i.e. BOS, NYR, VAN, etc.).  In column AA I have text and in column W I have
team names.  I would like a formula to lookup the text in column AA in the
tab of the team that is in column W.  For example in ...

I am trying to filter out data so it does NOT show data that starts with 2
numbers.  For example, I have data that can be 10REN, 32TREO, GREM, OPEE.  I
want to only see GREM and OPEE (data that doesn't start with numbers).  I
don't want to see the data that starts with 2 numbers. ...

Given a 'master' (Excel) spreadsheet, which has been applied to several
(or many) data sets.  Then, changes are made to the master.  Is there a
way to apply those changes to the other, already-loaded spreadsheets,
without needing to re-enter all the data?

How can i get excel to show requirement for validation?
For example I want people to type in a text max 15 characters, but I want
them to be able to see how many characters they can type. For example the
cell can show XXXXXXXXXXXXXXX and as they start filling it in they swap the X ...

cannot format Exel sheet - receiving error message "too many different cell
formats"
neither change border formats or fonts  - Exel 2003

I have been using a workbook for months and today I cannot use Data->Filter->
Autofilter because this option is not enabled. Any idea about this problem?
thank you very much

Does anyone know about Excel Add in for Crystal Reports? Is it available
anywhere to download?
Thanks.

I have a bunch of tabs in my spreadsheet and each one is named after a team
(i.e. BOS, NYR, VAN, etc.).  In column AA I have text and in column W I have
team names.  I would like a formula to lookup the text in column AA in the
tab of the team that is in column W.  For example in ...

I have a large spreadsheet that we need to update info all the way across
25-30 columns.  We tried hiding columns but then when we changed data say in
row W, it wouldn't let us unhide the other columns.
Can we use freeze?  Does anyone have a better idea.

I am trying to upload my resume to a recruitment agency website and when I
try to do it it comes up with an error that says "the file type you are
uploading to ......must be a doc extension. Please click on browse again and
select another file with the .doc extension". Can ...

When running the following Visual Basic code a run time error occurs
saying that there is a type mismatch.  The name txtRemoveSheet is from a
textbox.  My assumption was that it should be of type string and that
the Delete method accepted strings.  Is this assumption correct?  I

I have a list of email addresses which I would like to find only the
new email addresses within the list. Inside of my Excel worksheet I
have a row of e-mail addresses. Some of the names are duplicated which
tells me they already exist somewhere in the row. I wish to display