Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How-to create macro?
Hi,
I would greatly appreciate the assistance of you Excel mavens. Here's what I would like to accomplish: 1) My rows that have a field that looks like this (no quotes): €œTaskName, 12+75+42+5+36€ a. Note that the numbers above (ie. 12+75+42+5+36 in this example) vary from row to row. For example, the cell in the next row might look like this (no quotes): €œTaskSize, 10+22+84€ 2) I would like to create a macro that would look at that cell and then do the addition on the numbers on the right (ie. 12+75+42+5+36 or 10+22+84), while ignoring the text on the left (ie. TaskName, ) (ie. Taskname comma space) 3) I would then like the macro to put the result of the math in a filed that is 5 columns to the right. This may be pretty easy, but I am not quite certain how to accomplish the parsing of the variable amount of numbers and plus signs within the field. My guess is that somehow Excel can read the cell form right to left, and then know to stop when it sees the €œ, €œ (ie. comma and a space). I look forward to your thoughts on this one. Regards, Brcobrem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
Using a macro to create a macro in another workbook | Excel Worksheet Functions | |||
could any one please tell me how can i create a macro that runs other macro | Excel Programming | |||
how to create a macro that runs other macro in the same workbook | Excel Programming | |||
Use existing macro to create another macro | Excel Programming |