software

I have a vertically, names of peoples (20) and horizontally (15)
different objects. In each cell the total of objects for each person.

I would like to go to the different cells, run a macro maybe, enter a
value that will be added to the existing total in that same cell.

Is there a way to do this with a macro or do I need to go with
programming?
Den

something like
for each c in selection
c.value=c 124.56
next c

--
Don Guillett
SalesAid Software

quot;Denquot; gt; wrote in message
...
gt;I have a vertically, names of peoples (20) and horizontally (15)
gt; different objects. In each cell the total of objects for each person.
gt;
gt; I would like to go to the different cells, run a macro maybe, enter a
gt; value that will be added to the existing total in that same cell.
gt;
gt; Is there a way to do this with a macro or do I need to go with
gt; programming?
gt;
gt;
gt;
gt; Den
Duplicate your range of names amp; objects, then enter your incremental values
in this range. When done, copy the range of incremental values, select the
range of original values, and use Editgt;Paste Specialgt;Addgt;Valuesquot;Denquot; wrote:

gt; I have a vertically, names of peoples (20) and horizontally (15)
gt; different objects. In each cell the total of objects for each person.
gt;
gt; I would like to go to the different cells, run a macro maybe, enter a
gt; value that will be added to the existing total in that same cell.
gt;
gt; Is there a way to do this with a macro or do I need to go with
gt; programming?
gt;
gt;
gt;
gt; Den
gt;

On Thu, 20 Apr 2006 09:16:53 -0500, quot;Don Guillettquot;
gt; wrote:

gt;something like
gt;for each c in selection
gt;c.value=c 124.56
gt;next cNot sure I can follow you on that one, Don
I still struggle with functions and VB is still in the future. :-(
The solution given by Duke looks good to me and appropriate for my
present level of knowledge.

Thanks Don

Den

On Thu, 20 Apr 2006 07:23:01 -0700, Duke Carey
gt; wrote:

Yes! that's a solution and it should work well

Thanks Duke

Dengt;Duplicate your range of names amp; objects, then enter your incremental values
gt;in this range. When done, copy the range of incremental values, select the
gt;range of original values, and use Editgt;Paste Specialgt;Addgt;Values
gt;
gt;
gt;quot;Denquot; wrote:
gt;
gt;gt; I have a vertically, names of peoples (20) and horizontally (15)
gt;gt; different objects. In each cell the total of objects for each person.
gt;gt;
gt;gt; I would like to go to the different cells, run a macro maybe, enter a
gt;gt; value that will be added to the existing total in that same cell.
gt;gt;
gt;gt; Is there a way to do this with a macro or do I need to go with
gt;gt; programming?
gt;gt;
gt;gt;
gt;gt;
gt;gt; Den
gt;gt;