Also see the responses to the posts in .misc and .worksheet.functions.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , mpjohnston
says...
I am trying to work a macro which will do the work for me (go figure).

Here is the easy example. I have a worksheet which has a 3 columns and
a bunch of rows: the column headings are " ", "total", "add-on"
the rows then consist of "mike","1,000","200"... then next row
"cindy","1,230","23" etc

{snip}