subtracting from multiple cells
Hi,
One way by using formula. Create a helper column lets say in column C with
the data which is in A1,A2€¦.
In H1 is the remote cell by which you want to subtract a given number. Put
in A1 this formula =C1-H$1 and copy down.
You can either hide or put the helper column in a different sheet if you want.
Regards,
Tim
"He cries for help" wrote:
I am trying to subtract a given number from numerous cells i.e. A1,A2,A3,-6.
I want to do this from a remote cell by just entering a number. This cell
will be
used to update these cells (i.e. A1,A2,A3) on a daily basis.
The target cells should update with each entry.
Thanks in advance, as you can tell I am a Novice. I am more of a access user.
|