Hi,
I'm trying to figure out how to create a macro that will give the difference between column 3 and column 4, and then between columnn 5 and column 6, and so on. It's easy enough to use the Multi-Field Formula tool to do this for one column pair, but I have about 180 columns and would rather not have 90 instances of the Multi-Field Formula tool in the workflow. As an example, I'm starting with...
| Date | Order ID | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 |
1/1/16 | 156498 | 158 | 785 | 444 | 265 | 164 | 945 |
| 1/2/16 | 187485 | 145 | 141 | 189 | 779 | 762 | 126 |
| 1/3/16 | 187698 | 589 | 274 | 189 | 865 | 159 | 753 |
| 1/4/16 | 485976 | 893 | 568 | 458 | 452 | 168 | 173 |
...and would like to end up with...
| Date | Order ID | Column3 | Column4 | Column3_4Diff | Column5 | Column6 | Column5_6Diff | Column7 | Column8 | Column7_8Diff |
1/1/16 | 156498 | 158 | 785 | -627 | 444 | 265 | 179 | 164 | 945 | -781 |
| 1/2/16 | 187485 | 145 | 141 | 4 | 189 | 779 | -590 | 762 | 126 | 636 |
| 1/3/16 | 187698 | 589 | 274 | 315 | 189 | 865 | -676 | 159 | 753 | -594 |
| 1/4/16 | 485976 | 893 | 568 | 325 | 458 | 452 | 6 | 168 | 173 | -5 |
It seems like a Macro would be the best way to do this, but I'm open to other solutions. Thanks for the help.
