Hello there;

I am working on a project for some call stats and QA figures, and am
lost at trying to use VBA to calculate the functions that I need.

I am working with with three columns with many rows of data. The one
column (column D) has the previous weeks totals; column E has the
current weeks totals. in Column G, I am trying to find the difference
between the two previous columns to show the improvements made, if any.
The problem is that column E can contain the "0" (zero) or "Inactive"
labels and this is causing a problem with the usual SUM feature. What I
am wondering is if a VBA function or Macro is going to be needed to come
up with the following thinking:

If row X; column E has "inactive" or "0", then print column D inside
column G
Else
if row X; column E contains a number, then subtract column D from
column E and print to Column G

The problem is that I don't know how to reference the particular
columns within VBA for Excel, nor waht functions are needed. Can anyone
help clear this up for me, or help me to create a starting point to
create this feasability?

Thank you
Mikey
dakoris73


--
dakoris73
------------------------------------------------------------------------
dakoris73's Profile: http://www.excelforum.com/member.php...o&userid=34901
View this thread: http://www.excelforum.com/showthread...hreadid=546414