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.

Are you saying that you want to subtract the value in cell H1 from each value
in cells B1:B20, but only if there is a sufficient value in each cell in
B1:B20 to avoid creating a negative balance?

"He cries for help" wrote:

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.

"JLGWhiz" wrote:

Are you saying that you want to subtract the value in cell H1 from each value
in cells B1:B20, but only if there is a sufficient value in each cell in
B1:B20 to avoid creating a negative balance?

"He cries for help" wrote: I do not care if there is sufficient value in cells B1:B20,
I want to see the negative values as well as the positive value. I just
don't want the cells to revert to previous values when entering a new value
in H:1






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.