Within a macro I am trying to add 2 formulas to the bottom row of my
worksheet. The code is below and has allowed me to add static data.
Now I
need to do a count or countif (or something else)for column c that will
give
me the total number of rows that are "01". And for the final column i
want
to do a sum. Can anyone help?
01 150080380549 0000718649 000000095556
01 150080380549 0000718650 000000012000
01 150080380549 0000718651 000000002080
01 150080380549 0000718652 000000002912
02 150080380549 ???? ???
ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select
ActiveCell.Value = "02"
ActiveCell.Offset(0, 1) = "150080380549"
ActiveCell.Offset(0, 2) =
--
rstanger
------------------------------------------------------------------------
rstanger's Profile:
http://www.excelforum.com/member.php...o&userid=27811
View this thread:
http://www.excelforum.com/showthread...hreadid=473197