Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible with a macro?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible with a macro?
something like
for each c in selection c.value=c+124.56 next c -- Don Guillett SalesAid Software "Den" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible with a macro?
Duplicate your range of names & 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 EditPaste SpecialAddValues "Den" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible with a macro?
On Thu, 20 Apr 2006 09:16:53 -0500, "Don Guillett"
wrote: something like for each c in selection c.value=c+124.56 next c Not 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible with a macro?
On Thu, 20 Apr 2006 07:23:01 -0700, Duke Carey
wrote: Yes! that's a solution and it should work well Thanks Duke Den Duplicate your range of names & 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 EditPaste SpecialAddValues "Den" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |