im trying to create a 'equipment selection' i would like to used drop down
boxes to select equipment from tables, i would then like to take the results
and put them into another 'final' work book to be printed.
can i put rules in cells to look at the cell link and copy in the ...

I need assistance please with calculating a rolling 12 month average.  Can
someone Help Please?  Thanks.
Mardi

I want to create a shorter version of the following code:
If Range("f17").Value = "Yes" Or Range("f17").Value = "yes" Then 'For
1st Sunday
   Range("f18").Value = ""

I have a workbook with an individual sheet for every month in the year. At
the end of each month, that month's sheet must be emailed corporate wide.
Presently, I copy that month's sheet to a new workbook and send that
workbook out as an email.

I have prepared a spreadsheet that has a macro(recorded) in it that when
invoked, opens another excel file.
Here is that code:
Workbooks.Open Filename:= _

I cant figure out how to get, let's say the top 10 recurring values for a
very large set of data.  I need to know which values occur most frequent.   I
have been able to get the mode but not the top ten modes.  Your help will be
appreciated.  Thanks!

The atan returns the angle (in radians) of a number, which in my case is in
the rise over run format.
Where either rise, run or both may be negative; the combinations of signs
place the true location of the

I'm in the process of learning VBA and am having some troubles writing
an excel macro to find all instances of a word (usually in conjunction
with other words) and delete the row containing it
essentially I'd like row 5 below to do the following:

I need to know how i can insert a "Sum If" Function in the Pivot table. As
there are only standard formulas in the options and Excel does not allow me
to input custom formulas.
I have my table as follows:

I want a text box to display when I click on a particular cell - how can I
make that happen?

I would like to save a file using a date the is a cell example follows:
In cel A2 is the date 04/02/07 and would like to create a macro to save the
file as 040207.  This need to be a macros as my employees are not very savvy
with computers. And when a human makes a mistake it ...

I need to consolidate 31 sheets on to one sheet in the same workbook.
Each sheet has 7 columns (they are all the same).  The range of data
that I need to consolidate from each sheet is always b5:h125.  The
issue that I'm having is that 3 of the columns are validated lists

Could anybody tell me how to amend the following code? Instead of
inserting the same link and text into the selected cell, I really need
it to create a link to the newest sheet (i.e. when the macro is run
more than once). So instead of linking to sheet "Template (2)'!A1"

I have a column of data with percentages of the total in the next column. I
now want to add a third column that shows the cumulative percentage of the
total. Something like:
   1    2       3

I was wondering if I can do the below with links in excel:
I want to create an application that will read an excel file that contains
the names of students in a course and creates a new excel file for each of
the students based on the source file. The name of each new excel file ...