| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
create autosum macro along with notation on the side
I need to create a auto sum macro where it will not just auto sum the numbers
but also put the sum symbol for me as following. (p.s. the numbers might not be in a sequential cell order) 100 © ˆ‘©= 2100.00 200 © 300 © 400 © 500 © 600 © Basically, what I am trying to do is when I select the range of my numbers to be summed, i will first have a pop up window asking me "what number sequency would you like to start". Then, from there I can enter "c". Like above, it should put the "c" in circle around my selections. If I put 1 for the number sequency, then it will have "1" in circle instead of "c". Secondly, it will then have another pop up window and ask me "where is your destination cell?". From there, I will just click on the cell I would like the sum total to be located. After all that, I should have the result with "ˆ‘©= 2100.00" at my selected cell. Can anyone help me with this? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| How do I create a macro, that references another excel file ??? | Excel Worksheet Functions | |||
| How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
| Macro to create macro | Excel Discussion (Misc queries) | |||
| How do I create a macro of editing keystrokes? | Excel Discussion (Misc queries) | |||
Linear Mode
