D
dakoris73
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
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