Subtracting figures in a column

Hi,

I am trying to figure out how I can continuously subtract a given number
from every entry in a column.

I want to be able to somehow be able to enter a number, say, in a cell and
in so doing would deduct that sum from every cell in that column. All the
numbers in the various cells of that column would change.
The next day I might enter another number in that cell again and it would
continue to deduct from that column.

In other words what I am trying to achieve is a kind of stock control where
the rows represent the various parts required for a particular task, so one
job might require 1 of everything in column A. The numbers of the various
components in each row may vary, so:

Row 1 Item 1 56
Row 2 Item 2 44
Row 3 Item 3 39

Somewhere, presumably row 4, cell 3 (in that example) I could enter a
number, say 2, and that would permanently change item 1 to 54, item 2 to 42
and item 3 to 37, so that next time I needed to deduct a sum, I could enter
another number and it would change that.

Any ideas?
--
Ron O'Brien

Select the cell that contains your number to subtract and click copy.
Select all the cells that are to be subtracted and then click Paste Special
- Subtract

"Ron O'Brien" wrote:

> Hi,
>
> I am trying to figure out how I can continuously subtract a given number
> from every entry in a column.
>
> I want to be able to somehow be able to enter a number, say, in a cell and
> in so doing would deduct that sum from every cell in that column. All the
> numbers in the various cells of that column would change.
> The next day I might enter another number in that cell again and it would
> continue to deduct from that column.
>
> In other words what I am trying to achieve is a kind of stock control where
> the rows represent the various parts required for a particular task, so one
> job might require 1 of everything in column A. The numbers of the various
> components in each row may vary, so:
>
> Row 1 Item 1 56
> Row 2 Item 2 44
> Row 3 Item 3 39
>
> Somewhere, presumably row 4, cell 3 (in that example) I could enter a
> number, say 2, and that would permanently change item 1 to 54, item 2 to 42
> and item 3 to 37, so that next time I needed to deduct a sum, I could enter
> another number and it would change that.
>
> Any ideas?
> --
> Ron O'Brien
>
>