I have discovered that buttons in the row area remembers old values not
longer existing in the data.
Ex: I have 4 persons with initials "aaa", "bbb", "ccc" and "ddd"
I have the Initial button in the row area.

For example: say I want cell A3 to do a logic test and if cell A1 i
True th
en have it enter a 4 into cell A2.  I don't want to place any formula
in ce

ho do i add more sheets to  the "CURRENT" workbook,, not new workbook

A friend who works at a car dealership has asked me for some help with
an excel file he is trying to use.
The file has 8 sheet, of which 4 are for data input ( new cars, used,
commercial and other) and 4 are summary information sheet ( daily

What i want to do is really simple.
I have column B with 50 numbers. I want to set up column C so that in
C2, if B2=B1 and then it returns a value or something like false. It
really doesn't matter what it returns though.

I am using the macro below which I found in one of the threads to draw
data from a "Summary" sheet based on a helper column - "G" in
readiness for a chart.
I would like however to reuse this macro on any of the sheets within

As I change the numbers in each of 4 given cells,
I would like the 5th cell, holding the sum of the other 4 cells,
to keep a running total.
ex:  cell a1   today input 2, and the other 3 cells also 2

I need to create a spreadsheet that automatically fills in the
dates(weekdays
only) across the top.  There are six separate periods to be inputted.
The user inputs the start and end date of each period.

This may be a very simple / studpid question but I'm stuck and was hoping
someone could help me.
I am using a basic spreadsheet that adds up figures and calculates 15% from
a specifi set of figures.

can quattro pro 10  *.qpw files be opened with with excel 2003?

I am currently running Excel 2003.  I have 2 questions that I reall
hope someone could help with.
Actually it is a 2 part question, dealing for me with the same area.
What I am looking to do is create a button which I understand how t

We have been struggling with a buggy spreadsheet, and finally traced the problem
to a double-path range as follows:
A reference to an external range is normally defined by a formula like
'mypath\[myfile.xls]mytab'!cell1:cell2

I would like to automatically update a given cell, ex: C:1,
with whatever I put into any given cell within a range
ex  range D3:Z3
today I enter the number 3 into D3

the formula:
((AVERAGE(G3:I3))-35)*.80
NOW
I NEED (G3:I3) TO BE A RANGE OF CELLS

I have a large database from which I need to calulate a  significan
number of  "moving averages" of "variable" length.  As a simpl
example, consider a sequence of numbers in cells A1:A100. To calculat
a moving average of length 10, I can put =AVERAGE(A1:A10) into cell B