I have formulas on multiple worksheets that reference to data on a primary
data worsheet (e.g. =DataSheet!$A$5). These multiple worksheets are forms
filled in with the data from the data worksheet. The problem I have is that
if the operator cuts and pastes some cells of data into ...

WHERE IS THE SHORTCUT KEYS FOR AVEAGE

Excel 2003
I've got a spreadsheet with hyperlinks to other spreadsheets existing
on a shared drive.
I used to be able to email this file to recipients with no problems.

My cell C6 contains  Vaughn
Sub FindCell()
With ActiveSheet.Range("B4:G9")
Set c = .Find(What:="Vaughn", LookAt:=xlWhole, _

I have a list of text like in a cell like this:
AA/DZ/EA
and I want to pull it out of one cell and put in into different cells like
this:

Is this possible.
In A1 I have a value  1000, in A2 I have -100 and In A3 +100 (A1 changes and
A2 & A3 create a range around the A1.
I have filtering criteria in A15  >a1+a2

I have a file that I need to open that was created in Excel 97 or an earlier
version.  When I try to open the file with Excel 2003, I get a message that
the file is in an "unrecognizable format."  Is there any need for special
software to open such files?  Unfortunately I do not ...

Ive created a customized menubar in my Excel VBA program.  Ive coded it the
menubar to be visible when workbook is opened.  My problem is this particular
workbook is being distributed to a number of users and I notice when I send
workbook to them my program errors out when it ...

I have a work sheet with several sheets in it.  The first sheet is a summary
sheet that is filled out basied on the last sheet.  It looks something like
this:
In A1 is the team name and in L1 is the win column.

With great help from you guys I created a macro which operates and refreshes
a group of pivot (cube) files.
I am trying to operate this macro file by a scheduler few times a day. The
only problem is the “Enable macros" prompt. I cannot set the security level

I have used the custom format to portray a date as Monday, 24 April 2007 in a
cell by using dddd, dd mmmm, yyyy
But what I want is for Monday to be on the first line by itself and 14 April
2007 to be on a second line.  In other words, is there some way to enter ALT

i try to add formula of "count if". the range is not from cell x to cell y,
but it is cell x, cell z & cell M, which are not sequential.

Where is the option Edit for Microsoft Excel 2007

We enter daily expenses into a spreadsheet.
We have a list of categories in one section (range) of the
spreadsheet.  How can I ensure that the category in the expense log is
one of the existing categories in the list?

I would like to know if it is possible to use data validation on a
field that is summing/totalling data.  IE  total 1+2+3=6.  is it
possible in the total field to use data validation so if the total
is