I have entered inventory numbers into a column i.e. B:1 thru B:20, I want to
enter a number in a remote cell i.e H:1 to subtract a value from cells B1
thru B:20.

The B:1 thru B:20 cellls will be added to daily, the H:1 cell will be used
to releve these cells of inventory from assembled product.

The H:1 cell entry must not change cells B:1 thru B:20 except with the
current numerical entry.

I really appreciate the assist and hope I was clear on my intent.

First, no need to post twice!

Now to the question you asked. This process would require a macro; it cannot
be achieved as you describe with formulas. The reason is that it would need
to trigger on an event. In reality, it's a really bad idea to try
implementing things like this. When you enter a number in H1 you want it to
change B1:B20. But there's no record of what was there before, or even if
they have changed. So how would you ever know if they had changed, or not,
or more than once ...? It's much better to enter each increment or decrement
amount into a separate cell and have a formula that calculates the end
result from the start value and all the increments/decrements.


"He cries for help" wrote in
message ...
I have entered inventory numbers into a column i.e. B:1 thru B:20, I want
to
enter a number in a remote cell i.e H:1 to subtract a value from cells B1
thru B:20.

The B:1 thru B:20 cellls will be added to daily, the H:1 cell will be used
to releve these cells of inventory from assembled product.

The H:1 cell entry must not change cells B:1 thru B:20 except with the
current numerical entry.

I really appreciate the assist and hope I was clear on my intent.