how do I calculate a continous  percentage return of two data points at fixed
intervals? example :  data set={12,50,03,59,22,....} , fixed
interval=2periods.
[(12-03)/12], [(50-59)/50], [(03-22)/03],....I'd like to do this in Excel 03

I need to create a new workbook to track what will amount to up to 7 phases
of development for about 300 deliverables.  My boss wants to be able to look
at this master list and see the history, by date...and misc. comments, of the
development of each Deliverable.  Lastly, he ...

I want to produce a template with a couple of boxes, one of which will
contain a name and the other, a reference number. How can I input the details
into a table which will then transfer the data to the template automatically?
I need to produce a new template for each name and ...

I use the following macro to insert a header onto a chart located in a
worksheet called "chart" based on a cell reference in a different
worksheet called "jur":
Sub RefHeader()

I have some worksheets named on the worksheet tabs. Is there a formula I can
add to a line of text that will return the worksheet name? For example
"Monthly Summary Sheet for [worksheet] 2006"
Marcus

can somebody point me in the right direction of starting an en external
application ie  microsoft outlook with an excel 2003 spreadsheet please
cheers
steve

Is it possible to determine with VBA the regional and language
options/setting? Thank's ahead.

My formatting tool bar has disappeared in Excel.  Whether I check or uncheck
in 'view toolbars' nothing changes.  I can view the formatting palette but
most the time the tool bar is much easier.

Hi...the end result that I am trying to accomplish is to list the names of my
employees that I have scheduled for each day.
A1 holds their names
B1 thru O1 hold the times that they should come in to work.

Lets say i sell an small excel workbook and i dont want people who buy
this aplicaiton distribute to others. How can i avoid this illegal
distribution on excel?
thanks

I would like to take each item in the .Names collection and check my code
to determine if I am actually using the Defined Name.
I can use ListNames to get the names, I know. But how can I iterate thru
the array and look for matches?

I chose page setup from file> sheet> print area
then..
I selected 2 seperated parts in sheet 1 to add it to the box of print area
this is what was typed in the box:

I have a table of data which includes and area number for each item (1
to 10) and a length for each item. I would like to find out how many
lengths are less than a specified threshold, in each area.
Is there a function in pivot tables that can tell me this?

I used to be able to right click to copy paste highlited cells, now nothing
comes up when right clicking

Folks,
Can you help me make my mind up on how to go about moving small blocks
of data from nearly 88 worksheets to one central worksheet.  I'm trying
to learn excel and VBA and I've found some examples using small